By
Kamran Agayev A.
Starting Up and Shutting Down
If you know that media recovery is required, you can
start an instance, mount a database to the instance, and have the
recovery process automatically start by using the STARTUP command
with the RECOVER clause: STARTUP OPEN RECOVER
When SHUTDOWN IMMEDIATE command used, any uncommitted
transactions are rolled back. If long uncommitted transactions
exist, this method of shutdown might not complete quickly, despite
its name
Occasionally you might want to put a database in a state
that allows only DBA transactions. Such a state is referred to as s
quiesced state. Without ability to quiesce the database, you would
need to shut down the database and reopen it in restricted mode. Use
the ALTER SYSTEM QUIESCE RESTRICTED; command.
To restore the database to normal operation use ALTER
SYSTEM UNQUIESCE;
|
|
 |
|
Get the Complete
Oracle Tuning Details
The landmark book
"Oracle
Tuning: The Definitive Reference Second Edition" has been
updated with over 1,150 pages of expert performance tuning tips.
It's packed with scripts and tools to hypercharge Oracle 11g
performance and you can
buy it for 40% off directly from the publisher.
|
|
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
| |
| |
Copyright ©
1996 -2011 by Burleson Enterprises. All rights reserved.
Oracle® is the registered trademark of Oracle
Corporation. SQL Server® is the registered trademark of Microsoft
Corporation.
Many of the designations used by computer vendors to distinguish their
products are claimed as Trademarks
|
|
