| Database Dismounting takes much time [message #355849] |
Tue, 28 October 2008 01:03  |
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 #355874 is a reply to message #355849] |
Tue, 28 October 2008 04:33  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
