单项选择题
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）
A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles
B. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS
C. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile
D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
相关考题
-
多项选择题
Whichstatementsaretrueregardingthesystem-definedmovingwindowbaselineinOracleDatabase11g？（）
A. It does not allow you to change the moving window size.
B. Adaptive threshold functionalities use it by default to compute statistics.
C. It is created by default with the window size being equal to the AWR retention time.
D. It is created when the first snapshot is collected by the Automatic Workload Repository （AWR）. -
单项选择题
You issue the following RMAN command to set a retention policy on a database： RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2； What will be the outcome of issuing this command？（）
A. After two days，a backup will be marked obsolete
B. After two days，a backup will be deleted from the media
C. If the RMAN repository has records of two or more recent backups of a file，then older backups will be deleted from the media.
D. If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete. -
单项选择题
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement istrue while performing a tape backup in an RMAN session?（）
A. The tape I/O performed is asynchronous
B. The tape buffer is allocated from the System Global Area (SGA)
C. The tape buffer is allocated from the Program Global Area (PGA)
D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes
