advertisements
_____________________________________________________________________________________________________________________
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
RMAN> LIST INCARNATION OF DATABASE DEVDB01;
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
where tag in (SELECT TAG FROM RC_BACKUP_PIECE
WHERE COMPLETION_TIME BETWEEN '16-JUN-2012' AND '18-JUN-2012'
AND DB_ID IN ( 3262395812))
and COMPLETION_TIME BETWEEN '16-JUN-2012' AND '18-JUN-2012'
+RECO/DEVDB01/backups/jrndl1dt_1_1
LEVEL1_WEEKLY_DB_BACKUP 16-06-2012 01:37
+RECO/DEVDB01/backups/DEVDB01_cf_c-3262395812-20120616-00
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
RMAN> RUN
{
RESTORE DATABASE;
RECOVER DATABASE;
}
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
. . . .
. . . .
. . . .
tag=DEVDB01_LEV0_18JUN
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
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment