RE: How to remove deleted Archive Logs from recovery catalog

  • From: Muqthar Ahmed <Muqthar.Ahmed@xxxxxxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 4 Jun 2004 09:49:20 -0400

Helmut,

You can try the following command:

BACKUP
  (ARCHIVELOG FROM SEQUENCE xxxx);

Muqthar

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Daiminger, Helmut
Sent: Friday, June 04, 2004 3:18 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: