Re: Shutdown Abort and Backup

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