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-63d83ae1adbc3811259983/] 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-63d83ae1b047a220769940/] 2. Currently redolog …

I will share the solution for the ORA-01078 and ORA-29701 errors I got while starting the ASM instance. Error : [crayon-63d83ae1b0c94339548961/] Solution : 1. To …