Re: SQL error during shutdown ..

From: <bdbafh_at_gmail.com>
Date: 5 Mar 2005 08:57:14 -0800
Message-ID: <1110041834.317267.67830@g14g2000cwa.googlegroups.com>

check for trace files in /bdump and /udump. if its due to SNPn processes (dbms_jobs) they should dump trace in /bdump.

if you really want a clean shutdown prior to a cold backup, I'd suggest

alter system switch logfile
shutdown abort
startup mount restrict
alter system set job_queue_processes=0
alter database open
shutdown immediate

In general, I find cold backups to be a pain, unless you're talking about a DW running in noarchivelog mode.

I'd rather just use a hot physical backup, copy the online redo logs and controlfiles + any archlogs and call that a cold backup set - like prior to applying a patchset. Less downtime, one set of scripts to maintain.

-bdbafh Received on Sat Mar 05 2005 - 10:57:14 CST