Hi
I'm using 9i. When I have the problem of manually deleted archivelogs
but which are backed up to tape, this is how I get round it:
list archivelog all;
crosscheck archivelog all;
list archivelog all;
Obviously best to avoid being in the situation, but it happens :)
Regards
Howard
-----Original Message-----
From: benbart
[mailto:oracledba-ezmlmshield-x79228942.[Email address protected]
Sent: 29 Jun 2006 22:10
To: LazyDBA Discussion
Subject: RMAN out-of-sync problem ...
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.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
CARILLION VALUES
Openness - Collaboration - Mutual Dependency - Professional Delivery -Sustainable Profitable Growth - Innovation
**********************************************************************
This e-mail transmission, including any attachments, is confidential to the intended recipient. It may contain privileged and confidential information. If you have received this e-mail in error, please delete it and notify the [Email address protected] You must not disclose its contents to anyone, retain, copy, distribute or take action in reliance upon it.
Carillion may monitor outgoing and incoming e-mails. By replying to this e-mail you give your consent to such monitoring.
Carillion plc: Registered in England No. 3782379 Registered Office: Birch Street Wolverhampton WV1 4HY.
This message has been scanned for viruses by BlackSpider MailControl http://www.blackspider.com/, however, Carillion does not accept any responsibility for viruses and it is your responsibility to scan or otherwise check this e-mail and any attachments.
Oracle LazyDBA home page