Re: RMAN question

On 9/17/07, LS Cheng <exriscer_at_gmail.com> wrote:
>
> Hi Jared
>
> Autobackup filename has dbid so you dont really have to lookup in a
> catalog.
>

And how do you find that autobackup controlfile if you don't know the dbid?

If it is the only database on a server, it is somewhat simple. You can browse the backup media catalog for files from that server that match the format of the autobackup controlfile.

If you do not know the DBID, and there are multiple databases on a server, it becomes a process of elimination.

Without a recovery catalog you must use the RMAN command "set dbid=<DBID>" to recover the autobackup controlfile when there is no recovery catalog.

With a catalog, you simply restore the autobackup controlfile with RESTORE CONTROLFILE FROM AUTOBACKUP, along with a few parameters to limit the range of the search.

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

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