Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: database doesnt shutdown , help needed
I've gotten to the point on these shutdowns-that-never-happen where I make
sure I stop the Intelligent Agent before attempting the shutdown (assuming
this is an o/s scripted shutdown-backup you're doing). For some reason,
having that hanging around the place can make a difference.
Regards
HJR
-- ------------------------------------------ Resources for Oracle : www.hjrdba.com ============================ "Bruce" <bduff_at_condenast.co.uk> wrote in message news:2df6b834.0203280226.707746c4_at_posting.google.com...Received on Thu Mar 28 2002 - 05:39:53 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....