-
Rman recovery from standby backup to Primary
Hi,
I have configured data gaurd for 9i database on Windows. I am backing up standby database and trying to perfom recovery on primary for a lost datafile.
I am getting error controlfile is older thatn datafile.
Please let me know if I am missing any step in the following procedure.
Backup at Standby site.
Recovery Manager: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Starting with debugging turned off
connected to target database: ORCL9I (DBID=1992448566)
connected to recovery catalog database
RMAN>
Starting backup at 24-AUG-06
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=24 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=49 recid=92 stamp=599052711
input archive log thread=1 sequence=50 recid=95 stamp=599053337
input archive log thread=1 sequence=51 recid=94 stamp=599053335
input archive log thread=1 sequence=52 recid=96 stamp=599053612
input archive log thread=1 sequence=53 recid=97 stamp=599053613
input archive log thread=1 sequence=54 recid=98 stamp=599053761
input archive log thread=1 sequence=55 recid=99 stamp=599058611
input archive log thread=1 sequence=56 recid=100 stamp=599058991
input archive log thread=1 sequence=62 recid=111 stamp=599132172
input archive log thread=1 sequence=63 recid=113 stamp=599132272
input archive log thread=1 sequence=64 recid=114 stamp=599132274
input archive log thread=1 sequence=65 recid=115 stamp=599148947
input archive log thread=1 sequence=66 recid=116 stamp=599149049
input archive log thread=1 sequence=67 recid=118 stamp=599218560
input archive log thread=1 sequence=68 recid=119 stamp=599218560
input archive log thread=1 sequence=69 recid=120 stamp=599218561
input archive log thread=1 sequence=70 recid=117 stamp=599218556
input archive log thread=1 sequence=71 recid=121 stamp=599219279
input archive log thread=1 sequence=72 recid=122 stamp=599219299
input archive log thread=1 sequence=73 recid=123 stamp=599224912
input archive log thread=1 sequence=74 recid=124 stamp=599224929
input archive log thread=1 sequence=75 recid=125 stamp=599227360
input archive log thread=1 sequence=76 recid=126 stamp=599227370
input archive log thread=1 sequence=77 recid=127 stamp=599235260
input archive log thread=1 sequence=78 recid=128 stamp=599235273
input archive log thread=1 sequence=79 recid=129 stamp=599239124
input archive log thread=1 sequence=80 recid=130 stamp=599239173
input archive log thread=1 sequence=81 recid=131 stamp=599239300
input archive log thread=1 sequence=82 recid=132 stamp=599240284
input archive log thread=1 sequence=83 recid=133 stamp=599240383
input archive log thread=1 sequence=84 recid=134 stamp=599240662
input archive log thread=1 sequence=85 recid=135 stamp=599240750
input archive log thread=1 sequence=86 recid=138 stamp=599301847
input archive log thread=1 sequence=87 recid=137 stamp=599301846
input archive log thread=1 sequence=88 recid=136 stamp=599301837
input archive log thread=1 sequence=89 recid=139 stamp=599301871
input archive log thread=1 sequence=90 recid=140 stamp=599302195
channel ORA_DISK_1: starting piece 1 at 24-AUG-06
channel ORA_DISK_1: finished piece 1 at 24-AUG-06
piece handle=C:\ORACLE\BACKUP\ORCL9I\DF_ORCL9I_20060824_S15_P1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:18
Finished backup at 24-AUG-06
Starting backup at 24-AUG-06
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=C:\ORACLE\ORADATA\ORCL9I\SYSTEM01.DBF
input datafile fno=00002 name=C:\ORACLE\ORADATA\ORCL9I\UNDOTBS01.DBF
input datafile fno=00004 name=C:\ORACLE\ORADATA\ORCL9I\EXAMPLE01.DBF
input datafile fno=00010 name=C:\ORACLE\ORADATA\ORCL9I\TEST1.DBF
input datafile fno=00009 name=C:\ORACLE\ORADATA\ORCL9I\XDB01.DBF
input datafile fno=00005 name=C:\ORACLE\ORADATA\ORCL9I\INDX01.DBF
input datafile fno=00008 name=C:\ORACLE\ORADATA\ORCL9I\USERS01.DBF
input datafile fno=00003 name=C:\ORACLE\ORADATA\ORCL9I\DRSYS01.DBF
input datafile fno=00006 name=C:\ORACLE\ORADATA\ORCL9I\ODM01.DBF
input datafile fno=00007 name=C:\ORACLE\ORADATA\ORCL9I\TOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 24-AUG-06
channel ORA_DISK_1: finished piece 1 at 24-AUG-06
piece handle=C:\ORACLE\BACKUP\ORCL9I\DF_ORCL9I_20060824_S16_P1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:36
Finished backup at 24-AUG-06
Starting backup at 24-AUG-06
using channel ORA_DISK_1
specification does not match any archive log in the recovery catalog
Finished backup at 24-AUG-06
RMAN-06497: WARNING: controlfile is not current, controlfile autobackup skipped
RMAN>
Recovery Manager complete.
**************************
Recovering datafile at Primary level. I took datafile offline and did the following steps from rman.
Recovery Manager: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Starting with debugging turned off
connected to target database: ORCL9I (DBID=1992448566)
connected to recovery catalog database
RMAN> restore datafile 9;
Starting restore at 24-AUG-06
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=21 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00009 to C:\ORACLE\ORADATA\ORCL9I\XDB01.DBF
channel ORA_DISK_1: restored backup piece 1
piece handle=C:\ORACLE\BACKUP\ORCL9I\DF_ORCL9I_20060824_S16_P1 tag=TAG20060824T090824 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 24-AUG-06
RMAN> recover datafile 9;
Starting recover at 24-AUG-06
using channel ORA_DISK_1
could not read file header for datafile 9 error reason 15
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/24/2006 09:35:30
RMAN-06094: datafile 9 must be restored
RMAN> exit
Recovery Manager complete.
An elephant is a mouse with an operating system.
-
Rename or delete datafile that you are trying to restore.
One, who thinks that the other one who thinks that know and does not know, does not know either!
-
Originally Posted by BV1963
Rename or delete datafile that you are trying to restore.
I deleted and renamed the datafile but it does not work.
An elephant is a mouse with an operating system.
-
Can you check before the recover command that file is actually restored?
One, who thinks that the other one who thinks that know and does not know, does not know either!
-
Originally Posted by BV1963
Can you check before the recover command that file is actually restored?
Yes, I am restoring the right file, it can be seen in the log that I sent.
An elephant is a mouse with an operating system.
-
It recovered the datafile using nocatalog.
An elephant is a mouse with an operating system.
-
An elephant is a mouse with an operating system.
-
opening thread, dont close threads here because other people may want to contribute
-
Originally Posted by anujdutt
It recovered the datafile using nocatalog.
????
maybe you need to recreate your catalog and start a new bkup.
---------------
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|