亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標(biāo)題: 關(guān)于 oracle doc中用戶管理的備份 一段的不解 [打印本頁]
作者: wuxiaobo_2009    時(shí)間: 2014-10-22 18:11
標(biāo)題: 關(guān)于 oracle doc中用戶管理的備份 一段的不解
http://docs.oracle.com/cd/E11882 ... backup.htm#BRADV199
chapter 28.
為什么每次最后 oracle 都要加這句話：


  3. Take the tablespace offline using normal priority if possible, because it guarantees that you can subsequently bring the tablespace online without having to recover it. For example:

  5. SQL> ALTER TABLESPACE users OFFLINE NORMAL;

  7. Back up the offline data files. For example:

  9. % cp /oracle/oradata/trgt/users01.dbf /d2/users01_'date "+%m_%d_%y"'.dbf

  11. Bring the tablespace online. For example:

  13. ALTER TABLESPACE users ONLINE;

  15. Note:
  16. If you took the tablespace offline using temporary or immediate priority, then you cannot bring the tablespace online unless you perform tablespace recovery.

  18. Archive the unarchived redo logs so that the redo required to recover the tablespace backup is archived. For example, enter:

  20. ALTER SYSTEM ARCHIVE LOG CURRENT;
復(fù)制代碼
ALTER SYSTEM ARCHIVE LOG CURRENT;   why 進(jìn)行這個(gè)操作呢？
作者: jackson198574    時(shí)間: 2014-10-23 08:41
原文看不到呢，不過從鏈接上看樓主應(yīng)該是有備份的問題。這個(gè)語句是歸檔重做文件，寫在備份里目的是保證最新的操作已經(jīng)刷到了歸檔里，保持備份盡可能是最新的狀態(tài)。10以后好像會(huì)在備份發(fā)起的時(shí)候自動(dòng)歸檔重做日志。
作者: dingning239    時(shí)間: 2014-10-28 20:44
將當(dāng)前操作歸檔到歸檔日志中



歡迎光臨 Chinaunix (http://www.72891.cn/) Powered by Discuz! X3.2