ALTER DATABASE RESETLOGS 的作用
ALTER DATABASE OPEN RESETLOG作用:
。Archives the current online redo logs (if they are accessible) and then erases the contents of the online redo logs and resets the log sequence number to 1. For example, if the current online redo logs are sequence 1000 and 1001 when you open RESETLOGS, then the database archives logs 1000 and 1001 and then resets the online logs to sequence 1 and 2.
2。Creates the online redo log files if they do not currently exist.
3。Reinitializes the control file metadata about online redo logs and redo threads.
4。Updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/3907/viewspace-1008553/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- alter database open resetlogs;Database
- alter database和alter system和alter session的區別DatabaseSession
- alter database in OracleDatabaseOracle
- alter database datafile offline and alter database tablespace ...offlineDatabase
- alter database create datafileDatabase
- alter database create datafile '' as ''Database
- ALTER DATABASE 與 ALTER TABLESPACE OFFLINE的區別Database
- 忍不住問下alter system 和alter database的區別Database
- 執行alter database open resetlogs提示ORA-00392和ORA-00312錯誤Database
- alter database offline 與 alter database offline drop效果比對Database
- ALTER DATABASE CLEAR UNARCHIVED LOGFILE的使用DatabaseHive
- alter database ... create datafile的原理及用途Database
- alter database disable thread 2Databasethread
- DATA GUARD 中alter database 命令Database
- ALTER DATABASE DATAFILE OFFLINEDatabase
- Oracle DBA命令參考——alter databaseOracleDatabase
- alter database datafile .... offline drop的問題Database
- alter database backup controlfile to trace的問題Database
- 在alter database mount時的一點收穫Database
- alter database backup controlfile to trace的含義Database
- Summary For Forcing The Database Open With `_ALLOW_RESETLOGS_CORRUPTION`Database
- alter database datafile 4 offline drop;Database
- 恢復一則 alter database create datafile '' as ''Database
- alter database datafile offline drop 與 alter tablespace drop datafile 區別Database
- alter index unusable無法起作用的情況Index
- alter database drop datafile 與 drop tablespace file 的區別Database
- Alter database datafile resize ORA-03297 原因解析Database
- UNRECOVERABLE DATAFILE clause in the ALTER DATABASE CLEAR LOGFILE statementDatabase
- VMS: ALTER TABLESPACE/DATABASE TO RENAME FILES on VMS [ID 9560.1]Database
- alter index unusable 無法起作用的情況 ztIndex
- 重建控制檔案--alter database backup controlfile to traceDatabase
- alter database datafile offline drop相關問題Database
- ORA-279 signalled during: alter database recover logfileDatabase
- 425alter database force logging修改那裡Database
- 部署 11G 物理DataGuard時 ALTER DATABASE OPEN 報錯Database
- Oracle11gr2新增ALTER DATABASE LINK語法OracleDatabase
- Oracle OCP 1Z0-053 Q98(Flashback Database&Resetlogs)OracleDatabase
- ORA-1113 signalled during: alter database open...Database