Unable to perform recovery from RMAN backup [message #407173] |
Mon, 08 June 2009 23:08 |
kesavansundaram
Messages: 183 Registered: October 2007 Location: MUMBAI
|
Senior Member |
|
|
dear sir/madam,
this is kesavan, doing just testing , trying to recover the rman backup in diff machine.... and iam not able to perofrm the recovery....while restoration done successfully ....pls chk the below stesp which i have done...
[CODE]C:\>rman target sys/sys123
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jun 9 09:08:11 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: SBIWILL1 (not mounted)
RMAN> restore controlfile from 'C:\RMAN_BACKUP\O1_MF_S_688997437_52SDM6Y8_.BKP' ;
Starting restore at 09-JUN-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\CONTROL01.CTL
output filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\CONTROL02.CTL
output filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\CONTROL03.CTL
Finished restore at 09-JUN-09
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
in target db( @mount stage), iam checking the following things.....
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 243 52428800 1 YES INACTIVE 15080744 07-JUN-09
5 1 242 62914560 1 YES INACTIVE 15027262 07-JUN-09
3 1 241 52428800 1 YES INACTIVE 14991069 06-JUN-09
2 1 244 52428800 1 NO CURRENT 15120232 08-JUN-09
SQL>
SQL> select * from v$recover_file;
FILE# ONLINE ONLINE_ ERROR CHANGE# TIME
---------- ------- ------- ----------------------------------------------------------------- ---------- -----
1 ONLINE ONLINE FILE NOT FOUND 0
2 ONLINE ONLINE FILE NOT FOUND 0
3 ONLINE ONLINE FILE NOT FOUND 0
4 ONLINE ONLINE FILE NOT FOUND 0
5 ONLINE ONLINE FILE NOT FOUND 0
6 ONLINE ONLINE FILE NOT FOUND 0
7 ONLINE ONLINE FILE NOT FOUND 0
8 ONLINE ONLINE FILE NOT FOUND 0
9 ONLINE ONLINE FILE NOT FOUND 0
10 ONLINE ONLINE FILE NOT FOUND 0
11 ONLINE ONLINE FILE NOT FOUND 0
11 rows selected.
now iam performing the restoration in RMAN prompt....
(1) iam just clearing the sbt tape settings, as iam takign the source from disk.
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' clear;
CONFIGURE DEVICE TYPE 'SBT_TAPE' clear;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'C:\RMAN_BACKUP\RB_SBIWILL1_%t_%s_%t';
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'C:\RMAN_BACKUP\RB_SBIWILL1_%t_%s_%t';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFSBIWILL1.ORA'; # default
nwo iam running restore script....
RMAN> run
2> {
3> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\SYSTEM01.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\SYSTEM01.DBF';
4> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\USERS01.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\USERS01.DBF';
5> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\TBS2.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\TBS2.DBF';
6> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\SYSAUX01.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\SYSAUX01.DBF';
7> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\UNDOTBS01.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\UNDOTBS01.DBF';
8> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\TBS3.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\TBS3.DBF';
9> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\TBD03.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\TBD03.DBF';
10> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\UNDOTBS03.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\UNDOTBS03.DBF';
11> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\EXAMPLE01.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\EXAMPLE01.DBF';
12> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\TBS01.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\TBS01.DBF';
13> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\UNDOTBS02.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\UNDOTBS02.DBF';
14> RESTORE DATABASE;
15> SWITCH DATAFILE ALL;
16> }
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 09-JUN-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=152 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=156 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\UNDOTBS01.DBF
restoring datafile 00003 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\SYSAUX01.DBF
restoring datafile 00008 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBS3.DBF
restoring datafile 00011 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBD03.DBF
channel ORA_DISK_1: reading from backup piece C:\RMAN_BACKUP\RB_SBIWILL1_688997351_76_688997351
channel ORA_DISK_3: starting datafile backupset restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
restoring datafile 00005 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\EXAMPLE01.DBF
restoring datafile 00006 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBS01.DBF
restoring datafile 00009 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\UNDOTBS02.DBF
restoring datafile 00010 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\UNDOTBS03.DBF
channel ORA_DISK_3: reading from backup piece C:\RMAN_BACKUP\RB_SBIWILL1_688997352_77_688997352
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\SYSTEM01.DBF
restoring datafile 00004 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\USERS01.DBF
restoring datafile 00007 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBS2.DBF
channel ORA_DISK_2: reading from backup piece C:\RMAN_BACKUP\RB_SBIWILL1_688997351_75_688997351
channel ORA_DISK_3: restored backup piece 1
piece handle=C:\RMAN_BACKUP\RB_SBIWILL1_688997352_77_688997352 tag=FULL_BKUP_08062009
channel ORA_DISK_3: restore complete, elapsed time: 00:01:07
channel ORA_DISK_1: restored backup piece 1
piece handle=C:\RMAN_BACKUP\RB_SBIWILL1_688997351_76_688997351 tag=FULL_BKUP_08062009
channel ORA_DISK_1: restore complete, elapsed time: 00:01:14
channel ORA_DISK_2: restored backup piece 1
piece handle=C:\RMAN_BACKUP\RB_SBIWILL1_688997351_75_688997351 tag=FULL_BKUP_08062009
channel ORA_DISK_2: restore complete, elapsed time: 00:01:21
Finished restore at 09-JUN-09
datafile 1 switched to datafile copy
input datafile copy recid=25 stamp=689074318 filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\SYSTEM01.DBF
datafile 4 switched to datafile copy
input datafile copy recid=26 stamp=689074318 filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\USERS01.DBF
datafile 7 switched to datafile copy
input datafile copy recid=27 stamp=689074319 filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBS2.DBF
datafile 3 switched to datafile copy
input datafile copy recid=28 stamp=689074319 filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\SYSAUX01.DBF
datafile 2 switched to datafile copy
input datafile copy recid=29 stamp=689074319 filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\UNDOTBS01.DBF
datafile 8 switched to datafile copy
input datafile copy recid=30 stamp=689074319 filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBS3.DBF
datafile 11 switched to datafile copy
input datafile copy recid=31 stamp=689074319 filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBD03.DBF
datafile 10 switched to datafile copy
input datafile copy recid=32 stamp=689074319 filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\UNDOTBS03.DBF
datafile 5 switched to datafile copy
input datafile copy recid=33 stamp=689074320 filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\EXAMPLE01.DBF
datafile 6 switched to datafile copy
input datafile copy recid=34 stamp=689074320 filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBS01.DBF
datafile 9 switched to datafile copy
input datafile copy recid=35 stamp=689074320 filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\UNDOTBS02.DBF
RMAN>
now i would like to perform recovery..
RMAN> recover database;
Starting recover at 09-JUN-09
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
starting media recovery
unable to find archive log
archive log thread=1 sequence=244
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/09/2009 09:34:22
RMAN-06054: media recovery requesting unknown log: thread 1 seq 244 lowscn 15150015
RMAN>
i feel the problem is with redo log file.... we don't have any physical redo log file..this seq 244 comes from control file which was restored..
we just need to drop these below all redo and create new redo....but the group 2 is currently active...so we can't delete them..
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 243 52428800 1 YES INACTIVE 15080744 07-JUN-09
5 1 242 62914560 1 YES INACTIVE 15027262 07-JUN-09
3 1 241 52428800 1 YES INACTIVE 14991069 06-JUN-09
2 1 244 52428800 1 NO CURRENT 15120232 08-JUN-09[/CODE]
guide me to perform the recovery with resetlog option..
thank you
kesavan.
|
|
|
|
|
|
Re: Unable to perform recovery from RMAN backup [message #407379 is a reply to message #407352] |
Wed, 10 June 2009 00:45 |
kesavansundaram
Messages: 183 Registered: October 2007 Location: MUMBAI
|
Senior Member |
|
|
dear sirs,
as you told,
(i)
i have generated backup along with archivlogs..
RMAN> run
2> {
3> backup database plus archivelog tag='BKP_10JUN09';
4> }
now, in target machine,
1- iam restroing the controlfile from rman backup
( restore controlfile from 'C:\RMAN_BACKUP\O1_MF_S_689161029_52YDCGPY_.BKP'; _
2 - iam mounting,
RMAN> alter database mount;
3- iam restoring...
RMAN> run
2> {
3> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\SYSTEM01.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\SYSTEM01.DBF';
4> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\USERS01.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\USERS01.DBF';
5> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\TBS2.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\TBS2.DBF';
6> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\SYSAUX01.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\SYSAUX01.DBF';
7> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\UNDOTBS01.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\UNDOTBS01.DBF';
8> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\TBS3.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\TBS3.DBF';
9> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\TBD03.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\TBD03.DBF';
10> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\UNDOTBS03.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\UNDOTBS03.DBF';
11> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\EXAMPLE01.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\EXAMPLE01.DBF';
12> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\TBS01.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\TBS01.DBF';
13> set newname for datafile 'D:\ORACLE\PRODUCT\10.2.0\Oradata\SBIWILL1\UNDOTBS02.DBF' to 'C:\oracle\product\10.2.0\Oradata\SBIWILL1\UNDOTBS02.DBF';
14> RESTORE DATABASE;
15> SWITCH DATAFILE ALL;
16> }
4-now recovery part..
my target db is running archivelog mode.
i already have taken backup of all archivelog from source db...( rman backup )
if i want to resotre, i need redo log files...but thro rman, we can't take backup of redo logs.
now my target db is in mount stage ( as i resotred controlfile )
if you generate trace of this controlfile..
CREATE CONTROLFILE REUSE DATABASE "SBIWILL1" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 1752
LOGFILE
GROUP 1 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\REDO01.LOG' SIZE 50M,
GROUP 2 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\REDO02.LOG' SIZE 50M,
GROUP 3 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\REDO03.LOG' SIZE 50M,
GROUP 5 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\REDO04.LOG' SIZE 60M
-- STANDBY LOGFILE
-- GROUP 4 'D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\SBIWILL1\ARCHIVELOG\SBIWILL10_1_677604083_0.ARC' SIZE 4M
DATAFILE
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\SYSTEM01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\UNDOTBS01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\SYSAUX01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\USERS01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\EXAMPLE01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBS01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBS2.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBS3.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\UNDOTBS02.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\UNDOTBS03.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBD03.DBF'
CHARACTER SET WE8MSWIN1252
;
now look at the redologs....it is located in D drive (as per source directory structure )
but i dont' have these redo physically in target machine. and group 2 shows status: CURRENT...so we can't delete that redo.
i need to create new redo log files....
for e.g i have created 4 new redo groups..as follows:
lter database add logfile
GROUP 6 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\REDO06.LOG' size 50M,
GROUP 7 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\REDO07.LOG' size 50M,
GROUP 8 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\REDO08.LOG' size 50M,
GROUP 9 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\REDO09.LOG' size 50M;
now i generate trace of controlfile and remove those old redo ( group 1,2,3,5 )
CREATE CONTROLFILE REUSE DATABASE "SBIWILL1" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 1752
LOGFILE
GROUP 6 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\REDO06.LOG' SIZE 50M,
GROUP 7 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\REDO07.LOG' SIZE 50M,
GROUP 8 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\REDO08.LOG' SIZE 50M,
GROUP 9 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\REDO09.LOG' SIZE 50M
-- STANDBY LOGFILE
-- GROUP 4 'D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\SBIWILL1\ARCHIVELOG\SBIWILL10_1_677604083_0.ARC' SIZE 4M
DATAFILE
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\SYSTEM01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\UNDOTBS01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\SYSAUX01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\USERS01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\EXAMPLE01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBS01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBS2.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBS3.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\UNDOTBS02.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\UNDOTBS03.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\SBIWILL1\TBD03.DBF'
CHARACTER SET WE8MSWIN1252
;
now, if i recreate this controlfile..
then at mount stage, if i perform recovery.... it is giveing below errror:
RMAN-06054: media recovery requesting unknown log: thread 1 seq 253 lowscn 15150015
where 253 is sequence for redo log file which is in CURRENT state ( old redo log file ) belong to group 2
pls note, in my new recreated controlfile, i have all newly created redos.... then how the sequence 253 is displayed in error msg ?
from where it comes ?
pls help me to recover and open the db with resetlogs...
thank you.
kesavan.
|
|
|
|
Re: Unable to perform recovery from RMAN backup [message #409220 is a reply to message #407173] |
Sat, 20 June 2009 11:30 |
rsnsandeep
Messages: 1 Registered: June 2009
|
Junior Member |
|
|
Your script is perfect and you are doing right; after the restoration of datafiles open a new sqlplus session and then issue command
recover database using backup controlfile until cancel;
or
recover database using backup controlfile until change #(put sequence# here)
then apply the required archive logs, once applied you should get media recovery cancel'led. Then issue
Alter database open restlogs;
then add temp files if any. it will be up
good luck,
Sandeep
|
|
|
|