Your database is running in archivelog mode. You are taking a backup of your database by
using RMAN with a recovery catalog. Because of a media failure, one of the data files and all
the control files are lost.
Examine the steps to recover the database:
1.Restore the control files by using the RMAN restore controlfile command.
2.Mount the database.
3.Restore the data files by using the RMAN restore database command.
4.Open the database with the resetlogs option.
5.Recover the data files by using the RMAN recover using backup controlfile command.
6. Start the database instance in nomount state.
7. Connect to the target database by using a recovery catalog.
8.Open the database.
9.Restore the data file.
10.Recover the data file.
Identify the required steps in the correct order.
A.
7, 6, 1, 2, 3, 5, 4
B.
7, 2, 1, 3, 5, 8
C.
7, 6, 1, 2, 9, 10, 8
D.
7, 6, 1, 2, 9, 10, 4
D
I think It’s A.
If you restore controlfiles you have to do recovery with USING BACKUP CONTROLFILE
which one is correct?
Its D , because were using rman catalog. Sorry for my mistake.
See here
http://dbaworkshop.blogspot.it/2012/10/how-to-restore-from-a-loss-of-all-current-control-files-to-the-default-location.html
Thanks Vonpire!
D is more acurate. Thanks Vonpire!
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/recov004.htm
6.4.1.4 Restoring a Control File When Using a Recovery Catalog
Restoring a lost control file from autobackup is easier when using a recovery catalog than when using only the control file to store the RMAN repository. The recovery catalog contains a complete record of your backups, including backups of the control file. Therefore, you do not have to specify your DBID or control file autobackup format.
recover database using backup controlfile. Because controlfile stored backup infomation so if controlfile is old and not contain new backup infomation then we will cataloging manually for controlfile to understand. If we use catalog. There is noneed to recover using backup controlfile.
Thanks Vonpire
D
D
I confused Difference between C and D is Open Resetlogs,
I’m not sure do i really need to open reset logs, I think I can open database normally as the database is in archive log mode, and the REDO LOG is not lost; as well as no use for “Backup control file”
Please correct me.
Yes, it D.
here is the resean, why you have to open with resetlogs:
https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmadvre.htm#i1006245
“If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file. You must then run the RECOVER command, even if no datafiles have been restored, and open the database with the RESETLOGS option.”
ywaiti cialis soft tabs online cialis generic cialis
D
But what about points
9.Restore the data file.
10.Recover the data file.
Is this a typo (“file” instead of “files”)?
one of the data files and
all the control files are lost.
One data file is lost so You run
restore datafile
recover datafile
D