RMAN-20020: database incarnation not set

Estaba realizando pruebas de RMAN para retornar en un punto en el tiempo por medio de arch’s.
Cuando finalizaba la ejecucion del ciclo de pruebas tomaba un backup de los archives.
Luego de ello rompia la base, hacia el restore y comenzaba el recovery hacia un determinado punto en el tiempo.
Pero cuando estaba terminando un ciclo ocurrio un problema a la hora de tomar el backup de los arch’s.
El problema traia como consecuencia , no poder tomar el backup de los archives.
$ rman target / catalog=rman@catrman RMAN> run { allocate channel oem_backup_disk1 type disk ; allocate channel oem_backup_disk2 type disk ; allocate channel oem_backup_disk3 type disk ; allocate channel oem_backup_disk4 type disk ; 2> 3> 4> 5> } allocated channel: oem_backup_disk1 channel oem_backup_disk1: sid=646 devtype=DISK allocated channel: oem_backup_disk2 channel oem_backup_disk2: sid=651 devtype=DISK allocated channel: oem_backup_disk3 channel oem_backup_disk3: sid=654 devtype=DISK allocated channel: oem_backup_disk4 channel oem_backup_disk4: sid=642 devtype=DISK released channel: oem_backup_disk1 released channel: oem_backup_disk2 released channel: oem_backup_disk3 released channel: oem_backup_disk4 RMAN> backup as COMPRESSED BACKUPSET tag '$TAG' archivelog all format '/tsm/t2/t2p/diario/%T_%d_ARC_PRE_DBID%I_s%s_p%p_arc'; Starting backup at 17-MAY-11 current log archived RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 05/17/2011 15:03:58 RMAN-03014: implicit resync of recovery catalog failed RMAN-06004: ORACLE error from recovery catalog database: RMAN-20020: database incarnation not set
Que podria estar ocurriendo ?
Cuando terminas de realizar un recover de una base , el metodo para abrirla es bajo la sentencia:
ALTER DATABASE OPEN RESETLOGS;
Ahi la base sufrio una REINCARNATION.
Para solucionarlo , nos logueamos en el catalogo de la base de RMAN y ejecutamos la sentencia.
RMAN> reset database ; database incarnation already registered
Ejecutamos de nuevo el backup y vemos los resultados.
RMAN> backup as COMPRESSED BACKUPSET tag '$TAG' archivelog all format '/tsm/t2/t2p/diario/%T_%d_ARC_PRE_DBID%I_s%s_p%p_arc'; Starting backup at 17-MAY-11 current log archived using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 using channel ORA_DISK_4 channel ORA_DISK_1: starting compressed archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=1 recid=67 stamp=751382803 channel ORA_DISK_1: starting piece 1 at 17-MAY-11 channel ORA_DISK_2: starting compressed archive log backupset channel ORA_DISK_2: specifying archive log(s) in backup set input archive log thread=1 sequence=2 recid=72 stamp=751387889 ---- ........ ---- input archive log thread=1 sequence=39 recid=105 stamp=751387972 input archive log thread=1 sequence=40 recid=106 stamp=751387975 input archive log thread=1 sequence=41 recid=107 stamp=751387978 input archive log thread=1 sequence=42 recid=108 stamp=751387979 input archive log thread=1 sequence=43 recid=109 stamp=751387981 input archive log thread=1 sequence=44 recid=110 stamp=751387984 input archive log thread=1 sequence=45 recid=111 stamp=751387987 channel ORA_DISK_4: starting piece 1 at 17-MAY-11 channel ORA_DISK_3: finished piece 1 at 17-MAY-11 piece handle=/tsm/t2/t2p/diario/20110517_OT2W1NC_ARC_PRE_DBID2577376242_s19362_p1_arc tag=$TAG comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_4: finished piece 1 at 17-MAY-11 piece handle=/tsm/t2/t2p/diario/20110517_OT2W1NC_ARC_PRE_DBID2577376242_s19363_p1_arc tag=$TAG comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_3: starting compressed archive log backupset channel ORA_DISK_3: specifying archive log(s) in backup set input archive log thread=1 sequence=46 recid=112 stamp=751387990 input archive log thread=1 sequence=47 recid=113 stamp=751387993 input archive log thread=1 sequence=48 recid=114 stamp=751387996 ---- ........ ---- input archive log thread=1 sequence=66 recid=132 stamp=751388038 input archive log thread=1 sequence=67 recid=133 stamp=751388041 channel ORA_DISK_3: starting piece 1 at 17-MAY-11 channel ORA_DISK_3: finished piece 1 at 17-MAY-11 piece handle=/tsm/t2/t2p/diario/20110517_OT2W1NC_ARC_PRE_DBID2577376242_s19364_p1_arc tag=$TAG comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_2: finished piece 1 at 17-MAY-11 piece handle=/tsm/t2/t2p/diario/20110517_OT2W1NC_ARC_PRE_DBID2577376242_s19361_p1_arc tag=$TAG comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:11
Pudimos tomar el backup sin problemas.
One thought on “RMAN-03014: implicit resync of recovery catalog failed”
Comments are closed.