RMAN-03014: implicit resync of recovery catalog failed

RMAN-20020: database incarnation not set

file under Holy Fuck

Image by emdot via Flickr

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.

About Juan Andres
Consultant | Oracle DBA & IT Specialist | LinuxUnix Administrator | Father | Musician | Farmer | Environmentalist | Writer | Builder | Buenos Aires · burzaco.wordpress.com

One Response to RMAN-03014: implicit resync of recovery catalog failed

  1. Pingback: RMAN-03014: implicit resync of recovery catalog failed + RMAN … : Blogoogler.com

%d bloggers like this: