课程第27次（2018-04-09星期一）

botang

1. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
   
2. 
   
3. new RMAN configuration parameters:
   
4. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
   
5. new RMAN configuration parameters are successfully stored
   
6. 
   
7. RMAN> show all;
   
8. 
   
9. RMAN configuration parameters for database with db_unique_name ORCL are:
   
10. CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
    
11. CONFIGURE BACKUP OPTIMIZATION OFF; # default
    
12. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
    
13. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
    
14. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
    
15. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    
16. CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
    
17. CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
    
18. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
19. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
20. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
21. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
22. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    
23. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    
24. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    
25. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
    
26. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    
27. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
    
28. 
    
29. RMAN> backup datafile 4;
    
30. 
    
31. Starting backup at 09-APR-18
    
32. RMAN-00571: ===========================================================
    
33. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
34. RMAN-00571: ===========================================================
    
35. RMAN-03002: failure of backup command at 04/09/2018 20:08:10
    
36. ORA-19554: error allocating device, device type: SBT_TAPE, device name:
    
37. ORA-27211: Failed to load Media Management Library
    
38. Additional information: 2
    
39. 
    
40. RMAN> exit
    

复制代码

1. [root@station20 local]# cd /usr/local/oracle/backup
   
2. [root@station20 backup]# ls
   
3. [root@station20 backup]# /stage/osb_10.4.0.4.1_linux.x64_release/setup
   
4. Welcome to Oracle's setup program for Oracle Secure Backup.  This
   
5. program loads Oracle Secure Backup software from the CD-ROM to a
   
6. filesystem directory of your choosing.
   
7. 
   
8. This CD-ROM contains Oracle Secure Backup version 4.0.4.1_linux.x64.
   
9. 
   
10. Please wait a moment while I learn about this host... done.
    
11. 
    
12. -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -
    
13.     1. linux86_64
    
14.        administrative server, media server, client
    
15. 
    
16. -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -
    
17. Loading Oracle Secure Backup installation tools... done.
    
18. Loading linux86_64 administrative server, media server, client... done.
    
19. 
    
20. -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -
    
21. Loading of Oracle Secure Backup software from CD-ROM is complete.
    
22. You may unmount and remove the CD-ROM.
    
23. 
    
24. 
    
25. Would you like to continue Oracle Secure Backup installation with
    
26. 'installob' now?  (The Oracle Secure Backup Installation Guide
    
27. contains complete information about installob.)
    
28. Please answer 'yes' or 'no' [yes]: yes
    
29. 
    
30. -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -
    
31. 
    
32. Welcome to installob, Oracle Secure Backup's installation program.
    
33. 
    
34. For most questions, a default answer appears enclosed in square brackets.
    
35. Press Enter to select this answer.
    
36. 
    
37. Please wait a few seconds while I learn about this machine... done.
    
38. 
    
39. Have you already reviewed and customized install/obparameters for your
    
40. Oracle Secure Backup installation [yes]? yes
    
41. 
    
42. -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -
    
43. 
    
44. Oracle Secure Backup is not yet installed on this machine.
    
45. 
    
46. Oracle Secure Backup's Web server has been loaded, but is not yet configured.
    
47. 
    
48. Choose from one of the following options. The option you choose defines
    
49. the software components to be installed.
    
50. 
    
51. Configuration of this host is required after installation completes.
    
52. 
    
53. You can install the software on this host in one of the following ways:
    
54.     (a) administrative server, media server and client
    
55. 
    
56.     (b) media server and client
    
57. 
    
58.     (c) client
    
59. 
    
60. If you are not sure which option to choose, please refer to the Oracle
    
61. Secure Backup Installation Guide. (a,b or c) [a]? a
    
62. 
    
63. Beginning the installation.  This will take just a minute and will produce
    
64. several lines of informational output.
    
65. 
    
66. Installing Oracle Secure Backup on station20 (Linux version 2.6.32-696.el6.x86_64)
    
67. 
    
68. You must now enter a password for the Oracle Secure Backup encryption
    
69. key store.  Oracle suggests you choose a password of at least 8
    
70. characters in length, containing a mixture of alphabetic and numeric
    
71. characters.
    
72. 
    
73. Please enter the key store password:
    
74. Re-type password for verification:  
    
75. 
    
76. You must now enter a password for the Oracle Secure Backup 'admin' user.
    
77. Oracle suggests you choose a password of at least 8 characters in length,
    
78. containing a mixture of alphabetic and numeric characters.
    
79. 
    
80. Please enter the admin password:
    
81. Re-type password for verification:  
    
82. 
    
83. You should now enter an email address for the Oracle Secure Backup 'admin'
    
84. user. Oracle Secure Backup uses this email address to send job summary
    
85. reports and to notify the user when a job requires input. If you leave this
    
86. blank, you can set it later using the obtool's 'chuser' command.
    
87. 
    
88. Please enter the admin email address:
    
89. 
    
90. 
    
91.     generating links for admin installation with Web server
    
92.     updating /etc/ld.so.conf
    
93.     checking Oracle Secure Backup's configuration file (/etc/obconfig)
    
94.     setting Oracle Secure Backup directory to /usr/local/oracle/backup in /etc/obconfig
    
95.     setting local database directory to /usr/etc/ob in /etc/obconfig
    
96.     setting temp directory to /usr/tmp in /etc/obconfig
    
97.     setting administrative directory to /usr/local/oracle/backup/admin in /etc/obconfig
    
98.     setting version to 10.4.0.4.0 in /etc/obconfig
    
99.     protecting the Oracle Secure Backup directory
    
100.     creating /etc/rc.d/init.d/observiced
     
101.     activating observiced via chkconfig
     
102.     initializing the administrative domain
     
103. 
     
104. ****************************** N O T E ******************************
     
105. On Linux systems Oracle recommends that you answer no to the next two
     
106. questions. The preferred mode of operation on Linux systems is to use
     
107. the /dev/sg devices for attach points as described in the 'ReadMe'
     
108. and in the 'Installation and Configuration Guide'.
     
109. 
     
110. 
     
111. Is station20 connected to any tape libraries that you'd like to use with
     
112. Oracle Secure Backup [no]?
     
113. 
     
114. Is station20 connected to any tape drives that you'd like to use with
     
115. Oracle Secure Backup [no]?
     
116. 
     
117. Installation summary:
     
118. 
     
119.     Installation  Host                OS          Driver     OS Move    Reboot
     
120.         Mode      Name                Name      Installed?  Required?  Required?
     
121. 
     
122.     admin         station20           Linux     no          no         no   
     
123. 
     
124. Oracle Secure Backup is now ready for your use.  
     

复制代码

1. [root@station20 stage]# obtool
   
2. ob> lsdev
   
3. ob> lshost
   
4. station20        admin,mediaserver,client          (via OB)   in service
   
5. ob> mkdev -t library -o -a station20:/dev/sg9 lib01
   
6. ob> mkdev -t tape -o -a station20:/dev/sg3 -l lib01 -d 3 tape03
   
7. ob> mkdev -t tape -o -a station20:/dev/sg4 -l lib01 -d 4 tape04
   
8. ob> inventory -L lib01
   
9. ob>
   

复制代码

1. ob> lsvol -L lib01 -l
   
2. Inventory of library lib01:
   
3.     in    1:             barcode E01001L4, oid 100
   
4.     in    2:             barcode E01002L4, oid 101
   
5.     in    3:             barcode E01003L4, oid 102
   
6.     in    4:             barcode E01004L4, oid 103
   
7.     in    5:             barcode E01005L4, oid 104
   
8.     in    6:             barcode E01006L4, oid 105
   
9.     in    7:             barcode E01007L4, oid 106
   
10.     in    8:             barcode E01008L4, oid 107
    
11.     in    9:             barcode E01009L4, oid 108
    
12.     in    10:            barcode E01010L4, oid 109
    
13.     in    11:            barcode E01011L4, oid 110
    
14.     in    12:            barcode E01012L4, oid 111
    
15.     in    13:            barcode E01013L4, oid 112
    
16.     in    14:            barcode E01014L4, oid 113
    
17.     in    15:            barcode E01015L4, oid 114
    
18.     in    16:            barcode E01016L4, oid 115
    
19.     in    17:            barcode E01017L4, oid 116
    
20.     in    18:            barcode E01018L4, oid 117
    
21.     in    19:            barcode E01019L4, oid 118
    
22.     in    20:            barcode E01020L4, oid 119
    
23.     in    21:            vacant
    
24.     in    22:            barcode CLN101L4, oid 120
    
25.     in    23:            barcode CLN102L5, oid 121
    
26.     in    24:            vacant
    
27.     in    25:            vacant
    
28.     in    26:            vacant
    
29.     in    27:            vacant
    
30.     in    28:            vacant
    
31.     in    29:            vacant
    
32.     in    30:            barcode F01030L5, oid 122
    
33.     in    31:            barcode F01031L5, oid 123
    
34.     in    32:            barcode F01032L5, oid 124
    
35.     in    33:            barcode F01033L5, oid 125
    
36.     in    34:            barcode F01034L5, oid 126
    
37.     in    35:            barcode F01035L5, oid 127
    
38.     in    36:            barcode F01036L5, oid 128
    
39.     in    37:            barcode F01037L5, oid 129
    
40.     in    38:            barcode F01038L5, oid 130
    
41.     in    39:            barcode F01039L5, oid 131
    
42.     in    iee1:          vacant
    
43.     in    iee2:          vacant
    
44.     in    iee3:          vacant
    
45.     in    iee4:          vacant
    
46.     in    dte1:          vacant
    
47.     in    dte2:          vacant
    
48.     in    dte3:          vacant
    
49.     in    dte4:          vacant
    
50. ob> loadvol -D tape04 -m write 2
    
51. ob> lsvol -L lib01 -l
    
52. Inventory of library lib01:
    
53.     in    1:             barcode E01001L4, oid 100
    
54.     in    2:             vacant
    
55.     in    3:             barcode E01003L4, oid 102
    
56.     in    4:             barcode E01004L4, oid 103
    
57.     in    5:             barcode E01005L4, oid 104
    
58.     in    6:             barcode E01006L4, oid 105
    
59.     in    7:             barcode E01007L4, oid 106
    
60.     in    8:             barcode E01008L4, oid 107
    
61.     in    9:             barcode E01009L4, oid 108
    
62.     in    10:            barcode E01010L4, oid 109
    
63.     in    11:            barcode E01011L4, oid 110
    
64.     in    12:            barcode E01012L4, oid 111
    
65.     in    13:            barcode E01013L4, oid 112
    
66.     in    14:            barcode E01014L4, oid 113
    
67.     in    15:            barcode E01015L4, oid 114
    
68.     in    16:            barcode E01016L4, oid 115
    
69.     in    17:            barcode E01017L4, oid 116
    
70.     in    18:            barcode E01018L4, oid 117
    
71.     in    19:            barcode E01019L4, oid 118
    
72.     in    20:            barcode E01020L4, oid 119
    
73.     in    21:            vacant
    
74.     in    22:            barcode CLN101L4, oid 120
    
75.     in    23:            barcode CLN102L5, oid 121
    
76.     in    24:            vacant
    
77.     in    25:            vacant
    
78.     in    26:            vacant
    
79.     in    27:            vacant
    
80.     in    28:            vacant
    
81.     in    29:            vacant
    
82.     in    30:            barcode F01030L5, oid 122
    
83.     in    31:            barcode F01031L5, oid 123
    
84.     in    32:            barcode F01032L5, oid 124
    
85.     in    33:            barcode F01033L5, oid 125
    
86.     in    34:            barcode F01034L5, oid 126
    
87.     in    35:            barcode F01035L5, oid 127
    
88.     in    36:            barcode F01036L5, oid 128
    
89.     in    37:            barcode F01037L5, oid 129
    
90.     in    38:            barcode F01038L5, oid 130
    
91.     in    39:            barcode F01039L5, oid 131
    
92.     in    iee1:          vacant
    
93.     in    iee2:          vacant
    
94.     in    iee3:          vacant
    
95.     in    iee4:          vacant
    
96.     in    dte1:          vacant
    
97.     in    dte2:          vacant
    
98.     in    dte3:          vacant
    
99.     in    dte4:          unlabeled, barcode E01002L4, oid 132, lastse 2
    
100. ob>
     

复制代码

叶俊海

老师 改成磁带机后备份报错 不知道错哪了

1. RMAN> backup datafile 5;
   
2. 
   
3. Starting backup at 10-APR-18
   
4. using target database control file instead of recovery catalog
   
5. allocated channel: ORA_SBT_TAPE_1
   
6. channel ORA_SBT_TAPE_1: SID=246 device type=SBT_TAPE
   
7. channel ORA_SBT_TAPE_1: Oracle Secure Backup
   
8. channel ORA_SBT_TAPE_1: starting full datafile backup set
   
9. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
   
10. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.972323303
    
11. channel ORA_SBT_TAPE_1: starting piece 1 at 10-APR-18
    
12. RMAN-00571: ===========================================================
    
13. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
14. RMAN-00571: ===========================================================
    
15. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 04/10/2018 15:47:57
    
16. ORA-19506: failed to create sequential file, name="0nt00epc_1_1", parms=""
    
17. ORA-27028: skgfqcre: sbtbackup returned error
    
18. ORA-19511: Error received from media manager layer, error text:
    
19.    sbt__rpc_cat_query: Query for piece 0nt00epc_1_1 failed.
    
20. (Oracle Secure Backup error: 'no preauth config found for OS user (OB tools) oracle').
    
21. 
    
22. RMAN>
    

复制代码

叶俊海

叶俊海 发表于 2018-4-10 15:51
老师 改成磁带机后备份报错 不知道错哪了

重启后可以了

吴家硕

老师，备份后一直卡在那了，不过看进程好像有在运行，不知道怎么回事

1. RMAN> backup database;
   
2. 
   
3. Starting backup at 11-APR-18
   
4. allocated channel: ORA_SBT_TAPE_1
   
5. channel ORA_SBT_TAPE_1: SID=460 device type=SBT_TAPE
   
6. channel ORA_SBT_TAPE_1: Oracle Secure Backup
   
7. allocated channel: ORA_SBT_TAPE_2
   
8. channel ORA_SBT_TAPE_2: SID=917 device type=SBT_TAPE
   
9. channel ORA_SBT_TAPE_2: Oracle Secure Backup
   
10. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
11. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
12. input datafile file number=00001 name=+DATA/orcl/datafile/system.259.972353071
    
13. input datafile file number=00005 name=+DATA/orcl/datafile/example.258.972353073
    
14. channel ORA_SBT_TAPE_1: starting piece 1 at 11-APR-18
    
15. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
16. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
17. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.265.972353073
    
18. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.257.972353073
    
19. input datafile file number=00004 name=+DATA/orcl/datafile/users.256.972353073
    
20. channel ORA_SBT_TAPE_2: starting piece 1 at 11-APR-18

复制代码

1. [root@station13 桌面]# obtool lsjob --all
   
2. Job ID           Sched time  Contents                       State
   
3. ---------------- ----------- ------------------------------ ---------------------------------------
   
4. oracle/2         none        database orcl (dbid=1497044535) processed; Oracle job(s) scheduled
   
5. oracle/2.1       none        datafile backup                running since 2018/04/11.04:48
   
6. oracle/2.2       none        datafile backup                running since 2018/04/11.04:48
   
7. oracle/2.3       none        datafile backup                pending resource availability
   
8. oracle/2.4       none        datafile backup                pending resource availability
   
9. [root@station13 桌面]#
   

复制代码

吴家硕

这是我磁带机的配置和rman的配置，麻烦老师解答下

1. [root@station13 桌面]# obtool lsvol -L lib01 -l
   
2. Inventory of library lib01:
   
3.     in    1:             vacant
   
4.     in    2:             vacant
   
5.     in    3:             volume RMAN-DEFAULT-000003, barcode E01003L4, oid 138, 510976 kb remaining, content manages reuse
   
6.     in    4:             volume RMAN-DEFAULT-000004, barcode E01004L4, oid 139, 510976 kb remaining, content manages reuse
   
7.     in    5:             volume RMAN-DEFAULT-000005, barcode E01005L4, oid 141, 510976 kb remaining, content manages reuse
   
8.     in    6:             volume RMAN-DEFAULT-000006, barcode E01006L4, oid 143, 510976 kb remaining, content manages reuse
   
9.     in    7:             volume RMAN-DEFAULT-000007, barcode E01007L4, oid 146, 510976 kb remaining, content manages reuse
   
10.     in    8:             volume RMAN-DEFAULT-000008, barcode E01008L4, oid 147, 510976 kb remaining, content manages reuse
    
11.     in    9:             volume RMAN-DEFAULT-000009, barcode E01009L4, oid 149, 510976 kb remaining, content manages reuse
    
12.     in    10:            vacant
    
13.     in    11:            vacant
    
14.     in    12:            barcode E01012L4, oid 111
    
15.     in    13:            barcode E01013L4, oid 112
    
16.     in    14:            barcode E01014L4, oid 113
    
17.     in    15:            barcode E01015L4, oid 114
    
18.     in    16:            barcode E01016L4, oid 115
    
19.     in    17:            barcode E01017L4, oid 116
    
20.     in    18:            barcode E01018L4, oid 117
    
21.     in    19:            barcode E01019L4, oid 118
    
22.     in    20:            barcode E01020L4, oid 119
    
23.     in    21:            vacant
    
24.     in    22:            barcode CLN101L4, oid 120
    
25.     in    23:            barcode CLN102L5, oid 121
    
26.     in    24:            vacant
    
27.     in    25:            vacant
    
28.     in    26:            vacant
    
29.     in    27:            vacant
    
30.     in    28:            vacant
    
31.     in    29:            vacant
    
32.     in    30:            barcode F01030L5, oid 122
    
33.     in    31:            barcode F01031L5, oid 123
    
34.     in    32:            barcode F01032L5, oid 124
    
35.     in    33:            barcode F01033L5, oid 125
    
36.     in    34:            barcode F01034L5, oid 126
    
37.     in    35:            barcode F01035L5, oid 127
    
38.     in    36:            barcode F01036L5, oid 128
    
39.     in    37:            barcode F01037L5, oid 129
    
40.     in    38:            barcode F01038L5, oid 130
    
41.     in    39:            barcode F01039L5, oid 131
    
42.     in    iee1:          vacant
    
43.     in    iee2:          vacant
    
44.     in    iee3:          vacant
    
45.     in    iee4:          vacant
    
46.     in    dte1:          vacant
    
47.     in    dte2:          vacant
    
48.     in    dte3:          volume RMAN-DEFAULT-000011, barcode E01011L4, oid 153, content manages reuse, lastse 11
    
49.     in    dte4:          volume RMAN-DEFAULT-000010, barcode E01010L4, oid 151, content manages reuse, lastse 10
    
50. [root@station13 桌面]# obtool lsdev
    
51. drive               help             in service         
    
52. library             lib01            in service         
    
53.   drive 3           tape03           in service         
    
54.   drive 4           tape04           in service         
    
55. [root@station13 桌面]#
    

复制代码

1. [oracle@station13 ~]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 11 05:23:19 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1497044535, not open)
   
8. 
   
9. RMAN> show all;
   
10. 
    
11. using target database control file instead of recovery catalog
    
12. RMAN configuration parameters for database with db_unique_name ORCL are:
    
13. CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
    
14. CONFIGURE BACKUP OPTIMIZATION ON;
    
15. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
    
16. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
    
17. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    
18. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
    
19. CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
    
20. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
    
21. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 2;
    
22. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
23. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
    
24. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
25. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    
26. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    
27. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    
28. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
    
29. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    
30. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
    
31. 
    
32. RMAN>
    

复制代码

botang

吴家硕 发表于 2018-4-10 21:24
这是我磁带机的配置和rman的配置，麻烦老师解答下

见：https://www.botangdb.com/mytec/m ... 01607/00900024.html

botang

吴家硕 发表于 2018-4-10 21:24
这是我磁带机的配置和rman的配置，麻烦老师解答下

见：https://www.botangdb.com/mytec/m ... 01607/00900024.html

tangjiangdong

obtool


lshost
chhost --addrole mediaserver station8
lshost

mkdev -t library -o -a station8:/dev/sg10 lib01
mkdev -t library -o -a station8:/dev/sg11 lib02
mkdev -t tape -o -a station8:/dev/sg4 -l lib01 -d 4 tape04
mkdev -t tape -o -a station8:/dev/sg5 -l lib01 -d 5 tape05
老师，前面都正常到了这边就报错了，试了几次都这样：
ob> inventory -L lib01
Error: unable to open qlm connection - invalid DTE number
ob> lsvol -L lib01 -l
Error: unable to open qlm connection - invalid DTE number


PS：是不是应该要这么设置？
mkdev -t tape -o -a station8:/dev/sg4 -l lib01 -d 3 tape03
mkdev -t tape -o -a station8:/dev/sg5 -l lib01 -d 4 tape04

还有可以不可以删除上面这个mkdev累加配置？不然每次恢复操作系统挺麻烦的

tangjiangdong

tangjiangdong 发表于 2018-4-14 07:18
obtool

这个问题解决了，就是猜测的设置方式？不能根据sgX来设置，而是必须设置为3，4

botang

tangjiangdong 发表于 2018-4-14 12:47
这个问题解决了，就是猜测的设置方式？不能根据sgX来设置，而是必须设置为3，4

是的，只有lib01的tape03和tape04可用。这个虚拟带库也可以用在生产环境。