hmm well it's relative, I backup to tape rman backup logs and it always
shows the autobackup filename....
On 9/18/07, Jared Still <jkstill_at_gmail.com> wrote:
>
> 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
Received on Tue Sep 18 2007 - 11:16:44 CDT
