Open a Database in Read-Only Mode (301)
You can open any database in read-only mode to prevent its data from being modified
by user transactions. Read-only mode restricts database access to read-only
transactions, which cannot write to the datafiles or to the redo log files.
Disk writes to other files, such as control files, operating system audit trails, trace files,
and alert logs, can continue in read-only mode. Temporary tablespaces for sort
operations are not affected by the database being open in read-only mode. However,
you cannot take permanent tablespaces offline while a database is open in read-only
mode. Also, job queues are not available in read-only mode.
Read-only mode does not restrict database recovery or operations that change the
database’s state without generating redo data. For example, in read-only mode:
■ Datafiles can be taken offline and online
■ Offline datafiles and tablespaces can be recovered
■ The control file remains available for updates about the state of the database
One useful application of read-only mode is that standby databases can function as
temporary reporting databases.
以只讀模式開啟資料庫
1. 可以以只讀模式開啟資料庫來阻止使用者事務修改資料 , 只有只讀事務才能訪問只讀資料庫,
只讀事務不能向資料檔案及重做日誌檔案寫入資訊
2. 在只讀模式下,控制檔案,審計檔案,跟蹤檔案及告警日誌依然可以被寫入.
用於進行排序操作的臨時表空間在只讀模式下依然可用.
使用者不能在只讀模式下將永久表空間離線.
作業佇列在只讀模式下無法使用.
3. 在只讀模式下,可以執行資料庫恢復,也可以執行改變資料庫狀態的操作(該類操作不產生重做資料).例如,在只讀模式下:
* 可以令資料檔案聯機或離線
* 可以恢復離線的資料檔案與表空間
* 控制檔案可以用於記錄資料庫狀態變化
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-987545/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 3.2.3 Opening a Database in Read-Only ModeDatabase
- cannot mount database in EXCLUSIVE modeDatabase
- alter database open resetlogs;Database
- Tasks of a Database Administrator : Create and Open the Database (10)Database
- PROTECTION_MODE is UNPROTECTED at standby database 分析Database
- Read-Only Tables in Oracle Database 11g Release 1OracleDatabase
- How to Duplicate a Database in NOARCHIVELOG mode (Doc ID 275480.1)DatabaseHive
- RMAN backup validate database on databases in noarchivelog modeDatabaseHive
- PHP5.2.12/5.3.1safe_mode/open_basedirBypassPHP
- What Happens When You Open a Database (297)APPDatabase
- Seed Database (pdb$seed) - Read Write OR Read Only Mode in Oracle Database 12cDatabaseOracle
- InfluxDB 2.x Open Source Time Series DatabaseUXDatabase
- Summary For Forcing The Database Open With `_ALLOW_RESETLOGS_CORRUPTION`Database
- ORA-01102: cannot mount database in EXCLUSIVE modeDatabase
- ORA-01102 cannot mount database in EXCLUSIVE modeDatabase
- ORA-01679: database must be mounted EXCLUSIVE and not open to activateDatabase
- [Oracle] ORA-01102: cannot mount database in EXCLUSIVE modeOracleDatabase
- 12C-ORA-65086: cannot open/close the pluggable databaseDatabase
- 部署 11G 物理DataGuard時 ALTER DATABASE OPEN 報錯Database
- 關於ORA-01102: cannot mount database in EXCLUSIVE modeDatabase
- Oracle ORA-01102故障: cannot mount database in EXCLUSIVE modeOracleDatabase
- RAC 11.2.0.3 ORA-01102: cannot mount database in EXCLUSIVE mode”Database
- ORA-16433 The database must be opened in read write mode故障解決Database
- oracle9i(9204)dg(data guard)_ place the standby database in manual recovery modeOracleDatabase
- ORA-1113 signalled during: alter database open...Database
- 程式方式301
- 物理備庫open報錯ORA-10458: standby database requires recoveryDatabaseUI
- Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2DatabaseASM
- ORA-01102: cannot mount database in EXCLUSIVE mode 的解決辦法Database
- Oracle 11g RAC ORA-01102: cannot mount database in EXCLUSIVE modeOracleDatabase
- Oracle:ORA-01219:database not open:queries allowed on fixed tables/views onlyOracleDatabaseView
- Oracle 11g 報錯ORA-01102: cannot mount database in EXCLUSIVE modeOracleDatabase
- 啟動資料庫時 ORA-01102: cannot mount database in EXCLUSIVE mode資料庫Database
- CSS :read-only 選擇器CSS
- Window mode
- oracle ORA-01102: cannot mount database in EXCLUSIVE mode(無法起到獨佔模式)OracleDatabase模式
- Using silent mode to install GC 10.2.0.1 and upgrade GC to 10.2.0.5 by Using an Existing Database onGCDatabase
- RAC 例項不能啟動 ORA-1589 signalled during ALTER DATABASE OPENDatabase