In today’s article, we will learn how to migrate the current data directory to a different location in PostgreSQL. We can follow the steps below. …
Read More »
In today’s article, we will learn how to migrate the current data directory to a different location in PostgreSQL. We can follow the steps below. …
Read More »In this article, I will talk about how to recover accidentally drop, truncate or deleted table in Production database by using flashback in standby database. …
Read More »In today’s article, I will share the solution of the error given below when the delete obsolete command is run. Error: [crayon-647413dcb5800364042034/] Before deleting crosscheck …
Read More »Today we learn what Protection Mode Data Guard are and how to Change them. Data Guard protection modes are briefly described in the table below. …
Read More »ORA-01422: exact fetch returns more than requested number of rows error when SELECT INTO statement returns more than one value. Error Received: ORA-01422: exact fetch …
Read More »In today’s article, I will talk about how we can perform failover using DGMGRL. If we cannot reach the primary database, we connect to the …
Read More »In today’s article, I will tell you how to Active Oracle DataGuard Broker. If you have not installed Data Guard before, you can install it …
Read More »In today’s article we will talk about the PING[ARC1]: Heartbeat failed to connect to standby ‘teststby’. Error is 16057. Error: PING[ARC1]: Heartbeat failed to connect …
Read More »The following error is received because OOM Killer (Out of Memory Killer) kills Oracle through the operating system due to memory insufficiency. Error: PMON (ospid: …
Read More »In this article, I will talk about how to resize redo log files in Oracle. 1. We list the redo logs. [crayon-647413dcb6f79359884417/] 2. Currently redolog …
Read More »