CATALOG ARCHIVELOG FAILED WITH DIFFERENT DBID, HELP_ME
858658Apr 29 2011 — edited May 2 2011after restoring a backup of 1.2TB with success, it came time to recover, and how need the archives,
I look at the error appears. I'm not using catalog.
RMAN> catalog archivelog '/ u03/rman/archive/arch_ibm94ebi_1_1_ORA10G_20043_747780466.rman';
RMAN-00571: ============================================== =============
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ============================================== =============
RMAN-03009: failure of catalog command on default channel at 29/04/2011 11:33:02
ORA-19698: / u03/rman/archive/arch_ibm94ebi_1_1_ORA10G_20043_747780466.rman is from different database: id = 169869312, db_name = eORA10G
td up there as well, but he tells me that my archive has d = 169869312, db_name = eORA10G,
being that he is the archive backup of the database connected to target database: ORA10G (DBID = 3909485338, not open).
with absolute certainty, I even did the backup and I restored all the pieces, it seems that the header of my archive and dbid dbname are different .. : S
i try to restore:
RMAN> restore archivelog all from '/ u03/rman/archive/arch_ibm94ebi_1_1_ORA10G_20043_747780466.rman';
Starting restore at 29-APR-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid = 1089 = DISK devtype
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid = 1088 = DISK devtype
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid = 1093 = DISK devtype
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid = 1094 = DISK devtype
RMAN-00571: ============================================== =============
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ============================================== =============
RMAN-03002: failure of restore command at 29/04/2011 11:35:01
RMAN-06509: only SPFILE or control file restored from autobackup Can Be
anyone have any light?
as is possible with a backup rman allocate it to different DBID for files and datafiles backuppieces.
I can not believe!
1.2Tb 27hours in restore... :(