Home » RDBMS Server » Backup & Recovery » Unable to perform recovery from RMAN backup (oracle 10.2.0.1.0 o/s: windows xp)
Unable to perform recovery from RMAN backup [message #407173] Mon, 08 June 2009 23:08 Go to next message
kesavansundaram
Messages: 181
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 #407263 is a reply to message #407173] Tue, 09 June 2009 06:26 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Is your database in archivelog mode ?

If so, did you backup/restore the archivelogs ?
Re: Unable to perform recovery from RMAN backup [message #407345 is a reply to message #407263] Tue, 09 June 2009 16:43 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
unable to find archive log
archive log thread=1 sequence=244



Looks like database archive log mode.

Thanks
Re: Unable to perform recovery from RMAN backup [message #407352 is a reply to message #407345] Tue, 09 June 2009 19:14 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
gentlebabu wrote on Tue, 09 June 2009 17:43
Quote:
unable to find archive log
archive log thread=1 sequence=244



Looks like database archive log mode.

Thanks

That message is irrelevant in regards to whether the database is in archivelog mode or not.
Re: Unable to perform recovery from RMAN backup [message #407379 is a reply to message #407352] Wed, 10 June 2009 00:45 Go to previous messageGo to next message
kesavansundaram
Messages: 181
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 #407476 is a reply to message #407379] Wed, 10 June 2009 05:29 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You should execute your RENAME command for the redo logs after the SET NEWNAME that you execute for the datafiles prior to the restore. The fact that you see a redo log as ACTIVE is irrelevant in this scenario.

You should be able to follow the process indicated in Restore and Recovery of the Database on a New Host.
Re: Unable to perform recovery from RMAN backup [message #409220 is a reply to message #407173] Sat, 20 June 2009 11:30 Go to previous messageGo to next message
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




Re: Unable to perform recovery from RMAN backup [message #409354 is a reply to message #409220] Mon, 22 June 2009 04:50 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The script isn't perfect. The point is, it is completely unnecessary to have to jump thru all those hoops you describe to perform the restore/recovery if the OP simply issued the RENAME for the redo logs in the RMAN script itself.
Previous Topic: Refresh of database
Next Topic: recover dbf
Goto Forum:
  


Current Time: Fri Dec 02 20:27:30 CST 2016

Total time taken to generate the page: 0.08790 seconds