Re: recover question

"Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message news:<1088760450.97543.0_at_iris.uk.clara.net>...
> RHEL 3.0
> 9.2.0.4
>
> Hi,
>
> Just running through recover scenarios so that i can fully document all eventualities.
> Each night i take full backups using RMAN and the current control file is included in this backup. I can use this backup to restore
> an instance to a completely new machine as long as i have the control files from the asource database.
>
> Is it possible to restore an instance using just a full RMAN backup that contains the current control file from the db when it was
> backed up?
>
> If i have access to the control files then i can recover quite simply using something along the lines of
>
> sql > startup mount
>
> rman > run {
> allocate channel dev1 type disk;
> restore database
> release channel dev1;
> }
>
> sql > alter database open resetlogs
>
> but this does not work if i don't the control file
>
> thanks
>
> (sill wading my way though the docs at tahiti regarding all this)

I'm not quite sure exactly what you are asking, but you can create the controlfile if you don't have one
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_54a.htm#2061002 . Also, this is kinda interesting:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/rcmsynta46.htm#1002154

jg

--
@home.com is bogus.
http://otn.oracle.com/pub/articles/kalosi_vim.html