Close the Database by Terminating the Instance (304)
In rare emergency situations, you can terminate the instance of an open database to
close and completely shut down the database instantaneously. This process is fast,
because the operation of writing all data in the buffers of the SGA to the datafiles and
redo log files is skipped. The subsequent reopening of the database requires recovery,
which Oracle performs automatically.
透過終止例項來關閉資料庫
1. 在緊急情況下,可以終止一個處於開啟狀態的資料庫的例項,以便立即關閉並完全停止一個資料庫
2. 這個過程很快,因為將 SGA 內各緩衝區的資料寫入資料檔案和重做日誌檔案的步驟被省略了
3. 資料庫重新開啟的時候 Oracle 將自動地執行恢復操作
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-987548/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Close a Database (303)Database
- Oracle database instanceOracleDatabase
- The Instance and the Database (285)Database
- 【RAC】PMON: terminating the instance due to error 481Error
- 理解Database和InstanceDatabase
- 3.2.1 Mounting a Database to an InstanceDatabase
- Overview of Instance and Database Startup (289)ViewDatabase
- ORA-38760: This database instance failed to turn on flashback databaseDatabaseAI
- LGWR (ospid: 29534): terminating the instance due to error 4021Error
- database和instance的區別Database
- Fails to Start: PMON (ospid: nnnn): terminating the instance due to error 481AIError
- LMON: terminating instance due to error 29702 -- ORA-29702Error
- [Shell] monitor oracle database listener & instance statusOracleDatabase
- Overview of Database and Instance Shutdown (302)ViewDatabase
- [總結]9i RAC LMON: terminating instance due to error 29702Error
- [總結]9i RAC LMON: terminating instance due to error 29702Error
- Top 5 Database and/or Instance Performance Issues in RAC EnvironmentDatabaseORM
- 7.monitor oracle database listener & instance statusOracleDatabase
- ORA-38760: This database instance failed to turn on flashback database 第三篇DatabaseAI
- ORA-38760: This database instance failed to turn on flashback database 錯誤解決DatabaseAI
- terminating the instance due to error481導致ASM無法啟動故障ErrorASM
- 12C-ORA-65086: cannot open/close the pluggable databaseDatabase
- 3.1.5.2 Starting an Instance, and Mounting and Opening a DatabaseDatabase
- Migrate database from single instance to Oracle RACDatabaseOracle
- Connected to an idle instance – while database is runningWhileDatabase
- RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)RESTDatabaseORMROSSQLServerError
- can close the database Connection before the JTA transaction commit or rollDatabaseMIT
- Database and/or Instance Performance Issues in RAC Environment_1373500.1DatabaseORM
- Oracle9.2.0.4 RAC 升級到Oracle9.2.0.7 ,LMON: terminating instance due to error 29702OracleError
- Oracle 19c Concepts(13):Oracle Database InstanceOracleDatabase
- oracle rconfig convert single instance to rac databaseOracleDatabase
- oracle 9i single instance convert to rac databaseOracleDatabase
- oracle中instance name 和database name的一點體會OracleDatabase
- 資料庫各個階段的INSTANCE DATABASE狀態資料庫Database
- Instance database dbid sid tnsname等概念混個眼熟Database
- 系統記憶體不足導致oracle程式被誤殺terminating the instance due to error 822記憶體OracleError
- 304-5
- HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another NoRESTDatabase