How about 'RECOVER DATABASE' without any SCN and let Oracle decide? PITR and NOARCHIVELOG don't go together. can you show me the output of list backup of database? Alan.- On Fri, Jan 21, 2011 at 4:18 PM, Ed Long <rdhm99a@xxxxxxxxxxx> wrote: > Thanks for the help. > You are correct this is NOARCHIVELOG. My restore command is exactly the > form you suggest. > Essentially I am trying to do a database point in time recovery which > appears to require a recover database of some sort after the restore. > If I try to open the database after the restore without the recover I get > RMAN-03002 failure of alter db command > ORA-01147 System tablespace file 1 is offline > ORA-01110 data file 1: C:\ORACLE11G\ORADATA\ORCL\SYSTEM01.DBF > > Edward Long > > --- On *Fri, 1/21/11, Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>* wrote: > > > From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx> > Subject: Re: Noarchivelog 11.2.0.1 Restart > To: rdhm99a@xxxxxxxxxxx > Cc: oracle-l@xxxxxxxxxxxxx > Date: Friday, January 21, 2011, 2:10 PM > > > I'm assuming the DB is in noarchivelog mode, and that the LEVEL0 was taken > with the DB in MOUNT mode. If that's the case, a simple restore, with no > UNTIL clause should bring the data to the point of the backup. Why are you > trying to specify the SCN? > > cheers > Alan.- > > > On Fri, Jan 21, 2011 at 3:08 PM, Ed Long > <rdhm99a@xxxxxxxxxxx<http://mc/compose?to=rdhm99a@xxxxxxxxxxx> > > wrote: > > Hi everyone and happy Friday. > I have a benchmark system that I can't get to restart and need your advice. > Please understand that I've spent half a day on the RMAN user guide and > reference without success. > Here is the sequence that has worked up to now. > 1: Create LEVEL 0 backup using RMAN. > 2: Run Real Application Test test. > 3: recycle system to mount mode. > 3: Restore backup. > 4: Recover to SCN. (No real logs to apply). > 5: start open. > None of the recover until options appear to work. > I have an export of the application database so I can if necessary drop the > database and start over again. However, I want to understand this recovery > scenario so if it happens in the future on a system I don't have an export > of I understand my options. > All of my options end up with the system table space off line. I don't see > a way to get it back online. > RMAN 11003 appears to be the root of the problem although the version I'm > seeing is garbled. > Edward Long > > >