Re: Crash Recoveries

Jonathan,

If you are shutting down your database with "IMMEDIATE" option no crash recovery should occur on startup.

For the export, just use CONSISTENT=Y to get consistent copy of your database.

On our newest Oracle DBA forums there is a nice post how to do an cold backup on Windows:

http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi?s=3cbd2e657cfbffff;act=ST; f=16;t=170
(cut and paste the piecse of this link into your browser if the text is not formated right)

Hope that helps,

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com

"Jonathan Bliss" <bliss_jonathan_at_hotmail.com> wrote in message news:ae530df0.0204170040.17beeb8d_at_posting.google.com...
> This isn't urgent, but I am curious. Oracle 8.1.7, NT4 SP6
>
> I have a daily backup strategy that shuts down the database immediate,
> restarts the database runs an export, shuts down immediate again,
> stops the services, runs a full cold backup and then restarts the
> database.
>
> Until recently I was using ORADIM and getting crash recoveries most
> days. I switched to SQL*Plus /nolog, connect inernal and scripts as I
> could find no way with ORADIM to startup restrict and wanted to have
> DBA only access as an extra protection during the export. I still get
> the following about once a month.
> There is never a problem recovering, but why hasn't it gone down
> cleanly? Should I be looking for a problem that may be about to
> manifest itself? Running a search I only find references to shutdown
> abort or failures to recover.
>
> Tue Mar 26 20:30:12 2002
> alter database open
> Beginning crash recovery of 1 threads
> Tue Mar 26 20:30:13 2002
> Thread recovery: start rolling forward thread 1
> Recovery of Online Redo Log: Thread 1 Group 2 Seq 1322 Reading mem 0
> Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
> Tue Mar 26 20:30:16 2002
> Thread recovery: finish rolling forward thread 1
> Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo
> blocks read
> Crash recovery completed successfully
>
> Thanks
>
> Jon
Received on Wed Apr 17 2002 - 17:18:08 CDT