Re: database doesnt shutdown , help needed

Thanks for the reply. I know sessions are still connected and to actually do a backup I have correctly shutdown the database (shutdown abort, startup restrict and then shutdown normal) then the database is backed up and gzipped properly.

This backup script was fine for 18 months and this problem has benn very intermitent over the last month and am trying to get to the bottom of it.

Thanks    

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:<yvDo8.3251$e5.19613_at_news.indigo.ie>...
> It will not shut down if sessions are connected.
>
> Check v$session table before you shutdown. You will have connections that
> are open.
> (the oracle Reference manual contains details of v$session)
>
> Please note this is bad. When you restart the DB it must roll forward and
> back, so you are taking a backup of an unstable system....
>
> Please note this also includes SQLPLUS that are connected but not apparently
> doing anything.
> "Bruce" <bduff_at_condenast.co.uk> wrote in message
> news:2df6b834.0203280227.61aa5103_at_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 - 09:12:58 CST