exp能在什麼級別保證備份資料的一致性呢?
如果exp能保證備份資料的一致性,那麼能在什麼級別保證呢?是表級別、使用者級別,還是整個db級別?
對於資料庫而言
exp/imp是“拍照留念”
archivelog mode的物理backup是“錄影記錄”。
拍照只能是單點的,而“錄影記錄”允許你看到錄影期間的任何一點-----引自網路
1) exp 是包含表級別的資料完整性;也即匯出那一刻的表的快照;也就說明肯定會用undo的資料
1)可以用CONSISTENT該選項保證交叉表的一致性
3)可以用FLASHBACK_SCN保證exp這批資料的一致性
CONSISTENT=y時,確實會出現:
A "snapshot too old" error occurs when rollback space is used up
================================
CONSISTENT
Default: N
Specifies whether or not Export uses the SET TRANSACTION READ ONLY statement to ensure that the data seen by Export is consistent to a single point in time and does not change during the execution of the export command. You should specify CONSISTENT=Y when you anticipate that other applications will be updating the target data after an export has started.
If you specify CONSISTENT=N (the default), each table is usually exported in a single transaction. However, if a table contains nested tables, the outer table and each inner table are exported as separate transactions. If a table is partitioned, each partition is exported as a separate transaction.
Therefore, if nested tables and partitioned tables are being updated by other applications, the data that is exported could be inconsistent. To minimize this possibility, export those tables at a time when updates are not being done.
The following chart shows a sequence of events by two users: USER1 exports partitions in a table and USER2 updates data in that table.
Time Sequence USER1 USER2
1
Begins export of TAB:P1
2
Updates TAB:P2
Updates TAB:P1
Commit transaction
3
Ends export of TAB:P1
4
Exports TAB:P2
If the export uses CONSISTENT=Y, none of the updates by USER2 are written to the export file.
If the export uses CONSISTENT=N, the updates to TAB:P1 are not written to the export file. However, the updates to TAB:P2 are written to the export file because the update transaction is committed before the export of TAB:P2 begins. As a result, USER2's transaction is only partially recorded in the export file, making it inconsistent.
If you use CONSISTENT=Y and the volume of updates is large, the rollback segment will be large. In addition, the export of each table will be slower because the rollback segment must be scanned for uncommitted transactions.
Restrictions
You cannot specify CONSISTENT=Y with an incremental export.
CONSISTENT=Y is unsupported for exports performed using AS SYSDBA.
Keep in mind the following points about using CONSISTENT=Y:
To minimize the time and space required for such exports, you should export tables that need to remain consistent separately from those that do not.
For example, export the EMP and DEPT tables together in a consistent export, and then export the remainder of the database in a second pass.
A "snapshot too old" error occurs when rollback space is used up, and space taken up by committed transactions is reused for new transactions. Reusing space in the rollback segment allows database integrity to be preserved with minimum space requirements, but it imposes a limit on the amount of time that a read-consistent image can be preserved.
If a committed transaction has been overwritten and the information is needed for a read-consistent view of the database, a "snapshot too old" error results.
To avoid this error, you should minimize the time taken by a read-consistent export. (Do this by restricting the number of objects exported and, if possible, by reducing the database transaction rate.) Also, make the rollback segment as large as possible.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-665744/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 什麼是備份資料庫?什麼是資料庫一致性備份和非一致性備份?資料庫
- exp備份和rman備份的區別
- oracle資料庫備份之exp增量備份Oracle資料庫
- 0級備份和全備份的本質區別是什麼 ?
- MySQL是怎麼保證資料一致性的MySql
- rman的level 0 1 2級備份有什麼區別?
- 為什麼資料備份那麼重要?
- 什麼是等級保護?一級等保和三級等保有什麼區別?
- 什麼是等保三級?等保三級的認證流程有哪些?
- 資料庫一致性備份資料庫
- 使用GnuPG保護你的備份資料
- 容災備份技術有效保證受損資料恢復資料恢復
- exp/imp備份與還原oracle資料庫Oracle資料庫
- 使用NineData實現企業級資料庫備份, 資料備份告別“拆盲盒” ?資料庫
- 網路安全中等級保護備案證明辦理流程是什麼?
- 資料庫非一致性備份資料庫
- EXP的備份指令碼指令碼
- Spark CommitCoordinator 保證資料一致性SparkMIT
- 冗餘資料一致性,到底如何保證?
- 如何保證MySQL和Redis資料一致性?MySqlRedis
- 資料庫和快取的一致性如何保證資料庫快取
- 如何保證快取和資料庫的一致性?快取資料庫
- 為什麼要備份資料? 如何做?
- 什麼是等保?安全等保二級和三級的區別是什麼?
- load data語句如何保證主備複製資料一致性(一)
- windows下oracle資料庫的exp自動備份指令碼WindowsOracle資料庫指令碼
- mysqldump備份時如何保持資料的一致性MySql
- 搭建Oracle的exp備份機Oracle
- 如何保證mongodb和資料庫雙寫資料一致性?MongoDB資料庫
- Oracle資料庫備份與恢復之匯出/匯入(EXP/IMP)、熱備份和冷備份Oracle資料庫
- 0級備份和全備份的本質區別
- RMAN 全庫備份和 0級備份的區別
- windowns系統下oracle資料庫exp自動備份Oracle資料庫
- 【EXP】備份複雜關聯查詢後的T表資料
- linux備份資料夾的命令是什麼?如何使用?Linux
- Linux如何備份資料夾?常用的命令是什麼?Linux
- 為什麼延遲刪除可以保證MYSQL 與redis的一致性?MySqlRedis
- Zookeeper 如何保證分散式系統資料一致性分散式