what the blog?

{upgrade in progress..}

4

MRP0: Background Media Recovery terminated with error 19909

How to solve ORA-19909 error when re-sync dataguard, when the standby database shutdown ungracefully, sometime you may found an error when you put the standby database back online, in this scenario, I try to active the standby database and flash back to standby mode in order to let standby database re-apply archive logs again.

Error message as below

MRP0: Background Media Recovery terminated with error 19909

ORA-19909: datafile 1 belongs to an orphan incarnation

Setup flashback recovery (on Standby DB)

SQL> alter system set db_recovery_file_dest_size=<size>;

SQL> alter system set db_recovery_file_dest=’<location to store the flash recovery area>’;

Defer log transmission on primary database (on Primary DB)

SQL> alter system set log_archive_dest_state_2=defer scope=both;

SQL> alter system archive log current;

Stop standby mode and create restore point (on Standby DB)

SQL> alter database recover managed standby database cancel;

SQL> create restore point my_resotre_point guarantee flashback database;

Activate standby database (On Standby DB)

SQL> alter database activate standby database;

SQL> alter database set standby database to maximize performance;

SQL> alter database open;

Once database opened without errors, shut it down (on Standby DB)

SQL> shutdown immediate;

Flash back to restore point and revert to standby database (on Standby DB)

SQL> startup mount;

SQL> flashback database to restore point my_restore_pint;

SQL> alter database covert to physical standby;

SQL> startup mount force;

Enable managed recovery mode on standby database (on Standby DB)

SQL> alter database recover managed standby database using current logfile disconnect from session;

Enable log transitions on primary database (on Primary DB)

SQL> alter system set log_archive_dest_state_2=enable scope=both;

Monitor MRP status

select process, status, thread#, sequence#, block#, blocks from v$managed_standby;

when you found

How to solve ORA-19909 error when re-sync dataguard, when the standby database shutdown ungracefully, sometime you may found an error when you put the standby database back online, in this scenario, I try to active the standby database and flash back to standby mode in order to let standby database re-apply archive logs again.
Error message as below
MRP0: Background Media Recovery terminated with error 19909
ORA-19909: datafile 1 belongs to an orphan incarnation
Setup flashback recovery
SQL> alter system set db_recovery_file_dest_size=<size>;
SQL> alter system set db_recovery_file_dest=’<location to store the flash recovery area>’;
Defer log transmission on primary database
SQL> alter system set log_archive_dest_state_2=defer scope=both;
SQL> alter system archive log current;
Stop standby mode and create restore point
SQL> alter database recover managed standby database cancel;
SQL> create restore point my_resotre_point guarantee flashback database;
Activate standby database
SQL> alter database activate standby database;
SQL> alter database set standby database to maximize performance;
SQL> alter database open;
Once database opened without errors, shut it down
SQL> shutdown immediate;
Flash back to restore point and revert to standby database
SQL> startup mount;
SQL> flashback database to restore point my_restore_pint;
SQL> alter database covert to physical standby;
SQL> startup mount force;
Enable managed recovery mode on standby database
SQL> alter database recover managed standby database using current logfile disconnect from session;
Enable log transitions on primary database
SQL> alter system set log_archive_dest_state_2=enable scope=both;
Monitor MRP status
select process, status, thread#, sequence#, block#, blocks from v$managed_standby;

MRP     WAIT_FOR_GAP     1     2221    0    0

you may try to copy those gapped archive log from primary database to standby database manually.

oracle

levin • September 2, 2009


Previous Post

Next Post

Comments


    Warning: call_user_func() expects parameter 1 to be a valid callback, function 'griffin_comment' not found or invalid function name in /u01/mydream.com.hk/wwwroot/blog/wp-includes/class-walker-comment.php on line 174

    Warning: call_user_func() expects parameter 1 to be a valid callback, function 'griffin_comment' not found or invalid function name in /u01/mydream.com.hk/wwwroot/blog/wp-includes/class-walker-comment.php on line 174

    Warning: call_user_func() expects parameter 1 to be a valid callback, function 'griffin_comment' not found or invalid function name in /u01/mydream.com.hk/wwwroot/blog/wp-includes/class-walker-comment.php on line 174

    Warning: call_user_func() expects parameter 1 to be a valid callback, function 'griffin_comment' not found or invalid function name in /u01/mydream.com.hk/wwwroot/blog/wp-includes/class-walker-comment.php on line 174

Leave a Reply