Stop and Start Recover managed Standby Database

 

To start Redo Apply in the foreground, issue the following SQL statement:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;

 

To start Redo Apply in the background, include the DISCONNECT keyword on the SQL statement

 

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
Database altered.
SQL>
Alert log contents while recovery manager process starting
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT
Thu Oct 2 15:01:44 2014
Attempt to start background Managed Standby Recovery process (drdb)
MRP0 started with pid=30, OS id=1966
Thu Oct 2 15:01:44 2014
MRP0: Background Managed Standby Recovery process started (drdb)
Managed Standby Recovery not using Real Time Apply
Thu Oct 2 15:01:49 2014
SUCCESS: diskgroup IDXGRP was mounted
Thu Oct 2 15:01:50 2014
Errors in file /u01/app/oracle/admin/drdb/bdump/drdb_mrp0_1966.trc:
ORA-00313: open failed for members of log group 21 of thread 2
ORA-00312: online log 21 thread 2: '+DATAGRP/drdb/onlinelog/redo_log32.log'
ORA-17503: ksfdopn:2 Failed to open file +DATAGRP/drdb/onlinelog/redo_log32.log
ORA-15173: entry 'redo_log32.log' does not exist in directory 'onlinelog'
Thu Oct 2 15:01:50 2014
Errors in file /u01/app/oracle/admin/drdb/bdump/drdb_mrp0_1966.trc:
ORA-00313: open failed for members of log group 21 of thread 2
ORA-00312: online log 21 thread 2: '+DATAGRP/drdb/onlinelog/redo_log32.log'
ORA-17503: ksfdopn:2 Failed to open file +DATAGRP/drdb/onlinelog/redo_log32.log
ORA-15173: entry 'redo_log32.log' does not exist in directory 'onlinelog'
Thu Oct 2 15:01:50 2014
Clearing online redo logfile 21 +DATAGRP/drdb/onlinelog/redo_log32.log
Clearing online log 21 of thread 2 sequence number 415744
Thu Oct 2 15:01:50 2014
Errors in file /u01/app/oracle/admin/drdb/bdump/drdb_mrp0_1966.trc:
ORA-00313: open failed for members of log group 21 of thread 2
ORA-00312: online log 21 thread 2: '+DATAGRP/drdb/onlinelog/redo_log32.log'
ORA-17503: ksfdopn:2 Failed to open file +DATAGRP/drdb/onlinelog/redo_log32.log
ORA-15173: entry 'redo_log32.log' does not exist in directory 'onlinelog'
Thu Oct 2 15:01:50 2014
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT
Thu Oct 2 15:01:50 2014
Errors in file /u01/app/oracle/admin/drdb/bdump/drdb_mrp0_1966.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 21 thread 2: '+DATAGRP/drdb/onlinelog/redo_log32.log'
Thu Oct 2 15:01:50 2014
Clearing online redo logfile 21 complete
Media Recovery Waiting for thread 2 sequence 415746 (in transit)

 

To start real-time apply, include the USING CURRENT LOGFILE clause on the SQL statement. For example:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE;

Confirm

SQL> SELECT RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS; 

RECOVERY_MODE
-----------------------
MANAGED REAL TIME APPLY
IDLE
IDLE
IDLE
...

 

To stop Redo Apply, issue the following SQL statement in another window:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

 

Alert log contents while cancel command is happening
Media Recovery Waiting for thread 1 sequence 223592 (in transit)
Thu Oct 2 13:21:44 2014
Recovery of Online Redo Log: Thread 1 Group 50 Seq 223592 Reading mem 0
 Mem# 0 errs 0: +DATAGRP/standby/onlinelog/group_50.263.859832985
Thu Oct 2 13:22:27 2014
Media Recovery Waiting for thread 2 sequence 415745 (in transit)
Thu Oct 2 13:22:27 2014
Recovery of Online Redo Log: Thread 2 Group 54 Seq 415745 Reading mem 0
 Mem# 0 errs 0: +DATAGRP/standby/onlinelog/group_54.273.859833505
Thu Oct 2 13:51:08 2014
Primary database is in MAXIMUM PERFORMANCE mode
RFS[498]: Successfully opened standby log 51: '+DATAGRP/standby/onlinelog/group_51.264.859833023'
Thu Oct 2 13:51:35 2014
Media Recovery Waiting for thread 1 sequence 223593 (in transit)
Thu Oct 2 13:51:35 2014
Recovery of Online Redo Log: Thread 1 Group 51 Seq 223593 Reading mem 0
 Mem# 0 errs 0: +DATAGRP/standby/onlinelog/group_51.264.859833023
Thu Oct 2 14:50:54 2014
Primary database is in MAXIMUM PERFORMANCE mode
RFS[497]: Successfully opened standby log 53: '+DATAGRP/standby/onlinelog/group_53.272.859833469'
Thu Oct 2 14:51:08 2014
Media Recovery Waiting for thread 2 sequence 415746 (in transit)
Thu Oct 2 14:51:08 2014
Recovery of Online Redo Log: Thread 2 Group 53 Seq 415746 Reading mem 0
 Mem# 0 errs 0: +DATAGRP/standby/onlinelog/group_53.272.859833469
Thu Oct 2 15:00:30 2014
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Thu Oct 2 15:00:30 2014
MRP0: Background Media Recovery cancelled with status 16037
Thu Oct 2 15:00:30 2014
Errors in file /u01/app/oracle/admin/drdb/bdump/drdb_mrp0_818.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovered data files to a consistent state at change 8198667010
Thu Oct 2 15:00:39 2014
SUCCESS: diskgroup IDXGRP was dismounted
Thu Oct 2 15:00:40 2014
Errors in file /u01/app/oracle/admin/drdb/bdump/drdb_mrp0_818.trc:
ORA-16037: user requested cancel of managed recovery operation
Thu Oct 2 15:00:40 2014
MRP0: Background Media Recovery process shutdown (drdb)
Thu Oct 2 15:00:40 2014
Managed Standby Recovery Canceled (drdb)
Thu Oct 2 15:00:40 2014
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL

 

 

SQL> SELECT RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS;

RECOVERY_MODE
-----------------------
MANAGED
IDLE
IDLE
IDLE
...

 60 minutes delay
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DELAY 60DISCONNECT;


 

How confirm synchronization please check the link 

https://oracleracdba1.wordpress.com/2012/09/18/how-to-confirm-dataguard-synronization-replication-status/

 

 

 

 

Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Oracle DataGaurd. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s