We do exactly the same as a standard on 100+ prod databases - had very little problem with it.
Printable View
We do exactly the same as a standard on 100+ prod databases - had very little problem with it.
Quote:
Originally posted by pando
we do
alter system switch logfile
alter system checkpint
my understanding is taht alter system switch logfile triggers a checkpoint. and pando did this so as to update the changes to the redo log files right?
here is where i dont understand.. after both alter statements in the earlier quote, why need the above three statements. wont a shutdown immediate do the trick...Quote:
shutdowna bort
startup restrict
shutdown immediate
i will do the below (from pando ones...)
alter system switch logfile
alter ssytem checkpoint
shutdown immediate
is there a difference?
shutdown imemdiate executes a checkpoint implicitly
we do shutdown abort because sometimes it tkes 10 minutes to shutdown immediate a database
shutdown abort hmm takes 1 second
okay.. another case of shutdown immediate...
waited for more than 10mins..
then did a shutdown abort...
oracle displays this "ORA-01089: immediate shutdown in progress - no operations are permitted"
and in my alert file, i had this "License high water mark = 2" which indicates that there are only 2 sessions only, right?
also from this http://metalink.oracle.com/metalink/...&p_id=164504.1
i think thats all... to my queries.. thanks folks for bearing with me