Re: Noarchivelog Restart

From: Niall Litchfield <>
Date: Thu, 27 Jan 2011 08:01:10 +0000
Message-ID: <>

Hi ed,

I didn't see your original restore script. Given that you have autobackups, I'd expect it to issue a set until time, then restore controlfile from autobackup followed by the restore db and recover noredo. Apologies if that's what you did

On 26 Jan 2011 23:19, "Ed Long" <> wrote:

After a bunch more thinking and reading I found something that works. shutdown immediate;
startup nomount;
restore controlfile from
'C:\oracle11g\flash_recovery_area\orcl\backupset\2010_12_21\O1_MF_NCSNF_TAG20101221T175022_6k2D4NSM_.BKP'; startup mount;
startup open resetlogs;

In short, it appears that I had to specify the location of the backup piece that contained the controlfile backup even though list backup could see it. It appears that backup database under most scenarios will backup the control files.
Autobackup did not help.

So now, I need to write a script such that all future restores are point and shoot as much as I've enjoyed this experience.

Thank you all for the great assistance and kind indulgence. Edward Long

  • On *Wed, 1/26/11, Ed Long <>* wrote:

From: Ed Long <>

> Subject: Re: Noarchivelog Restart
To: "De DBA" <>

> Cc: "''" <>
Date: Wednesday, January 26, 2011, 1:30 PM

> Hi everyone.
> Here is today's update.
> Oracle seconded "De DBA"''s suggestion to recreate the co...

> Any experience with

> Edward Long
> --- On Wed, 1/26/11, De DBA <> wrote:

>> From: De DBA <>
>> Subject: Re: Noarchivelog Restart
>> To: "Ed Lo...

Received on Thu Jan 27 2011 - 02:01:10 CST

Original text of this message