RE: How to remove deleted Archive Logs from recovery catalog

From: Muqthar Ahmed <Muqthar.Ahmed_at_decoratetoday.com>
Date: Fri, 4 Jun 2004 09:49:20 -0400
Message-ID: <6362087FB073D41195B800D0B78284BE0621CAC1@mail01.corp.abwf.com>

Helmut,

You can try the following command:

BACKUP
(ARCHIVELOG FROM SEQUENCE xxxx);

Muqthar

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Daiminger, Helmut Sent: Friday, June 04, 2004 3:18 AM
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

* * * * * * * *

The information contained in this E-mail message is privileged, confidential, and may be protected from disclosure; please be aware that any other use, printing,copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think that you have received this E-mail message in error, please reply to the sender and delete it from your computer. Thank you.

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

Received on Fri Jun 04 2004 - 09:07:24 CDT