DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=HkDJ+VR8AyOJJVFVWi8CDszK4qnxkkikQ2qkOxji4OGF8eXG5zmlnMaVbwxk99hnnAzz1YcPJVLSLMe0gZAPA4WZzq8PFPl9PPUdFmFWz/I6pqlBK0jKvf5cZcoZYG4hSVHRKvx+J3U3EzK5SnDAJ9Vf+sDdWGw5HZBA5LIiYzI=
Message-ID: <bf46380709180802r2f1cb7adp6f44dec8475d8f12@mail.gmail.com>
Date: Tue, 18 Sep 2007 08:02:57 -0700
From: "Jared Still" <jkstill@gmail.com>
To: "LS Cheng" <exriscer@gmail.com>
Subject: Re: RMAN question
Cc: joseph.armstrong-champ@tufts.edu, ORACLE-L <oracle-l@freelists.org>
In-Reply-To: <6e9345580709172238u7e060152qcd6190aeff3c54d7@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_16170_8106396.1190127777495"
References: <46EAD21D.6010704@tufts.edu>
	 <bf46380709171904y529da7b9y4e905aee27a44b64@mail.gmail.com>
	 <6e9345580709172238u7e060152qcd6190aeff3c54d7@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: jkstill@gmail.com
------=_Part_16170_8106396.1190127777495
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 9/17/07, LS Cheng <exriscer@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

------=_Part_16170_8106396.1190127777495
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 9/17/07, <b class="gmail_sendername">LS Cheng</b> &lt;<a href="mailto:exriscer@gmail.com">exriscer@gmail.com</a>&gt; wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>Hi Jared</div>
<div>&nbsp;</div>
<div>Autobackup filename has dbid so you dont really have to lookup in a catalog.<br></div></blockquote></div><br>And how do you find that autobackup controlfile if you don&#39;t know the dbid?<br><br>If it is the only database on a server, it is somewhat simple. You can
<br>browse the backup media catalog for files from that server that match<br>the format of the autobackup controlfile.<br><br>If you do not know the DBID, and there are multiple databases on a server,<br>it becomes a process of elimination.
<br><br>Without a recovery catalog you must use the RMAN command &quot;set dbid=&lt;DBID&gt;&quot;<br>to recover the autobackup controlfile when there is no recovery catalog.<br><br>With a catalog, you simply restore the autobackup controlfile with 
<br>RESTORE CONTROLFILE FROM AUTOBACKUP, along with a few parameters<br>to limit the range of the search.<br><br><br>-- <br>Jared Still<br>Certifiable Oracle DBA and Part Time Perl Evangelist<br>

------=_Part_16170_8106396.1190127777495--
--
http://www.freelists.org/webpage/oracle-l