RE: RMAN archivelog all behavior

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Tue, 11 May 2004 12:53:16 +1000
Message-ID: <DF33C5D0C428FE4DBC8410FC2793EE7F0141BA4D@calbbsv025.cal.riotinto.org>

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

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 Mon May 10 2004 - 21:51:12 CDT