Skip to Main Content
Forums

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!

Problem with crosschecking arch logs in RMAN

610916Jul 2 2009 — edited Jul 2 2009
Hi:

I am on 10.2.0.3.

Shown below in the extract from RMAN backup log is a funny problem with crosscheck command, which is part of my daily Rman backup. Each file is listed twice with slightly different name, and validation succeeds for one file (with the right name) and fails for the other (with the wrong name). A few months ago I've included SID into archive log format, and this probably caused it.

Any comments greatly appreciated.

SQL> show parameter log_archive_format

NAME
------------------------------------
TYPE VALUE
-------------------------------------------- ------------------------------
log_archive_format
string HHHPRD_%t_%s_%r.arc


MAN> RUN
2> {
3> crosscheck archivelog all;
4> ALLOCATE CHANNEL d1 TYPE DISK FORMAT '/db18/backup/HHHPRD/%U';
5> ALLOCATE CHANNEL d2 TYPE DISK FORMAT '/db18/backup/HHHPRD/%U';
6> ALLOCATE CHANNEL d3 TYPE DISK FORMAT '/db18/backup/HHHPRD/%U';
7> BACKUP as compressed backupset DATABASE plus archivelog not backed up 1 times;
8> backup current controlfile;
9> RELEASE CHANNEL d1;
10> RELEASE CHANNEL d2;
11> RELEASE CHANNEL d3;
12> }
13> delete noprompt archivelog all completed before 'sysdate-14';
14> EXIT;
starting full resync of recovery catalog
full resync complete
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=500 devtype=DISK
validation succeeded for archived log
archive log filename=/db18/oraarch/HHHPRD/HHHPRD_1_14808_664238894.arc recid=26196 stamp=689728473
validation failed for archived log
archive log filename=/db18/oraarch/HHHPRD/1_14809_664238894.arc recid=11884 stamp=689730563
validation succeeded for archived log
archive log filename=/db18/oraarch/HHHPRD/HHHPRD_1_14809_664238894.arc recid=26198 stamp=689730557
validation failed for archived log
archive log filename=/db18/oraarch/HHHPRD/1_14810_664238894.arc recid=11885 stamp=689730578
validation succeeded for archived log
archive log filename=/db18/oraarch/HHHPRD/HHHPRD_1_14810_664238894.arc recid=26200 stamp=689730563
validation failed for archived log
archive log filename=/db18/oraarch/HHHPRD/1_14811_664238894.arc recid=11886 stamp=689731176
validation succeeded for archived log
archive log filename=/db18/oraarch/HHHPRD/HHHPRD_1_14811_664238894.arc recid=26202 stamp=689731164
validation failed for archived log
archive log filename=/db18/oraarch/HHHPRD/1_14812_664238894.arc recid=11887 stamp=689731198
validation succeeded for archived log
archive log filename=/db18/oraarch/HHHPRD/HHHPRD_1_14812_664238894.arc recid=26203 stamp=689731172
validation failed for archived log
archive log filename=/db18/oraarch/HHHPRD/1_14813_664238894.arc recid=11888 stamp=689731219
validation succeeded for archived log
archive log filename=/db18/oraarch/HHHPRD/HHHPRD_1_14813_664238894.arc recid=26207 stamp=689731217
validation failed for archived log
archive log filename=/db18/oraarch/HHHPRD/1_14814_664238894.arc recid=11889 stamp=689739391
validation succeeded for archived log
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2009
Added on Jul 2 2009
#general-database-discussions
1 comment
549 views