Sunday, 10 February 2013

Archive log destination without setting any of Log Archive or recovery parameters

Database  - 11.2.0.1.0

I was wondering how 'archive log list' is showing an archive log destination  without setting any of relevant archive log destination or db recovery parameters.

LOG_ARCHIVE_DEST
LOG_ARCHIVE_DEST_n
DB_RECOVERY_FILE_DEST

SQL> archive log list ;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch
Oldest online log sequence 8
Current log sequence 10
SQL> show parameter log_archive_dest;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string

SQL> show parameter db_recovery

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string
db_recovery_file_dest_size big integer 0

SQL> select dest_name,destination from v$archive_dest where destination is not null ;

DEST_NAME DESTINATION
------------- ------------------
LOG_ARCHIVE_DEST_1 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch

After scratching my head for quite some time i ended up reading this text from documentation.

"Note also that if you enable archiving but do not set any value for LOG_ARCHIVE_DEST, LOG_ARCHIVE_DEST_n, or DB_RECOVERY_FILE_DEST, then the redo logs are archived to a default location that is platform-specific. For example, on Solaris the default is ?/dbs."

http://docs.oracle.com/cd/E25178_01/backup.1111/e10642/rcmconfb.htm#CHDBJJAA
under Configuring Archived Redo Log Locations