单项选择题
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 -
单项选择题
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order: 1)Shut down the instance. 2)Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3)Execute the ALTER DATABASE FLASHBACK OFF command. 4)Start up the instance and mount the database. 5)Execute the ALTER DATABASE FLASHBACKON command. 6)Open the database. Select the correct order in which these tasks need to be performed. ()
A.2,1,4,3,5,6
B.1,4,3,2,6,5
C.1,4,2,6,3,5
D.3,2,1,4,5,6
