log archive dest and format
868298Oct 24 2011 — edited Oct 24 2011Dear DBA's
I'm on oracle 10.2.0.3 (10g), and the OS is solaris. I have recently join this new job. I have come across the log_archive_dest_1 and formating issues.
THE FOLLOWING ARE THE LOG ARCHIVE DEST PARAMETERS
SQL> show parameter log_archive_dest_1;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string LOCATION=/u02/archivelogs OPTI
ONAL REOPEN=300 QUOTA_SIZE=1g
SQL> show parameter log_archive_dest_2;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string LOCATION=USE_DB_RECOVERY_FILE_
DEST OPTIONAL REOPEN=300
SQL> show parameter log_archive_format;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string %t_%s_%r.arc
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 13768
Next log sequence to archive 13770
Current log sequence 13770
THE OUTCOME OF ARCHIVED ON DESTINATION.
*(DEST 1)*
bash-3.00$ pwd
/u02/archivelogs
bash-3.00$ ls
1_13765_689159568.arc 1_13767_689159568.arc 1_13769_689159568.arc
1_13766_689159568.arc 1_13768_689159568.arc
*(DEST 2)*
bash-3.00$ pwd
/u03/app/oracle/flash_recovery_area/FCDB/archivelog
bash-3.00$ ls
2011_10_17 2011_10_19 2011_10_21 2011_10_23
2011_10_18 2011_10_20 2011_10_22 2011_10_24
bash-3.00$ cd 2011_10_24
bash-3.00$ ls
o1_mf_1_13766_7bb5ggtb_.arc o1_mf_1_13768_7bbo4ldh_.arc
o1_mf_1_13767_7bbdzgl8_.arc o1_mf_1_13769_7bby1tmm_.arc
The archiving should be in same format on both location but it is different on both location. Kindly help me out that what is the reason for this.