What Happens When You Open a Database (297)
Opening a mounted database makes it available for normal database operations. Any
valid user can connect to an open database and access its information. Usually, a
database administrator opens the database to make it available for general use.
When you open the database, Oracle opens the online datafiles and redo log files. If a
tablespace was offline when the database was previously shut down, the tablespace
and its corresponding datafiles will still be offline when you reopen the database.
If any of the datafiles or redo log files are not present when you attempt to open the
database, then Oracle returns an error. You must perform recovery on a backup of any
damaged or missing files before you can open the database.
開啟資料庫時發生了什麼
1. 開啟資料庫時,Oracle 將開啟所有聯機的資料檔案及重做日誌檔案
2. 在資料庫之前offline的表空間,在資料庫重新開啟之後該表空間及他關聯的資料檔案依然為offline狀態
3. 如果 Oracle 在開啟資料庫時找不到所需的資料檔案或重做日誌檔案,系統將返回錯誤資訊.
管理員必須從備份中恢復損壞或缺失的檔案後,才能開啟資料庫.
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10599713/viewspace-987417/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- What happens when exadata has lost two disks?（轉）APP
- What is the Impact on the Database When Modifying the OS DateDatabase
- When you issue "ALTER TABLESPACE xxx READ ONLY",what will oracle do?Oracle
- You've got to find what you loveGo
- When you're goneGo
- robbin的自白：You've got to find what you loveGo
- TLS Poison - When TLS Hack youTLS
- What you should know about JavaJava
- For example, when you want to get the ball to the ground
- What You See Is What You Get 所見即所得 20240525~0526 心得記錄
- What are general rules when deciding on index?Index
- What database aspects should be monitored?Database
- [翻譯]What You Need to Begin iOS ProgrammingiOS
- Unlearn What You Want to Forget Efficient Unlearning for LLMs
- 【HPUX】What to do when mount does not work on HP-UX?UX
- alter database open resetlogs;Database
- PostgreSQL DBA(44) - Privileges & User Management - What You Should KnowSQL
- QUESTION :What kind of shared storage do you use for Oracle RAC?Oracle
- Tasks of a Database Administrator : Create and Open the Database (10)Database
- PostgreSQL DBA(71) - Locks(Table-Level)：What You Should KnowSQL
- PostgreSQL DBA(74) - Locks(Row-Level)：What You Should KnowSQL
- sencha architect/sencha touch , to prevent breakpoint lost when you debug
- Password is required when adding a database to AG group if the database has a master keyUIDatabaseAST
- What to Expect When Moving From SAP Business Suite to SAP S/4 HANAUI
- PostgreSQL DBA(75) - Locks(locktype：transactionid)：What You Should KnowSQL
- PostgreSQL DBA(76) - Locks(Advisory Locks)：What You Should KnowSQL
- 原始碼為你而開嗎？？Is Open Source for You? (轉)原始碼
- ASM Diskgroup Can Not Be Shown When Creating Database With DBCAASMDatabase
- Taking Systemstate Dumps when You cannot Connect to Oracle [ID 121779.1]Oracle
- GET ORA-32700 WHEN TRYING TO CREATE DATABASE USING 9.2Database
- InfluxDB 2.x Open Source Time Series DatabaseUXDatabase
- Open a Database in Read-Only Mode (301)Database
- Summary For Forcing The Database Open With `_ALLOW_RESETLOGS_CORRUPTION`Database
- Can you create a second voting disk in a different ASM diskgroup when using External Redundancy in 1ASM
- ORA-01679: database must be mounted EXCLUSIVE and not open to activateDatabase
- 從開源界發現的商機——What Business Can Learn from Open Source
- When to Use Startup / Shutdown DB and Alter Database Command in 12c_1582453.1Database
- use database 切換提示You can turn off this feature to get a quicker startupDatabaseUI