第16/17/18次活动：2017-09-04（星期一晚上7:00-9:30）和2017-09-11（星期一晚上7:00-9:30）和2017-09-18

botang

实验编号12a/12c，开始时由于会删除所有之前的users备份。所以昨天晚上，所有用磁带机的都出现少了一半的全库备份。原因是双通道的磁带库，产生两个备份集，users必然包含在其中之一，所以被删掉。

应该这样做备份（注意：filesperset 1 ）：

1. [root@station90 ~]# su - oracle
   
2. [oracle@station90 ~]$ rman target /
   
3. 
   
4. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Sep 5 14:57:34 2017
   
5. 
   
6. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
7. 
   
8. connected to target database: ORCL (DBID=1343950367, not open)
   
9. 
   
10. RMAN> backup tag 'NEW3'  incremental level 0 database filesperset 1 ;
    
11. 
    
12. Starting backup at 2017-09-05:14:57:55
    
13. using target database control file instead of recovery catalog
    
14. allocated channel: ORA_SBT_TAPE_1
    
15. channel ORA_SBT_TAPE_1: SID=7 device type=SBT_TAPE
    
16. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
17. allocated channel: ORA_SBT_TAPE_2
    
18. channel ORA_SBT_TAPE_2: SID=130 device type=SBT_TAPE
    
19. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
20. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
    
21. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
22. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
    
23. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-05:14:58:06
    
24. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
    
25. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
26. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
    
27. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-05:14:58:07
    
28. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-05:14:58:42
    
29. piece handle=1asdn0ju_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
    
30. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:36
    
31. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
    
32. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
33. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
    
34. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-05:14:58:42
    
35. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-05:14:58:42
    
36. piece handle=1bsdn0ju_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
    
37. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
    
38. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
    
39. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
40. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
    
41. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-05:14:58:42
    
42. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-05:14:59:07
    
43. piece handle=1csdn0l2_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
    
44. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
45. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
    
46. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
47. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
    
48. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-05:14:59:07
    
49. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-05:14:59:07
    
50. piece handle=1dsdn0l2_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
    
51. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
    
52. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-05:14:59:32
    
53. piece handle=1esdn0lr_1_1 tag=NEW3 comment=API Version 2.0,MMS Version 10.4.0.4
    
54. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
55. Finished backup at 2017-09-05:14:59:32
    
56. 
    
57. RMAN-06497: WARNING: control file is not current, control file AUTOBACKUP skipped
    
58. 
    
59. RMAN>
    

复制代码