Your database is running in NOARCHIVING 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?
A.
It executes successfully and sets the Fast Recovery Area as the local archive destination.
B.
It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.
C.
It fails and returns an error about LOG_ARCHIVE_DEST not being set.
D.
It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.
The correct answer should be A.
– If you configure a Fast Recovery Area (by setting the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters) and do not specify any local archive destinations, the database automatically selects the Fast Recovery Area as a local archive destination and sets LOG_ARCHIVE_DEST_1 to USE_DB_RECOVERY_FILE_DEST.
but they didn’t configure DB_RECOVERY_FILE_DEST_SIZE
Sorry, I forgot that both parameters must be set. So if the LOG_ARCHIVE_DEST is not configured and it won’t default to the location of the FRA, I guess…C?
I just found this section. Have a look.
– https://docs.oracle.com/database/121/BRADV/rcmconfb.htm#BRADV89432
(Go to “Configuring Archived Redo Log Locations”)
Specifying this parameter without also specifying the DB_RECOVERY_FILE_DEST_SIZE initialization parameter is not allowed.
if DB_RECOVERY_FILE_DEST is set, DB_RECOVERY_FILE_DEST_SIZE cannot be to ZERO then I assume that DB_RECOVERY_FILE_DEST_SIZE is set.
Answer is A for me
if DB_RECOVERY_FILE_DEST is set, DB_RECOVERY_FILE_DEST_SIZE cannot be to ZERO then I assume that DB_RECOVERY_FILE_DEST_SIZE is set.
Answer is A for me
if DB_RECOVERY_FILE_DEST is set, DB_RECOVERY_FILE_DEST_SIZE cannot be to ZERO then I assume that DB_RECOVERY_FILE_DEST_SIZE is set.
Answer is A for me