QUESTION 66 To recover from the loss of the entire database, including all current control files, al

QUESTION 66
To recover from the loss of the entire database, including all current control files, all online redo log files,
and all parameter files, what backups are required, at a minimum, to restore the database successfully?
(Choose all that apply.)
A. Archived redo logs generated after the last datafile backups
B. One autobackup of the control file
C. One autobackup of the SPFILE
D. A backup of all datafiles i E The password file
Correct Answer: ABD
Section: (none)
Explanation
Explanation/Reference:
/* simulate loss of everything */
SQL> shutdown abort;
ASMCMD [+data/oel5_1] > rm CONTROLFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD [+data/oel5_1] > rm DATAFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD [+data/oel5_1] > rm ONLINELOG/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD [+data/oel5_1] > rm PARAMETERFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD [+data/oel5_1] > rm TEMPFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
RMAN> startup nomount;
startup failed: ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/oel5_1/spfileoel5_1.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/oel5_1/spfileoel5_1.ora ORA-
15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +DATA/oel5_1/spfileoel5_1.ora ORA-
15173: entry 'spfileoel5_1.ora' does not exist in directory 'oel5_1' ORA-06512: at
line 4
starting Oracle instance without parameter file for retrieval of spfile Oracle
instance started
in rman logs dbid saved
[oracle@oel5-1 ~]$ rman target / catalog rcat/passwd@oel5_2
Recovery Manager: Release 11.2.0.3.0 - Production on Mon Mar 25 10:20:30 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to
target database (not started)
connected to recovery catalog database
RMAN> startup nomount;
startup failed: ORA-01078: failure in processing system parameters ORA-
01565: error in identifying file '+DATA/oel5_1/spfileoel5_1.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/oel5_1/spfileoel5_1.ora ORA-15056:
additional error message
ORA-17503: ksfdopn:2 Failed to open file +DATA/oel5_1/spfileoel5_1.ora ORA-15173:
entry 'spfileoel5_1.ora' does not exist in directory 'oel5_1'
ORA-06512: at line 4
starting Oracle instance without parameter file for retrieval of spfile Oracle
instance started
RMAN> set DBID=2197396657
RMAN> list backup of spfile;
List of Backup Sets
===================
................................................................
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1486 Full 9.67M DISK 00:00:00 25-MAR-13
BP Key: 1488 Status: AVAILABLE Compressed: NO Tag: TAG20130325T095514
Piece Name: +FRA/oel5_1/autobackup/2013_03_25/s_810986114.296.810986115
SPFILE Included: Modification time: 24-MAR-13
SPFILE db_unique_name: OEL5_1
RMAN> restore spfile from '+FRA/oel5_1/autobackup/2013_03_25/s_810986114.296.810986115';
.....................
RMAN> set DBID=2197396657
executing command: SET DBID
database name is "OEL5_1" and DBID is 2197396657
RMAN> unregister database;
database name is "OEL5_1" and DBID is 2197396657
Do you really want to unregister the database (enter YES or NO)? yes database
unregistered from the recovery catalog
RMAN> shutdown abort; Oracle
instance shut down
SQL> startup mount; ORACLE
instance started.
Total System Global Area 1369579520 bytes Fixed
Size 2228224 bytes
Variable Size 469762048 bytes
Database Buffers 889192448 bytes Redo
Buffers 8396800 bytes
ORA-00205: error in identifying control file, check alert log for more info
RMAN> restore controlfile from autobackup;
Starting restore at 25-MAR-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
recovery area destination: +FRA
database name (or database unique name) used for search: OEL5_1
channel ORA_DISK_1: AUTOBACKUP +fra/OEL5_1/AUTOBACKUP/2013_03_25/
s_810986114.296.810986115 found in the recovery area
AUTOBACKUP search with format "%F" not attempted because DBID was not set
channel ORA_DISK_1: restoring control file from AUTOBACKUP +fra/OEL5_1/
AUTOBACKUP/2013_03_25/s_810986114.296.810986115
channel ORA_DISK_1: control file restore from AUTOBACKUP
complete output file
name=+DATA/oel5_1/controlfile/current.275.810988179 output file
name=+FRA/oel5_1/controlfile/current.278.810671217 Finished restore
at 25-MAR-13
RMAN> alter database mount;
RMAN> restore database; RMAN>
recover database;
SQL> alter database open resetlogs;