RE: RMAN archivelog all behavior

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 11 May 2004 09:02:23 -0400
Message-ID: <002201c43758$33719cf0$8459699f@vttaxnet.tax.state.vt.us>

Since you don't have the archivelogs any longer, you wouldn't be able to do a point in time recovery using them. You could simulate an incomplete recovery and do an open resetlogs then start fresh with your archivelog all.

Just a thot!
Ruth

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
  [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Peter Barnett   Sent: Monday, May 10, 2004 10:12 PM
  To: Oracle-l
  Subject: RMAN archivelog all behavior

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.

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.

Before going down this road, I would like to hear from anyone with experience using this RMAN command. Have we missed something? Is it possible to use it with older or upgraded databases? If so, can you point me to the documentation? I am a real fan of RTFM, but I think I have not found the right manual.

  Pete Barnett
  Lead Database Administrator
  The Regence Group
  pnbarne_at_regence.com

Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover

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 Tue May 11 2004 - 08:08:28 CDT