A few points for note or discussion ...

* The "shutdown immediate" and "startup mount" (or even "startup 
nomount") have certain requirements.  Depending on what you are trying 
to test (what you have lost), your test may or may not be successful.

* Since you don't have a recovery catalog, RMAN will be getting its 
information from one of your controlfiles.  Your restore cannot proceed 
without that controlfile information.

* The "resetlogs" is not necessary if you are able to recover to present 
time.  If you can't/don't do a complete recovery to present time, then 
you now have a new DB in which the old logs are no longer valid.  Make 
sure to do a new full backup immediately, as the history of the old logs 
is no longer available (or valid) in the controlfiles.

Using a recovery catalog gives you a few more options along with another 
copy of your information critical to recovery.

cheers, wayne

Mike Kiles wrote, in part,  on 2007-08-02 9:44 AM:
> I am planning to test a full restore of Oracle
> database which is backed up using RMAN (no RMAN
> catalog). We do full backup on weekend and cumm
> incremental during weekdays. The RMAN backup script
> backs up the datafiles, archive logs and in the end it
> backs up the control file.
>
> Here are the steps that I am planning to use. If you
> have any additions/deletions please do let me know:
>
> Login as oracle user
> $ svrmgrl
> SVRMGR > connect internal
> SVRMGR > shutdown immediate
> SVRMGR > startup mount
>
> Launch RMAN by 'rman target user/passwd nocatalog'
> RMAN> run {
>  allocate channel t1 type SBT_TAPE;
>  restore database;
>  recover database;
>  release channel t1;
>  }
>
> RMAN> exit
>
> $ svrmgrl
> SVRMGRL> connect internal
> SVRMGRL> alter database open 
>
> In my opinion that should cover it all. I also read
> that you should use 'alter database open resetlogs' if
> doing a full recovery. Is that needed? 
> Any other suggestions?
>
> TIA
>
>
>
>        
> ____________________________________________________________________________________
> Choose the right car based on your needs.  Check out Yahoo! Autos new Car 
> Finder tool.
> http://autos.yahoo.com/carfinder/
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>   

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu