Re: Noarchivelog Restart

From: Ed Long <>
Date: Fri, 21 Jan 2011 11:18:05 -0800 (PST)
Message-ID: <>

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


On Fri, Jan 21, 2011 at 3:08 PM, Ed Long <> 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 - 13:18:05 CST

Original text of this message