Oracle启动和关闭方式的区别.doc

Oracle启动和关闭方式的区别
The difference between starting and closing modes in Oracle
Shutdown command
SHUTDOWN has four paramSTARTUP RESTRICT: only users with RESTRICTED SESSION privileges are allowed access to the database.
STARTUP RECOVER: database startup, and start media recovery.
This article from CSDN blog, reprinted please indicate the source:
. net/sun_gv/archive/2009/08/16/4452876. aspx
The Oracle database provides several different ways of starting and closing databases, and this article introduces Zhou Xiang to the differences between these startup and shutdown methods, along with their different functions.
First, start and close the Oracle database
For most Oracle DBA, the most common way to start and turn off the Oracle database is the Server Manager on the command line. From Oracle 8i, Server Manager any system will be focused on the SQL*Plus, that is to say from 8i to database startup and shutdown can be done directly through SQL*Plus, without the need for Server Manager, but the system in order to maintain the downward compatibility still retains the Server Manager tools. In addition, the system can be started and closed through the Oracle Enterprise Manager of the image user tool (GUI). The image user interface Instance Manager is very simple and is no longer detailed here.
To start and close the database, you must log on to a user with Oracle