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提示ORA-00392和ORA-00312錯誤Database
- alter database disable thread 2Databasethread
- ORA-279 signalled during: alter database recover logfileDatabase
- Oracle設定日誌引數-ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;OracleDatabase
- “alter database switchover to xx“過程不當導致的primary-primary 雙主問題Database
- [重慶思莊每日技術分享]-ORA-1142 signalled during: ALTER DATABASE END BACKUPDatabase
- mysql的ALTER TABLE命令MySql
- Oracle資料庫恢復之resetlogsOracle資料庫
- Controlfile 重建控制檔案 noresetlogs, resetlogs..
- MySQL ALTER命令MySql
- SQL__ALTERSQL
- mysql加快alter操作MySql
- database的connectDatabase
- 關於隱藏引數：_no_recovery_through_resetlogs
- mysql alter modify 和 change的區別MySql
- ALTER TABLE修改列的不同方法
- alter table set unused column
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- 2.7.6.2.1 ALTER SYSTEM SET語句中的SCOPE子句
- alter table drop unused columns checkpoint
- alter table move與shrink space
- ALTER SYSTEM FLUSH BUFFER_POOL
- alter table nologging /*+APPEND PARALLEL(n)*/APPParallel
- Error querying database. XXXXXXXXXXXXX, No database selected。ErrorDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- alter system set event和set events的區別
- 開心檔之MySQL ALTER命令MySql
- 如何獲取 alter 裡面的字串？字串
- Database TimeoutDatabase
- database no shardingDatabase
- Database OverallDatabase
- alter system set ... scope=... 中的scope的含義是什麼？
- Oracle為什麼使用備份的控制檔案恢復後一定要resetlogsOracle
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- MySQL alter 新增列對dml影響MySql
- MySQL 資料庫 ALTER命令講解MySql資料庫
- MySQL-ALTER TABLE命令學習[20180503]MySql
- alter tablespace ts_name autoextend_clause