21.
What is another name for RMAN-based database recovery?
- A.User-managed recovery
- B.Server-managed recovery
- C.Traditional recovery
- D.Database recovery
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Server-managed recovery is another name for RMAN recovery because the server session performs the recovery process as it interacts with the target database. |
22.
What command is responsible for automating the backup of control files?
- A.ALTER DATABASE CONTROLFILE AUTOBACKUP ON
- B.ALTER SYSTEM CONTROLFILE AUTOBACKUP ON
- C.CONFIGURE CONTROLFILE AUTOBACKUP ON
- D.ENABLE CONTROLFILE AUTOBACKUP
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The control file autobackup is enabled by setting parameters within RMAN by using CONFIGURE CONTROLFILE AUTOBACKUP ON. |
23.
What is the process to recover a control file?
- A.Start up database, restore control file, start up mount the database, recover the database, and open the database.
- B.Start up mount, restore control file, start up the database, recover the database, and open the database.
- C.Start up nomount, restore control file, start up mount the database, recover the database, and open the database.
- D.Start up force, restore control file, start up the database, recover the database, and open the database.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The database needs to be started in NOMOUNT mode because there is not a control file available to MOUNT the database. Next, the control file can be restored. Once a restored control file is available, the database can be started in MOUNT mode so that standard database recovery can continue. When recovery is complete, the database can OPEN for normal use. |
24.
When recovering a control file without the recovery catalog, what special step must be performed
to identify the target database? (Choose all that apply.)
- A.You must CONNECT TARGET / to the target database within RMAN.
- B.You must STARTUP MOUNT the database because the control file is missing.
- C.You must SET DBID to the target database so that the target database can be identified without the control file available.
- D.You must CONNECT TARGET database name to the target database within RMAN.
- Answer & Explanation
- Report
Answer : [A,C]
Explanation :
Explanation :
| The target database is not identifiable by database name without the control file. So you must first use the CONNECT TARGET / command to connect. The target database needs to be identified by the database identifier (DBID) number with the command SET DBID database identifier. This database identifier number denotes the target database. When you are recovering the control file, the target database identification is not available because it is stored in the control file. |
25.
After you restore the control file, what must you do before you execute the RECOVER command
to apply archive logs?
- A.The database must be restored with the RESTORE command.
- B.The database must be reconnected with the CONNECT TARGET database name command.
- C.The database must be started in MOUNT mode.
- D.The database must open for use with ALTER DATABASE OPEN command.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The database must be mounted before the RECOVER command can be executed. You first must restore control so you can MOUNT the database. |
|
|
||||||||||||||||||||||||||||
