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