You configured the Flash Recovery Area for your database. The database instance has
been started in 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 enabled and the location for the archive redo log file will be created in
the default location $ORACLE_HOME/log
B.
Archiving will be enabled and the destination for the archived redo log file will be set to
the Flash Recovery Area implicitly
C.
Archiving will be disabled because the destination for the redo log files is missing
D.
The database instance will shut down and the error details will be logged in the alert log
file
True, its B.
In this case one of the …
LOG_ARCHIVE_DEST_n = ‘LOCATION=USE_DB_RECOVERY_FILE_DEST’
… so it archives to the FRA.
However just in case some of you have the same issue
I use an FRA nad I use archiving but
LOG_ARCHIVE_DEST_n = ‘LOCATION=USE_DB_RECOVERY_FILE_DEST’
does not appear in any of my
SHOW PARAMETER LOG_ARCHIVE_DEST_
To obtain the current status and other information about each destination for an instance, query the V$ARCHIVE_DEST view. (Here it does appear)
or run in SQL-Plus this command to see it
ARCHIVE LOG LIST (Here it also does appear)
I dont yet know why???
Peace to all