Steps for RMAN Recovery from Old Incarnation without Catalog

Here is one example for RMAN recovery from old previous incarnation without catalog.

Step 1
Find out your control file backup file name from RC_BACKUP_FILES table with respect your DBID / Old incarnation.

Connect to RMAN catalog and run

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
341     356     DEVDB01  3252474133       PARENT  1          05-SEP-10
341     342     DEVDB01  3252474133       CURRENT 972274     27-SEP-11
396087  396226  DEVDB01  3262395812       PARENT  256993740  18-JAN-12
396087  396088  DEVDB01  3262395812       CURRENT 257131859  18-JAN-12
13041888 13042126 DEVDB01  3275757920       PARENT  204390627  09-DEC-11
13041888 13041889 DEVDB01  3275757920       CURRENT 11161007302822 18-JUN-12

Connect to catalog database using RMAN user and run the following query. You can restore the control file from AUTOBACKUP also. But, I would suggest to find out the exact controlfile name using following query.

select fname, tag, to_char(COMPLETION_TIME,'dd-mm-yyyy hh:mi') from RC_BACKUP_FILES
   AND   DB_ID IN ( 3262395812))

LEVEL1_WEEKLY_DB_BACKUP          16-06-2012 01:37

TAG20120616T013710               16-06-2012 01:37

Step 2
Shutdown the database and connect rman with target /. Then set your DBID in the RMAN prompt.

$ rman target /

RMAN> set dbid 3262395812

executing command: SET DBID

Step 3
Startup the database in nomount state and restore the controlfile from the backup

RMAN> startup nomount;

Oracle instance started

Total System Global Area    3206836224 bytes

Fixed Size                     2230768 bytes
Variable Size               2147485200 bytes
Database Buffers             905969664 bytes
Redo Buffers                 151150592 bytes

RMAN> restore controlfile from '+RECO/DEVDB01/backups/DEVDB01_cf_c-3262395812-20120616-00';

Starting restore at 19-JUN-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=913 instance=DEVDB011 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output file name=+RECO/DEVDB01/controlfile/current.339.772894455
output file name=+DATA/DEVDB01/controlfile/current.344.772894455
Finished restore at 19-JUN-12

Step 4
Mount the database and restore the database.
RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1


Starting restore at 19-JUN-12
Starting implicit crosscheck backup at 19-JUN-12
allocated channel: ORA_DISK_1
allocated channel: ORA_DISK_2
allocated channel: ORA_DISK_3
allocated channel: ORA_DISK_4
Crosschecked 1819 objects
Crosschecked 3 objects
Finished implicit crosscheck backup at 19-JUN-12

Starting implicit crosscheck copy at 19-JUN-12
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
Finished implicit crosscheck copy at 19-JUN-12

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
File Name: +reco/DEVDB01/AUTOBACKUP/2012_06_16/s_786073030.22646.786073031
File Name: +reco/DEVDB01/AUTOBACKUP/2012_06_18/s_786245437.20475.786245437
File Name: +reco/DEVDB01/AUTOBACKUP/2012_06_18/s_786252689.21003.786252689

. . . .
. . . .
. . . .

File Name: +reco/DEVDB01/ARCHIVELOG/2011_09_27/thread_2_seq_1.342.762963033
File Name: +reco/DEVDB01/ARCHIVELOG/2011_09_27/thread_1_seq_1.377.762973521
File Name: +reco/DEVDB01/ARCHIVELOG/2011_09_27/thread_3_seq_2.378.762973541

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 datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA/DEVDB01/datafile/system.463.772894501
channel ORA_DISK_1: restoring datafile 00005 to +DATA/DEVDB01/datafile/undotbs2.467.772894497

. . . .
. . . .
. . . .

channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:01:55
Finished restore at 19-JUN-12

Starting recover at 19-JUN-12
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4

starting media recovery

archived log for thread 1 with sequence 835 is already on disk as file +DATA/DEVDB01/onlinelog/group_3.346.772896393
. . .
. . .
. . .
. . .
archived log file name=+DATA/DEVDB01/onlinelog/group_8.300.772896469 thread=3 sequence=797
archived log file name=+RECO/DEVDB01/archivelog/2012_06_18/thread_2_seq_805.20386.786257011 thread=2 sequence=805
archived log file name=+RECO/DEVDB01/archivelog/2012_06_18/thread_1_seq_837.20265.786257011 thread=1 sequence=837
archived log file name=+DATA/DEVDB01/onlinelog/group_9.298.772896471 thread=3 sequence=798
Finished recover at 19-JUN-12

Step 5
Open the database with resetlogs option.

RMAN>  alter database open resetlogs;

database opened

DBA Tips Data Pump Reference


Post a Comment


dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google