Re: Shutdown Abort and Backup

This works as long as you do not need *media* recovery. Instance recovery will succeed.

Martin Haltmayer

Doug Burns wrote:
>
> Maybe I should have been more specific. What I meant to say was why do
> Oracle insist on a clean shutdown before an off-line backup of a database
> which is not running in ARCHIVELOG mode.
>
> I don't have the Oracle7 manuals to hand, but the 8 documentation says ...
>
> 'A backup of a database running in NOARCHIVELOG mode and not shutdown
> cleanly is useless. In such cases, the backed up files are inconsistent with
> respect to a point-in-time, and because the database is in NOARCHIVELOG
> mode, there are no logs available to make the database consistent. Recovery
> Manager does not allow you to back up a database that has been running in
> NOARCHIVELOG mode and shutdown abnormally, because the backup is not usable
> for recovery.
>
> Now, surely the online redo log files (which you would obviously backup)
> contain the necessary information for Instance Recovery when the backups are
> restored?
>
> I first came across this because SHUTDOWN IMMEDIATE was ropey to say the
> least on earlier versions of Oracle (I'm not sure about now) so we used to
> use SHUTDOWN ABORT until, when I started teaching courses for Oracle I was
> told not to say this. I'm now starting to teach again (for Learning Tree)
> and the course notes say the same thing, but don't answer my question.
>
> Thanks for all the input, folks.
>
> Martin Haltmayer wrote in message <34FAC27D.CD93C71E_at_KirchGruppe.de>...
> >Oracle do not insist on a clean backup. If you run your database in
 archivelog
> >mode, you may also do a hot backup which is nearly never a clean backup.
> >
> >For cold backups I do not have an idea by now, perhaps later.
> >
> >Martin Haltmayer
> >
Received on Tue Mar 03 1998 - 00:00:00 CST