RE: RMAN archivelog all behavior

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 17 May 2004 10:11:09 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00660@EXCHMN3>

Ruth, Tom - This is an important point. People seem to misunderstand RMAN a lot. While RMAN can store the archive logs, that is not necessary for a recovery. As long as the archive logs are available in the expected location, RMAN can use them to perform a recovery. In our situation, since we backup to disk (writing to tape later), I haven't seen any advantage in having RMAN store them. However, if you are using RMAN to back up to tape (using an MML), then you will probably find it necessary to have RMAN store the archive logs to tape as well.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante, Thomas F Sent: Monday, May 17, 2004 8:59 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: RMAN archivelog all behavior

Yeup. Ruth is correct.

-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us] Sent: Monday, May 17, 2004 9:52 AM
To: oracle-l_at_freelists.org
Subject: RE: RMAN archivelog all behavior

Actually, you will only need a level 0 backup, online or cold, to be able to do point in time recover from the time of the level 0 forward.

Ruth

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
  [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Peter Barnett   Sent: Friday, May 14, 2004 2:40 PM
  To: oracle-l_at_freelists.org
  Subject: Re: RMAN archivelog all behavior

We were able to do a -- change archivelog all validate.

This makes the rman catalog aware of nonexistent archive log files. These files still do not exist but RMAN quits complaining. You still need a cold backup from that point forward or a recovery could be toast.

Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:
>
> 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
>

  Pete Barnett
  Lead Database Administrator
  The Regence Group
  pnbarne_at_regence.com

Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price. http://promo.yahoo.com/sbc/

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
-----------------------------------------------------------------
----------------------------------------------------------------
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 Mon May 17 2004 - 10:10:53 CDT