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

Home -> Community -> Usenet -> c.d.o.misc -> database doesnt shutdown , help needed

database doesnt shutdown , help needed

From: Bruce <bduff_at_condenast.co.uk>
Date: 28 Mar 2002 02:27:29 -0800
Message-ID: <2df6b834.0203280227.61aa5103@posting.google.com>


Hi there,

Each night my backup of my production 8.1.7.0.0 database has been playing up. The database runs in noarchivelog mode.

However it sometimes (and I mean intermittently) does not shutdown before it does the copy of the files etc and stays like that until I manually do a shutdown abort, startup restrict, shutdown normal etc. Then the script carries on and copies the files etc. The dbase then gets restarted. The database is using shutdown immediate. I generate a trace file as well using 'Alter session set events '10400 trace name context forever, level 1'; The contents of which is not mega helpful I must admit.

The alert log says: "SHUTDOWN: waiting for active calls to complete.

I'm beginning to think I may have to write some logic in the backup script about this but want some clarification from anyone out there if they have seen this same problem on this release of the database.

Please let me know if you have seen this issue before.

Thanks and have a good Easter.... Received on Thu Mar 28 2002 - 04:27:29 CST

Original text of this message

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