Tags

,

Datafile 1 (ckpscn 139334570249) is orphaned on incarnation#=2
MRP0: Detected orphaned datafiles!
Recovery will possibly be retried after flashback…
Errors in file /dir/USER/oracle/diag/rdbms/dir_odm/dir/trace/dir_pr00_2515124.trc:
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: ‘/dir/USER/oradata/dir/system01.dbf’
Slave exiting with ORA-19909 exception
Errors in file /dir/USER/oracle/diag/rdbms/dir_odm/dir/trace/dir_pr00_2515124.trc:
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: ‘/dir/USER/oradata/dir/system01.dbf’
Recovery Slave PR00 previously exited with exception 19909
Fri Sep 27 11:23:39 2013
MRP0: Background Media Recovery process shutdown (DBNAME)



PRODUCTION
RMAN> list incarnation of database;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time


1 1 DBNAME 347948142 PARENT 1 18-DEC-09
2 2 DBNAME 347948142 CURRENT 979911 24-MAR-10

STANDBY
RMAN> list incarnation of database;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time


1 1 DBNAME 347948142 PARENT 1 18-DEC-09
2 2 DBNAME 347948142 PARENT 979911 24-MAR-10
3 3 DBNAME 347948142 CURRENT 139333816441 26-SEP-13

RMAN> reset database to incarnation 2;

database reset to incarnation 2

RMAN> list incarnation of database;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time


1 1 DBNAME 347948142 PARENT 1 18-DEC-09
2 2 DBNAME 347948142 CURRENT 979911 24-MAR-10
3 3 DBNAME 347948142 ORPHAN 139333816441 26-SEP-13

RMAN> quit
Recovery Manager complete.

USER@host:/rbackup/USER/archive>mv 1_3_827150698.dbf ./removearc
USER@host:/rbackup/USER/archive>mv 1_1_827150698.dbf ./removearc
USER@host:/rbackup/USER/archive>mv 1_2_827150698.dbf ./removearc
USER@host:/rbackup/USER/archive>mv 1_4_827150698.dbf ./removearc
USER@host:/rbackup/USER/archive>mv 1_5_827150698.dbf ./removearc

sqlplus / as sysdba
SQL> recover standby database;
….
AUTO

-rw-r—– 1 USER dba 3145216 Sep 26 12:04 1_141309_714484088.dbf
-rw-r—– 1 USER dba 36864 Sep 26 12:13 1_3_827150698.dbf
-rw-r—– 1 USER dba 1024 Sep 26 12:13 1_1_827150698.dbf
-rw-r—– 1 USER dba 1024 Sep 26 12:14 1_2_827150698.dbf
-rw-r—– 1 USER dba 1354240 Sep 26 12:18 1_4_827150698.dbf
-rw-r—– 1 USER dba 1070592 Sep 26 12:19 1_141310_714484088.dbf
-rw-r—– 1 USER dba 3003392 Sep 26 12:32 1_5_827150698.dbf
-rw-r—– 1 USER dba 1056256 Sep 26 12:34 1_141311_714484088.dbf

SQL> alter database recover managed standby database disconnect from session;

Database altered.

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

PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS


ARCH CLOSING 1 141419 1 8
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 1 141420 2048 1268
ARCH CLOSING 1 141418 2048 388
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
RFS IDLE 1 141421 1218 1
MRP0 WAIT_FOR_LOG 1 141421 0 0

Advertisements