From: Martin Haltmayer Subject: Re: Shutdown Abort and Backup Date: 1998/03/03 Message-ID: <34FC3F40.89CA43E7@KirchGruppe.de>#1/1 Content-Transfer-Encoding: 7bit References: <#Pf3znVR9GA.274@upnetnews04> <34FAC27D.CD93C71E@KirchGruppe.de> To: Doug Burns Content-Type: text/plain; charset=us-ascii Organization: KirchGruppe Mime-Version: 1.0 Newsgroups: comp.databases.oracle.server 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@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 > >