Re: Noarchivelog Restart

From: Guillermo Alan Bort <>
Date: Fri, 21 Jan 2011 17:36:27 -0300
Message-ID: <>

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?


On Fri, Jan 21, 2011 at 4:18 PM, Ed Long <> 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 <>* wrote:
> From: Guillermo Alan Bort <>
> Subject: Re: Noarchivelog Restart
> To:
> Cc:
> 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 <<http://mc/compose?>
> > 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

Received on Fri Jan 21 2011 - 14:36:27 CST

Original text of this message