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
-----------------------------------------------------------------
Received on Mon May 17 2004 - 08:49:25 CDT