Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN archivelog all behavior
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
-- 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
![]() |
![]() |