關于 oracle doc中用戶管理的備份 一段的不解

wuxiaobo_2009

http://docs.oracle.com/cd/E11882 ... backup.htm#BRADV199
chapter 28.
為什么每次最后 oracle 都要加這句話：

1. 
   
2. 
   
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:
   
4. 
   
5. SQL> ALTER TABLESPACE users OFFLINE NORMAL;
   
6. 
   
7. Back up the offline data files. For example:
   
8. 
   
9. % cp /oracle/oradata/trgt/users01.dbf /d2/users01_'date "+%m_%d_%y"'.dbf
   
10. 
    
11. Bring the tablespace online. For example:
    
12. 
    
13. ALTER TABLESPACE users ONLINE;
    
14. 
    
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.
    
17. 
    
18. Archive the unarchived redo logs so that the redo required to recover the tablespace backup is archived. For example, enter:
    
19. 
    
20. ALTER SYSTEM ARCHIVE LOG CURRENT;
    

復制代碼

ALTER SYSTEM ARCHIVE LOG CURRENT;   why 進行這個操作呢？

jackson198574

原文看不到呢，不過從鏈接上看樓主應該是有備份的問題。這個語句是歸檔重做文件，寫在備份里目的是保證最新的操作已經(jīng)刷到了歸檔里，保持備份盡可能是最新的狀態(tài)。10以后好像會在備份發(fā)起的時候自動歸檔重做日志。

dingning239

將當前操作歸檔到歸檔日志中