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. …

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. …

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 …

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. …

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 …

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 …

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 …

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 …

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: …

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 …