單項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true 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

單項(xiàng)選擇題

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

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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？（）

你可能感興趣的試題

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session？（）

Examine the following ALTER command： SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS； What is the purpose of the command？（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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？（）

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session？（）

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