Incomplete Recovery

From: Norman Dunbar <ndunbar_at_lynxfinancialsystems.co.uk>
Date: Tue, 30 Jan 2001 08:43:43 -0000
Message-ID: <F43E6BAE5BB5D411A44C00805FBE740D46FEAF@apps.lynx-fsc.co.uk>

>> Not true -not entirely, anyway. Backing up cold after a shutdown
 abort
>>simply means that the database, when restored in a noarchivelog
 scenario,
>> will immediately need Instance Recovery.

I agree if running noarchivelog, but for incomplete recovery the scenario is totally different and requires archivelog and don't recover the control files :o)

>>I don't disagree, because one can never be too careful. But it's not
>> strictly necessary.

We were shown how to break an instance on the B&R course. Shutdown abort and do a recovery, works until you come to open the database. Bang - file 'n' requires more recovery. Bye bye data - at least back to the previous full (cold) backup. Its fun :o)

Regards
HJR
> HTH.
>
> Regards, Norman.
>
>

---

> --------
> Norman Dunbar EMail: NDunbar_at_LynxFinancialSystems.co.uk
> Database/Unix administrator Phone: 0113 289 6265
> Lynx Financial Systems Ltd. Fax: 0113 201 7265
> URL: http://www.LynxFinancialSystems.com
>

---

> --------
>
> >> Database down, albeit after a shutdown abort, so the backup was
 cold.
>

-----Original Message-----
From: Howard J. Rogers [mailto:howardjr_at_www.com] Posted At: Monday, January 29, 2001 11:43 AM Posted To: server
Conversation: Incomplete Recovery
Subject: Re: Incomplete Recovery Received on Tue Jan 30 2001 - 02:43:43 CST