Home » RDBMS Server » Server Administration » Database Dismounting takes much time (Oracle 10g.1)
Database Dismounting takes much time [message #355849] Tue, 28 October 2008 01:03 Go to next message
MELAKU
Messages: 32
Registered: April 2007
Location: ETHIOPIA
Member
Dear experts,
I was shutting down immediate my databse. It closed well but at dismaounting it took much time. So far it took more than two hours. Can you advise me what to do now? Can I login with another session and run shutdown abort? I am in a great problem that all our staffs can not work with database. This database is a Bank database where customers are shouting. I need your kind support.
Re: Database Dismounting takes much time [message #355853 is a reply to message #355849] Tue, 28 October 2008 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Administrator's Guide
Chapter 3 Starting Up and Shutting Down
Section Shutting Down a Database

Regards
Michel

Re: Database Dismounting takes much time [message #355874 is a reply to message #355849] Tue, 28 October 2008 04:33 Go to previous message
halim
Messages: 100
Registered: September 2008
Senior Member


if a database take time more to down

I think the best way to
shut down an Oracle database is like this:
(first time) you can input:

SQL> alter system checkpoint;
SQL> shutdown abort

In the few situations such as cold backups and version upgrades
where consistent datafiles and controlfiles are
required, you can do this:

SQL> alter system checkpoint;
SQL> shutdown abort

$ lsnrctl stop

SQL> startup restrict
SQL> shutdown immediate


regards
Halim
Previous Topic: Session of Oracle with tomcat increased, how to find which tomcat server
Next Topic: session still KILLED in oracle, process don´t exist in SO
Goto Forum:
  


Current Time: Sun Dec 04 04:18:51 CST 2016

Total time taken to generate the page: 0.05552 seconds