单项选择题
A.Take the USERS tablespace offline and re-create the lost data file.
B.Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.
C.Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.
D.Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online.
单项选择题 The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server: LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ DB_RECOVERY_FILE_DEST_SIZE = 20G Which statement is true regarding the archived redo log files()
多项选择题 You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario()
单项选择题 You want to enable archiving on your database. Presently, the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order: 1:Shut down the instance. 2:Execute the ALTER DATABASE ARCHIVELOG command. 3:Start up the instance and mount the database. 4:Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5: Open the database. Which is the correct sequence of steps for accomplishing the task()