单项选择题

A. Allow the database to continue running，drop the TEMP……

The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace 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

<上一题目录下一题>

热门试题

单项选择题TheBACKUP_TAPE_IO_SLAVESparameterissettoFALSEforthedatabaseinstance.WhichstatementistruewhileperformingatapebackupinanRMANsession？（）

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

单项选择题Examine the following ALTER command： SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS； What is the purpose of the command？（）

A. It cancels all pending disk drops within the disk group.
B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C. It mounts disks in the disk group for which the drop-disk operation has already been co pleted
D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E. It adds previously dropped disks back into the disk group

单项选择题You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task： 1） Restore an autobackup of the server parameter file. 2） Restore the control file 3） Start the target database instance 4） Mount the database 5） Restore the data files 6） Open the database with RESETLOGS option 7） Recover the data files 8） Set DBID for the target database Which option illustrates the correct sequence that you must use？（）

A. 8， 1， 3， 2， 4， 5， 7， 6
B. 1， 8， 3， 4， 2， 5， 7， 6
C. 1， 3， 4， 2， 8， 5， 6， 7
D. 1， 3， 2， 4， 6， 5， 7， 8

多项选择题WhichtwooperationsareNOTperformedbytheDUPLICATEcommandinRecoveryManager（RMAN）whileduplicatingarunningdatabase？（）

A. Creating the control file for the duplicate database
B. Restoring the target data files to the duplicate database
C. Performing complete recovery using all available backups
D. Generating a new， unique DBID for the duplicate database
E. Copying the online redo log files from the target database to the duplicate database

单项选择题TapestreamingisnothappeningwhileperformingRMANtapebackup.Oninvestigation，youfindthatitisnotbecauseoftheincrementalbackuportheemptyfilebackupandthatRMANissendingdatablockstothetapedrivefastenough.Whatcouldbeasolutiontomaketapestreaminghappenduringthebackup？（）

A. Configure backup optimization
B. Configure the channel to increase MAXOPENFILES
C. Configure the channel to increase the capacity with the RATE parameter
D. Configure the channel to adjust the tape buffer size with the BLKSIZE option