Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN archivelog all behavior

RE: RMAN archivelog all behavior

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Thu, 13 May 2004 12:24:59 -0400
Message-ID: <D9530056A14A6244BCC838513C9F6FA104FFEB9F@EXCHSERV1.Limited.brands.com>

If you mannually delete them...RMAN does know where they went so it saying ERROR... Do a resync and RMAN will stop failing.

$ORACLE_HOME/bin/rman catalog rman9204/${CUSER_PASS}@rmancat target rman/${DUSER_PASS}@hr83prd <<EOF
change archivelog all validate;
EOF IE. The RMAN command being ==> change archivelog all validate.

Cheers.
Brian Spears  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale
Sent: Thursday, May 13, 2004 10:55 AM
To: oracle-l_at_freelists.org
Subject: Re: RMAN archivelog all behavior

I wouldn't think it has to do with "new" or "old" databases. It has to do with the number of archive log entries in the Controlfile [ie if you are using the Controlfile].

I've manually deleted archivelogs and then found the RMAN backup failing because all the file names were still present in v$LOG_HISTORY, the phsyical files no longer existed.

Hemant

At 10:11 AM Tuesday, you wrote:
>It appears from our testing that archivelog all is
>only useful when a database has been created new and
>all of the archive log files are available.
>
>

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional http://web.singnet.com.sg/~hkchital



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
----------------------------------------------------------------
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
-----------------------------------------------------------------
Received on Thu May 13 2004 - 12:02:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US