单项选择题

A.Take the USERS tablespace offline and re-create the l……

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.
What would you do to recover the data file（）

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

A.It will be created on the local file system.
B.It will be created only in the Flash Recovery Area.
C.It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.
D.It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.

多项选择题You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario（）

A.You must shut down the database instance to perform the backups.
B.You must configure the Flash Recovery Area （FRA） for the database.
C.You can perform complete database backups without closing the database.
D.All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

单项选择题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（）

A.4，1，3，2，5
B.1，3，4，5，2
C.1，3，2，5；4 not required
D.4，1，5，2；3 not required
E.1，3，4，5；2 not required

单项选择题You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files（）

A.Archiving will be disabled because the destination for the redo log files is missing.
B.The database instance will shut down and the error details will be logged in the alert log file.
C.Archiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.
D.Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.

多项选择题You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）

A.flashback log files
B.backups that have become obsolete
C.copies of the data files and control files
D.archived redo log files that have multiple copies in a different archive location and not backed up