Re: RMAN question
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: "Jared Still" <jkstill@xxxxxxxxx>
- Date: Tue, 18 Sep 2007 18:16:44 +0200
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@xxxxxxxxx> wrote:
>
> On 9/17/07, LS Cheng <exriscer@xxxxxxxxx> 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
>
Other related posts:
