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: database doesnt shutdown , help needed

Re: database doesnt shutdown , help needed

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 28 Mar 2002 10:42:35 -0000
Message-ID: <3ca2f3ab$0$232$ed9e5944@reading.news.pipex.net>


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...

> 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....
Received on Thu Mar 28 2002 - 04:42:35 CST

Original text of this message

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