ALTER DATABASE DATAFILE OFFLINE
NOTE: The ALTER DATABASE DATAFILE OFFLINE DROP command, is not meant to allow you to remove a datafile. What the command really means is that you are offlining the datafile with the intention of dropping the tablespace. If you are running in archivelog mode, you can also use: ALTER DATABASE DATAFILE OFFLINE; instead of OFFLINE DROP. Once the datafile is offline, Oracle no longer attempts to access it, but it is still considered part of that tablespace. This datafile is marked only as offline in the controlfile and there is no SCN comparison done between the controlfile and the datafile during startup (This also allows you to startup a database with a non-critical datafile missing). The entry for that datafile is not deleted from the controlfile to give us the opportunity to recover that datafile.[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9907339/viewspace-1037875/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- alter database datafile offline and alter database tablespace ...offlineDatabase
- alter database datafile 4 offline drop;Database
- alter database datafile offline drop 與 alter tablespace drop datafile 區別Database
- alter database datafile .... offline drop的問題Database
- alter database datafile offline drop相關問題Database
- alter database create datafileDatabase
- alter database create datafile '' as ''Database
- alter database offline 與 alter database offline drop效果比對Database
- datafile offline 與alter tablespace offline 的區別
- ALTER DATABASE 與 ALTER TABLESPACE OFFLINE的區別Database
- alter database ... create datafile的原理及用途Database
- 恢復一則 alter database create datafile '' as ''Database
- Alter database datafile resize ORA-03297 原因解析Database
- UNRECOVERABLE DATAFILE clause in the ALTER DATABASE CLEAR LOGFILE statementDatabase
- [20111227]Alter database datafile offline drop後的恢復.txtDatabase
- alter database drop datafile 與 drop tablespace file 的區別Database
- tablespace offline與datafile offline 區別
- 在alter tablespace_datafile begin backup_offline_oracle block之fileq和ckptq變化OracleBloC
- alter system dump datafile headerHeader
- tablespace offline 和datafile offline的區別
- alter database in OracleDatabaseOracle
- oracle裡tablespace offline和datafile offline的區別Oracle
- Renaming a Datafile in the Primary DatabaseDatabase
- alter database和alter system和alter session的區別DatabaseSession
- alter database open resetlogs;Database
- alter database disable thread 2Databasethread
- ALTER DATABASE RESETLOGS 的作用Database
- DATA GUARD 中alter database 命令Database
- 利用offline datafile檔案方式遷移資料
- 忍不住問下alter system 和alter database的區別Database
- rman restore database(spfile,controlfile, datafile)RESTDatabase
- Oracle DBA命令參考——alter databaseOracleDatabase
- 重建控制檔案與 datafile offline,tablespace read only
- ALTER DATABASE CLEAR UNARCHIVED LOGFILE的使用DatabaseHive
- How to release space from database( in other words: resize datafile ) (zt)Database
- How to release space from database( in other words: resize datafile ) 【zt】Database
- VMS: ALTER TABLESPACE/DATABASE TO RENAME FILES on VMS [ID 9560.1]Database
- Display Storage Map for Database | Tablespace | Datafile Storage_1377458.1Database