Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

log archive dest and format

868298Oct 24 2011 — edited Oct 24 2011
Dear 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.
This post has been answered by CKPT on Oct 24 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2011
Added on Oct 24 2011
4 comments
1,247 views