Hi all,

I have 2 machines, one is PRD and one is DR, obviously PRD is the production
database and DR is the standby database. Network connection has been down for
4-weeks so the list of archived logs that need to be applied to the standby
database is about 3000+.

I managed to restore, via RMAN, all the archivelogs that I require and had
applied them to DR. However, during the course of the restore, am running out
of space on PRD - 100% full, so I have to remove those that I requested RMAN to
restore as they got applied on DR.

Now, my RMAN backup of the archivelog is failing because of the manual deletions
that I carried out for those archived logs that I requested to be restored. That
is, when this RMAN backup command in my script runs ...

backup
filesperset 20
format '${ORACLE_SID}_a${TSM_LEVEL}s%sp%p'
archivelog all
delete input;

I get the error ...

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-06089: archived log /nzp/dg/cidpr/log/DBCIDP01/archive/arch_1_66935.arc not
found or out of sync with catalog


RMAN is looking for those 3000+ archived logs that I requested to be restored. I
never realized that RMAN can be so not smart, is this the right term, to try to
look for those files that I've requested to be restored since they've already
been RMAN backed-up, weeks ago. Yes, I know, I restored them for the purpose of
using them for the standby database, but I don't want them to be re-RMAN
backed-up since they've already been backed-up on previous occassions.

To get around this problem, am currently doing ...

crosscheck backup;
delete expired backup;
change archivelog all validate;
resync catalog;

Can someone confirm that am on the right track here? BTW, am still on 8.1.7.4
unfortunately .... hu hu hu ...

Thanks in advance.




Oracle LazyDBA home page