Your database is running in NOARCHIVLOG mode.
Examine the following parameters:
You execute the following command after performing a STARTUP MOUNT:
SQL> ALTER DATABASE ARCHIVELOG;
Which statement is true about the execution of the command?
1z0-062 Exam QuestionsBrowse all questions from this exam
1z0-062 Exam - Question 159
Show AnswerHide Answer
Correct Answer: A
ALTER DATABASE ARCHIVELOG is used to switch the database to ARCHIVELOG mode. Since the database parameters show that db_recovery_file_dest is set, the command will execute successfully and use the Fast Recovery Area as the default destination for archived logs.
Discussion
1 commentRay520
Apr 27, 2022A: DB_RECOVERY_FILE_DEST specifies the default location for the flash recovery area. The flash recovery area contains multiplexed copies of current control files and online redo logs, as well as archived redo logs, flashback logs, and RMAN backups. In order to specify a different location for storing archive logs, we need to specify the same unnder log_archive_dest_1 parameter.