Me again with weird problems :( I am on Oracle 10.2.0.4, RMAN with catalog, Data Guard with broker. On my primary database I am connecting to target and
control file (NO catalog) and listing all archivelogs via
list archivelg all - SHOWS logs from 106-1128:
RMAN>
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
6 1 106 A 28-SEP-09 /data/archive/PRD1/archivelog/2009_09_28/o1_mf_1_106_5d23tnj3_.arc
4 1 107 A 28-SEP-09 /data/archive/PRD1/archivelog/2009_09_28/o1_mf_1_107_5d23tnlp_.arc
3 1 108 A 28-SEP-09 /data/archive/PRD1/archivelog/2009_09_28/o1_mf_1_108_5d23tn9f_.arc
....
2023 1 1125 A 07-OCT-09 /data/archive/DPAPRD1/archivelog/2009_10_07/o1_mf_1_1125_5dtmphxq_.arc
2025 1 1126 A 07-OCT-09 /data/archive/DPAPRD1/archivelog/2009_10_07/o1_mf_1_1126_5dtmtwxq_.arc
2027 1 1127 A 07-OCT-09 /data/archive/DPAPRD1/archivelog/2009_10_07/o1_mf_1_1127_5dtnsfnb_.arc
2029 1 1128 A 07-OCT-09 /data/archive/DPAPRD1/archivelog/2009_10_07/o1_mf_1_1128_5dtomzdh_.arc
I then connect to my primary target WITH catalog and
list archivelog all and see them listed for TODAY only:
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
666421 1 1099 A 07-OCT-09 /data/archive/PRD2/archivelog/2009_10_07/o1_mf_1_1099_5dsyho8z_.arc
673868 1 1099 X 07-OCT-09 /data/archive/PRD1/archivelog/2009_10_07/o1_mf_1_1099_5dsyhof3_.arc
673869 1 1100 X 07-OCT-09 /data/archive/PRD1/archivelog/2009_10_07/o1_mf_1_1100_5dsz8n0n_.arc
666422 1 1100 A 07-OCT-09 /data/archive/PRD2/archivelog/2009_10_07/o1_mf_1_1100_5dsz8mst_.arc
666858 1 1101 A 07-OCT-09 /data/archive/PRD2/archivelog/2009_10_07/o1_mf_1_1101_5dt02cbq_.arc
Shouldn't catalog and control file by in synch? Why do all of the primary archvielogs have X for status (its expired?). My CONFIGURE ARCHIVELOG settings are set to NONE on both primary and standy (because I take backups on both) :
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
Is this a bug?
My RMAN hot backup script crosschecks archivelogs and then deletes logs that have been backed up twice, but keeps 7 days worth of logs on disk..
run
{
allocate channel c1 type disk;
crosscheck archivelog like '${FRA_DIR}%';
backup database format '${BACKUP_DIR}/datafiles__${BACKUP_TYPE}_${TIMESTAMP}%p_%s.rman';
backup archivelog all format '${BACKUP_DIR}/archivelogs_%d_%u_%s_%T' not backed up 2 times;
backup current controlfile format '${BACKUP_DIR}/${ORACLE_SID}_${TIMESTAMP}_CTL';
delete noprompt archivelog all backed up 2 times to DEVICE TYPE disk completed before 'sysdate-7';
delete noprompt expired archivelog like '${FRA_DIR}%';
release channel c1;
}
I expected to have 7 days of archivelogs in my catalog, not only control file. Please help!