Re: recover question

"Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message news:<2KTFc.3679$PO4.31887594_at_news-text.cableinet.net>...
> > Unfortunately, Howard doesn't have much about RMAN on his site. Much
> > better site for that purpose would be:
> >
> > http://www.orsweb.com/downloads/sql/backup_recovery/
> >
> > Howard has the best "9i New Features" around, which easily rivals Rob
> > Freeman's version.
>
> without the control file the instance can't be mounted to enable RMAN to
> restore the instance and therefore extract the control file from the backup?
>
> a catch22 situation surely?

No, because you can create a control file from the nomount. But as you now know from everyone's posts, it is far more than nice-to-have to do the backup to trace, and it is critical to understand the control file and redo log concepts, and to practice the various scenarios. As others have mentioned, it is worthwhile to google hjr's cdos posts.

It is possible to run without a catalog, perhaps even preferable for small sites, but you are giving up a lot of functionality and have to deal with what is left.

jg

--
@home.com is bogus.
Linux Liars Club:  http://searchenterpriselinux.techtarget.com/originalContent/0,289142,sid39_gci991557,00.html