Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: database doesnt shutdown , help needed
someone has left an open session running a batch job overnmight?
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Bruce" <bduff_at_condenast.co.uk> wrote in message news:2df6b834.0203280226.707746c4_at_posting.google.com...Received on Thu Mar 28 2002 - 04:42:35 CST
> 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 post a thread if you have seen this issue before. If you need
> more info let me know.
>
> Thanks and have a good Easter....