Adam is working as a Database Administrator (DBA) for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup, he discovers that one of the disks crashed, resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details, he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure, what should Adam do to recover the USERS tablespace?()
A、 Restore the USERS01.dbf file from the backup, and open the database using the STARTUP command.
B、 Restore the USERS01.dbf file using the RECOVER TABLESPACE command, and open the database using the ALTER DATABASE OPEN statement.
C、 Restore the USERS01.dbf file from the backup, recover the USERS tablespace using the RECOVER TABLESPACE command, and open the database using the ALTER DATABASE OPEN statement.
D、 Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then, recover the USERS tablespace using the RECOVER TABLESPACE command, and open the database using the ALTER DATABASE OPEN statement.
相关问题推荐
-
You have issued the following command: RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 100 DAYS; What will be the result of using the above command?()
A、 The backup metadata will be maintained in the control file for 100 days.
B、 The backup metadata will be maintained in the recovery catalog for 100 days.
C、 The backup metadata will be maintained in the flash recovery area for 100 days.
D、 After 100 days, the backup sets and image copies will be deleted from the media.
-
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()
ASYSDATE should not be used with TIMESTAMP.
BThe database must have multiplexed redo log files.
CThe database must be in the MOUNT state to execute the command.
DThe database must be opened with the RESETLOGS option after the flashback operation.
EThe entire database needs to be restored from the most recent backup before the flashback operation.
-
In which of the following scenarios is a tablespace recovery required?()
A、 when recovering a lost read-only tablespace from a read-only tablespace backup
B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in ARCHIVELOG mode
C、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
D、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file, the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement, and this statement was issued when the tablespace was read-only
-
In your production database, you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct?()
AThe parallel degree limit for DB_GRP will be the minimum of all the incoming values.
BThe parallel degree limit for DB_GRP will be the maximum of all the incoming values.
CThe maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
DIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would not execute if the active session pool for the new consumer group was full.
EIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would execute even if the active session pool for the new consumer group was full.
-
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()
A、 You must enable the block change tracking feature.
B、 You must have enable the flashback feature.
C、 You must use the OMF in your database.
D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.