Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN archivelog all behavior
Hi Pete,
Yes it is possible.
If I understand you, you can simulate this behaviour with a new database =
by deleting one of the archive logs from the OS and you'll get a similar =
error.
A few options are available:
eg tell RMAN the archive log isn't available
RMAN>change archivelog '/u01/oradata/V816//arch/_410.arc' unavailable=20
To notify the recovery catalog about missing archived redo logs, a = change archivelog all validate command will be more suitable.=20 RMAN> change archivelog all validate; ! format varies depending on DB = version - see manual / note 1035665.6
There was (is?) a Metalink note about RMAN catalog maintenance that = described these options.
See for example:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_da=
tabase_id=3DNOT&p_id=3D1035665.6
I think there is another option as well, but can't find it quickly at = the moment.
HTH,
Bruce Reardon
NOTICE: This e-mail and any attachments are private and confidential and = may contain legally privileged information. If you are not an = authorised recipient, the copying or distribution of this e-mail and any = attachments is prohibited and you must not read, print or act in = reliance on this e-mail or attachments. This notice should not be = removed.
-----Original Message-----
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Peter Barnett
Sent: Tuesday, 11 May 2004 12:12 PM
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.=20
We have many databases that have been upgraded several
times and are very old. The original archive log
files have long since gone to the great bit bucket in
the sky. If we have correctly tested, this mean that
archivelog all is not available to us as an option in
RMAN. We will probably be using Unix shell scripts
and RMAN to accomplish what we had expected to
accomplish using archivelog all. =20
=3D=3D=3D=3D=3D
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Mon May 10 2004 - 21:51:12 CDT
-----------------------------------------------------------------