Re: Crash Recoveries

Trifon

Thanks this helps although it is fairly similar to what I am doing anyway. As you will see in my other reply I don't use Consistent=Y because ORA-04030 errors cause regular failures of the export. I feel safest with an export and cold datafiles backed up.

The backup is not the problem though, I just put it in to stress the fact that I know I am issuing shutdown immediate, and why I shutdown every day. The question is, why so many crash recoveries with no trace files and nothing else in the Alert.log. Something is either causing the system to shut down less than gracefully or fail to detect it has gone down gracefully when it restarts. Incidentally, I noticed last night that my redologs were STALE, log switching sorted this out but I wonder if it could be related. If I'm not going to look at this sort of thing, why am I bother checking stuff every day.

Jon

"Trifon Anguelov" <trifona_at_pacbell.net> wrote in message news:<Awmv8.4588$Mi5.2735929527_at_newssvr21.news.prodigy.com>...
> 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
>
> ----------------------------------------------------------------------------
Received on Thu Apr 18 2002 - 05:41:06 CDT