Posted by Sundaravel Ramasubbu Issue: PING[ARC1]: Heartbeat failed to connect to standby ‘STANDBY’. Error is 16191. Sat Aug 06 02:06:52 2011 Error 1017 received logging on to the standby [...]

Posted by Sundaravel Ramasubbu Introduction : In this session we will see How to set up Data Guard Broker. NOTE: Environment in my case Prerequisite Check DG_BROKER_START parameter on Primary and [...]

MRP0: Background Media Recovery terminated with error 448 Recently encountered ORA-00448: normal completion of background process Managed Standby Recovery not using Real Time Apply due to [...]

We faced the error ORA-16057 while building a standby database.archives were not shipping to the DR site Now in the production database, Select dest_id,error from v$archive_dest;   [...]

In a active standby database we had a problem due to temp tablespace. So we increased the temp tablespace by adding a 10G tempfile in the primary database. SQL> select name from v$tempfile; [...]

We got the below error on a active standby databse ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 73: [...]

We have got a error from OEM “The Data Guard status of xxxx is Error ORA-03135: connection lost contact.”After that, we have resolve the error using below steps, Step:1 [...]

Message: ORA-00309: log belongs to wrong database Cause: The system cannot access the archived redo log because it belongs to another database. Action: Specify the correct redo log file, then [...]

Error: RFS[4]: No standby redo logfiles of size 102400 blocks exist Fix: In standby database, standby redo logs on the standby database and the online redo logs on the primary [...]

SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; Check for messages/errors SELECT MESSAGE FROM V$DATAGUARD_STATUS; [...]