2013年Oracle数据库（分布式数据库）.pptVIP

* * Starting Up a Database 启动SQL*Plus SQLPLUS /NOLOG CONNECT username/password AS SYSDBA 启动数据库实例到不同状态 STARTUP Starting an Instance, and Mounting and Opening a Database STARTUP NOMOUNT Starting an Instance Without Mounting a Database STARTUP MOUNT Starting an Instance and Mounting a Database * * Starting Up a Database 启动数据库实例 STARTUP RESTRICT instance is available only to administrative personnel (not general database users) STARTUP FORCE If an instance is running, STARTUP FORCE shuts it down with mode ABORT before restarting it. * * Starting Up a Database Altering Database Availability Mounting a Database to an Instance ALTER DATABASE MOUNT; Opening a Closed Database ALTER DATABASE OPEN; * * OPEN MOUNT NOMOUNT SHUTDOWN STARTUP NOMOUNT; STARTUP ALTER DATABASE MOUNT; ALTER DATABASE OPEN; Oracle 数据库启动命令：到不同状态 Starting Up a Database * * 8.Shutting Down a Database 关闭三步骤： 1、Closing the database. 2、Dismounting the database. 3、Shutting down the instance. * * Shutting Down a Database Shutting Down with the NORMAL Clause SHUTDOWN NORMAL No new connections are allowed after the statement is issued the database waits for all currently connected　users to disconnect from the database. * * Shutting Down a Database Shutting Down with the IMMEDIATE Clause SHUTDOWN IMMEDIATE No new connections are allowed, nor are new transactions allowed to be started,after the statement is issued. Any uncommitted transactions are rolled back. Oracle Database does not wait for users currently connected to the database to disconnect. The database implicitly rolls back active transactions and disconnects all connected users. * * Shutting Down a Database Shutting Down with the TRANSACTIONAL Clause SHUTDOWN TRANSACTIONAL No new connections are allowed, nor are new transactions allowed to be started,after the statement is issued. After all transactions have completed, any client still connected to the instance is disconnected. At this point, the instance shuts down just as it would