Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: not able to shutdown the database, detached processes to terminate

Re: not able to shutdown the database, detached processes to terminate

From: Hans Wijte <Hans.Wijte_at_mail.ing.nl>
Date: 16 Sep 2004 06:50:00 -0700
Message-ID: <2dec747a.0409160550.4563ea55@posting.google.com>


This can occur for numerous reasons, including the following :  having more than 1 archiver process due to a manual  "log archive start" command; when you do a shutdown  these 'extra' archive processes won't shutdown  There is a workaround for this situation :  alter system set log_archive_max_processes = ..  high number, e.g. 10) and do a shutdown immediate

Btw. : why not do an online backup ? that way you don't have   to shutdown. If you want to do an automated shutdown for a   cold backup and if you are on Unix, you will sooner or later   also stumble upon the twin brother of the Ora message you   are now receiving, i.e. :
  "SHUTDOWN : waiting for active calls to complete",   at least when you are Received on Thu Sep 16 2004 - 08:50:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US