How to Start Data Guard Services
Starting data guard services is actually a reverse process of stopping data guard services by any ways. Let's see how we start the services along… Read More »How to Start Data Guard Services
Data Guard
How to Stop Data Guard Services
Stop Data Guard Is Broker Enabled? First of all, you need to know whether the data guard broker is configured, started and controls over the… Read More »How to Stop Data Guard Services
How to Resolve ORA-01196 and ORA-01110
ORA-01196 Saw errors ORA-01196 thrown by the database when trying to activate a standby database. SQL> alter database activate standby database; alter database activate standby… Read More »How to Resolve ORA-01196 and ORA-01110
How to Resolve ORA-16009: remote archive log destination must be a STANDBY database
Saw an error in the alert log.... Sat Mar 21 10:28:48 2015Errors in file /oracle/admin/ORCL/bdump/orcl_arc0_9548203.trc:ORA-16009: remote archive log destination must be a STANDBY databaseThere may… Read More »How to Resolve ORA-16009: remote archive log destination must be a STANDBY database
How RMAN List Backup in Standby DB
Recently, I created a controlfile for standby database in the primary database. After I mounted the newly created controlfile in the standby database. I tested… Read More »How RMAN List Backup in Standby DB
How to Resolve ORA-01034: ORACLE not available
ORA-01034 ORA-01034 means that the command you want to perform cannot be done in a stop, idle or shutdown database. If you're surprised by the… Read More »How to Resolve ORA-01034: ORACLE not available
How to Resolve ORA-16055: FAL request rejected
In Oracle MAA, data guard plays a very important role to secure our data on the remote location. Since it involves network and interconnection between… Read More »How to Resolve ORA-16055: FAL request rejected
How to Resolve ORA-00600 [3020] Stuck Recovery
When recovering standby database 8i, I met the following errors: SQL> recover standby database; ... ORA-00279: change 439587243345 generated at 11/24/2010 02:23:39 needed for thread… Read More »How to Resolve ORA-00600 [3020] Stuck Recovery
How to Resolve ORA-16826: apply service state is inconsistent with the DelayMins property
Here was a data guard incident: DGMGRL> show database standb Database - standb Role: PHYSICAL STANDBY Intended State:… Read More »How to Resolve ORA-16826: apply service state is inconsistent with the DelayMins property
How to Resolve ORA-16541: database is not enabled
ORA-16541 If you met ORA-16541 either on the primary or the standby side like this: DGMGRL> show configuration ORA-16541: database is not enabled Configuration details… Read More »How to Resolve ORA-16541: database is not enabled