单项选择题
Examine the following scenario:
- Database is running in ARCHIVELOG mode.
- Complete consistent backup is taken every Sunday.
- On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted
- The disk having active online redo log files is also corrupted.
- The hardware is repaired and the paths for online redo log files and control files are still valid.
Which option would you use to perform the recovery of database till the point of failure?（）
A. Restore the latest whole backup, perform complete recovery, and open the database normally
B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.
C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.
D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.
相关考题
-
单项选择题
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）
A. The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.
B. The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.
C. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
D. The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1
-
单项选择题
YouplantosetuptheAutomaticWorkloadRepository（AWR）baselinemetricthresholdsforamovingwindowbaseline.Whichactionwouldyoutakebeforeperformingthistask？（）
A. Compute the baseline statistics.
B. Take an immediate AWR snapshot.
C. Decrease the window size for the baseline.
D. Decrease the expiration time for the baseline. -
单项选择题
You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group ，you issued the following ASMCMD command： ASMCMD> lsdsk -I -d DATA Which statement is true regarding the outcome of this command？（）
A. The command succeeds but it retrieves only the disk names.
B. The command produces an error because the ASM instance is down.
C. The command succeeds but it shows only the status of the ASM instance.
D. The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
