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