Re: RMAN question
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: "LS Cheng" <exriscer@xxxxxxxxx>
- Date: Tue, 18 Sep 2007 08:02:57 -0700
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: