[ADMIN]Princeple of Online backup
To perform online backup we should put the tablespace in begin backup mode, copy the datafiles and then put the tablespace to end backup.
Since the size of a db block is usually of 8k bytes while the size of a os block is usually of 512 bytes, you can't guarantee that all the os blocks within a db block are at the same SCN during copying. The result is called a fractured block.
The 'alter tablespace ... begin backup' has two effects:
1. The first time a block is changed in a datafile that is in hot backup mode, the entire block is written to the redo log files. So extra redo may be generated during online backup.
2. The command prevent the SCN in datafile header from changing, so that logs are applied in recovery from backup start time.
Reference: Note 469950.1 What Happens When A Tablespace/Database Is Kept In Begin Backup Mode
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8558093/viewspace-1020490/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- db2 online backup 設定DB2
- WARNING: datafile #1 was not in online backup mode 出現的原因
- full backup 與 level 0 incremental backupREM
- create index online 與rebuild index onlineIndexRebuild
- create index online 與rebuild index onlineIndexRebuild
- Veritas Backup
- Dcat Admin 教程 - 如何從 Laravel admin 遷移到 dcat admin?Laravel
- rebuild index online和create index online及沒有online的區別RebuildIndex
- Online Redefinition
- css/js online online code editor/formator/debugerCSSJSORM
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- backup site collection
- Oracle Secure BackupOracle
- Cold backup script
- MySQL online ddl 工具之pt-online-schema-changeMySql
- MySQL Online DDL--pt-online-change-schema測試MySql
- 【MySQL】online ddl 工具之pt-online-schema-changeMySql
- create index .. onlineIndex
- Lyrics Server OnLiNe!Server
- create index onlineIndex
- oracle online DocOracle
- Index Online RebuildIndexRebuild
- Create Index ...ONLINEIndex
- MySQL ONLINE DDL 和PT-ONLINE-SCHEMA-CHANGE對比MySql
- 理解備份集backup set與備份片backup piece
- oracle full database backupOracleDatabase
- SQL Server Backup & RestoreSQLServerREST
- TFS Express backup and restoreExpressREST
- backup and restore tipsREST
- oracle cold backup scriptsOracle
- rman backup script(引用)
- Rman backup standby databaseDatabase
- Cold Database backup scriptDatabase
- Oracle Backup and Recovery FAQOracle
- DP rman backup scripts
- RMAN - backup archivelog all 與 backup database plus archivelog 區別HiveDatabase
- Office Online Server概述Server
- CREATE INDEX ......ONLINE分析Index