Thanks Wayne.
I am just running a recovery test (on a test server),
I am going to keep control files intact and delete
some of the datafiles after shutting down oracle. Then
'startup mount' and run the full restore, inclding a
full restore and restore from last cumm incr backup.
MK
--- Wayne T Smith <wts AT maine DOT edu> wrote:

> 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
> >   
> 



       
____________________________________________________________________________________
Got a little couch potato? 
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz
 
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu