Re: RMAN backup of archived log fails

On 6/6/07, Tony van Lingen <tony.vanlingen_at_epa.qld.gov.au> wrote:
>
>
> I checked the catalog with the command you listed: unless the bplist
> output is limited to a number of lines (I can't get a definitive answer
> to that from our NB guys), we're basically stuffed.

I don't believe so. The bplist output can be quite long.

It seems that the NB
> catalog is spread over a number of servers, so if RMAN queries one it
> will not get the entire list of available files.

That seems... suboptimal.

> Sigh.... where have the days of tar and 'alter tablespace backup'
> gone... things were so easy then....
>
>

Feeling your pain. When doing tests that require restoring the database I have taken to making a cold backup on disk for simplicity and expeditiousness. (is that really a word :)

RMAN is very robust, extremely powerful and highly configurable.

That's another way of saying it can be very complicated and provide many ways to shoot one's self in the foot. ;)

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l