RE: How to remove deleted Archive Logs from recovery catalog

From: David Sharples <dsharples_at_cerebrussolutions.com>
Date: Fri, 4 Jun 2004 09:38:54 +0100
Message-ID: <EA29A3FCC723674293FD6286D3F0513E77BE68@louis.cerebrus.com>

Crosscheck archivelog all

Rman will check if the logs are there, any it doesn't find will be assumed lost in action and not backed up

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Daiminger, Helmut Sent: 04 June 2004 08:18
To: 'oracle-l_at_freelists.org'
Subject: How to remove deleted Archive Logs from recovery catalog

Hi!

We were having a problem this morning that the archiver process on one of
the production databases was stuck.
Our DBA just did a "rm *.arc" on the archive destinations directories. Not
really elegant, but it solved the immediate problem... ;)

Now if we invoke RMAN, it "complains" that it would like to write the (now
non-existent) archive logs to tape.

Is there any way to tell RMAN to skip the archive logs that are missing and
continue with the new ones?

I know that this is kinda dangerous until the next full database backup (scheduled for tonight) is taken.

This is 9.2 on HP-UX 11i.

Thanks,
Helmut

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Fri Jun 04 2004 - 03:41:14 CDT