Thanks for the answers
"koert54" <koert54_at_nospam.com> a écrit dans le message de news:
XTSM7.8659$jP2.2691704015_at_hestia.telenet-ops.be...
> > - I did a shutdown and there are users connected,
> > I can't do another shutdown immediate.
> > What is the good solution to stop the database ?
>
>
> 1. Open another sqlplus/svrmgrl - do a shutdown abort. After that do a
> startup, followed by a shutdown immediate ... this way
> you have performed an instance recovery + checkpointing ... so it'll be a
> clean shutdown to be used for, for example a cold backup...
> 2. Inform the users and urge them to log out (yeah right)
> 3. kill'm all (preferable using a nifty script .... nah)
>
> If you don't like a shutdown immediate you can also use a 'shutdown
> transactional' - Users will only be disconnected when their transactions
end
> (rollback/commit) after which the DB closes down...
>
> > - Is it possible to close a database when it is open ?
> > alter database close does no work ...
> Don't know which version you're working on but on 8i - when the DB is
open -
> you can do 'alter database close', 'alter database dismount', etc
> However if you first issued a 'shutdown' you can't just do an 'alter
> database close' because the database is performing a shutdown ...
>
>
> "Thierry" <thierry.constant2_at_wanadoo.fr> wrote in message
> news:3c03f6ac$0$210$626a54ce_at_news.free.fr...
> > Hi,
> >
> > I have two questions:
> >
> > - I did a shutdown and there are users connected,
> > I can't do another shutdown immediate.
> > What is the good solution to stop the database ?
> >
> > - Is it possible to close a database when it is open ?
> > alter database close does no work ...
> >
> >
> > thanks ...
> >
> >
>
>
Received on Wed Nov 28 2001 - 14:41:03 CST
