rman备份

aaaaaaaa2000

1. RMAN> list backup of archivelog all;
   
2. List of Backup Sets
   
3. ===================
   
4. BS Key  Size       Device Type Elapsed Time Completion Time
   
5. ------- ---------- ----------- ------------ ---------------
   
6. 2334    386.11M    DISK        00:00:47     11-MAY-12      
   
7.         BP Key: 2334   Status: AVAILABLE  Compressed: NO  Tag: TAG20120511T041619
   
8.         Piece Name: /disk3/backups/arch_MAILDATA_20120511_95namd8r.back
   
9.   List of Archived Logs in backup set 2334
   
10.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    
11.   ---- ------- ---------- --------- ---------- ---------
    
12.   1    1369    1105579974 10-MAY-12 1105583524 10-MAY-12
    
13.   1    1370    1105583524 10-MAY-12 1106127437 11-MAY-12
    
14.   1    1371    1106127437 11-MAY-12 1106127462 11-MAY-12
    
15. BS Key  Size       Device Type Elapsed Time Completion Time
    
16. ------- ---------- ----------- ------------ ---------------
    
17. 2336    556.20M    DISK        00:00:00     09-MAY-12      
    
18.         BP Key: 2336   Status: AVAILABLE  Compressed: NO  Tag: TAG20120509T043723
    
19.         Piece Name: /disk7/backups/arch_MAILDATA_20120509_8onah5o3.back
    
20.   List of Archived Logs in backup set 2336
    
21.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    
22.   ---- ------- ---------- --------- ---------- ---------
    
23.   1    1356    1101334855 08-MAY-12 1102171868 09-MAY-12
    
24.   1    1357    1102171868 09-MAY-12 1102171881 09-MAY-12
    
25. BS Key  Size       Device Type Elapsed Time Completion Time
    
26. ------- ---------- ----------- ------------ ---------------
    
27. 2337    629.99M    DISK        00:00:00     10-MAY-12      
    
28.         BP Key: 2337   Status: AVAILABLE  Compressed: NO  Tag: TAG20120510T040239
    
29.         Piece Name: /disk7/backups/arch_MAILDATA_20120510_8unajo2v.back
    
30.   List of Archived Logs in backup set 2337
    
31.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    
32.   ---- ------- ---------- --------- ---------- ---------
    
33.   1    1360    1103314063 09-MAY-12 1104256465 10-MAY-12
    
34.   1    1361    1104256465 10-MAY-12 1104256493 10-MAY-12
    
35. RMAN的备份脚本
    
36. rman target / <<  END
    
37. run{
    
38. allocate channel ch1 type disk;
    
39. allocate channel ch2 type disk;
    
40. backup database format '/disk3/backups/full_%d_%T_%u.back';
    
41. sql 'alter system archive log current';
    
42. backup archivelog all format '/disk3/backups/arch_%d_%T_%u.back' delete all input;
    
43. release channel ch1;
    
44. release channel ch2;
    
45. }
    
46. crosscheck backup;
    
47. delete noprompt obsolete;
    
48. exit
    
49. END
    
50. 
    
51. cp /disk3/backups/*`date +%Y%m%d`* /disk7/backups/
    
52. rm -f /disk7/backups/*_DATA_`date "+%Y%m%d" -d'-11 days'`_*.back

复制代码

现在的问题就是为什么连续3天的archivelog的备份是不连续的那？我现在想单独restore序列为1358的archivelog就不行，改如何restore出1358那？多谢啊

Maclean Liu(刘相兵

action plan:
执行以下命令并给出输出

list backup of archivelog sequence 1358;

list  archivelog sequence 1358;

restore archivelog sequence 1358

aaaaaaaa2000

实在抱歉，因为每天会过期导致现在查不到了，先结贴，多谢刘总的解答