RE: RMAN archivelog all behavior

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Mon, 17 May 2004 09:59:06 -0400
Message-ID: <DE8A21F8F1D0254EA4A9214D52AB2FED1023326A@exchsen0a1ma>

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
-----------------------------------------------------------------

Received on Mon May 17 2004 - 08:56:28 CDT