设为首页收藏本站

Botang唐波's Oracle Station

查看: 377|回复: 11

课程第27次(2018-04-09星期一)

[复制链接]

640

主题

995

帖子

7333

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
7333
发表于 2018-4-9 21:01:02 | 显示全部楼层 |阅读模式
  1. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

  2. new RMAN configuration parameters:
  3. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  4. new RMAN configuration parameters are successfully stored

  5. RMAN> show all;

  6. RMAN configuration parameters for database with db_unique_name ORCL are:
  7. CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
  8. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  9. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  10. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  11. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  12. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  13. CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
  14. CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
  15. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  16. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  17. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  18. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  19. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  20. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  21. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  22. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  23. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  24. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  25. RMAN> backup datafile 4;

  26. Starting backup at 09-APR-18
  27. RMAN-00571: ===========================================================
  28. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  29. RMAN-00571: ===========================================================
  30. RMAN-03002: failure of backup command at 04/09/2018 20:08:10
  31. ORA-19554: error allocating device, device type: SBT_TAPE, device name:
  32. ORA-27211: Failed to load Media Management Library
  33. Additional information: 2

  34. 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. This CD-ROM contains Oracle Secure Backup version 4.0.4.1_linux.x64.

  8. Please wait a moment while I learn about this host... done.

  9. -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -
  10.     1. linux86_64
  11.        administrative server, media server, client

  12. -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -
  13. Loading Oracle Secure Backup installation tools... done.
  14. Loading linux86_64 administrative server, media server, client... done.

  15. -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -
  16. Loading of Oracle Secure Backup software from CD-ROM is complete.
  17. You may unmount and remove the CD-ROM.


  18. Would you like to continue Oracle Secure Backup installation with
  19. 'installob' now?  (The Oracle Secure Backup Installation Guide
  20. contains complete information about installob.)
  21. Please answer 'yes' or 'no' [yes]: yes

  22. -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -

  23. Welcome to installob, Oracle Secure Backup's installation program.

  24. For most questions, a default answer appears enclosed in square brackets.
  25. Press Enter to select this answer.

  26. Please wait a few seconds while I learn about this machine... done.

  27. Have you already reviewed and customized install/obparameters for your
  28. Oracle Secure Backup installation [yes]? yes

  29. -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -

  30. Oracle Secure Backup is not yet installed on this machine.

  31. Oracle Secure Backup's Web server has been loaded, but is not yet configured.

  32. Choose from one of the following options. The option you choose defines
  33. the software components to be installed.

  34. Configuration of this host is required after installation completes.

  35. You can install the software on this host in one of the following ways:
  36.     (a) administrative server, media server and client

  37.     (b) media server and client

  38.     (c) client

  39. If you are not sure which option to choose, please refer to the Oracle
  40. Secure Backup Installation Guide. (a,b or c) [a]? a

  41. Beginning the installation.  This will take just a minute and will produce
  42. several lines of informational output.

  43. Installing Oracle Secure Backup on station20 (Linux version 2.6.32-696.el6.x86_64)

  44. You must now enter a password for the Oracle Secure Backup encryption
  45. key store.  Oracle suggests you choose a password of at least 8
  46. characters in length, containing a mixture of alphabetic and numeric
  47. characters.

  48. Please enter the key store password:
  49. Re-type password for verification:  

  50. You must now enter a password for the Oracle Secure Backup 'admin' user.
  51. Oracle suggests you choose a password of at least 8 characters in length,
  52. containing a mixture of alphabetic and numeric characters.

  53. Please enter the admin password:
  54. Re-type password for verification:  

  55. You should now enter an email address for the Oracle Secure Backup 'admin'
  56. user. Oracle Secure Backup uses this email address to send job summary
  57. reports and to notify the user when a job requires input. If you leave this
  58. blank, you can set it later using the obtool's 'chuser' command.

  59. Please enter the admin email address:


  60.     generating links for admin installation with Web server
  61.     updating /etc/ld.so.conf
  62.     checking Oracle Secure Backup's configuration file (/etc/obconfig)
  63.     setting Oracle Secure Backup directory to /usr/local/oracle/backup in /etc/obconfig
  64.     setting local database directory to /usr/etc/ob in /etc/obconfig
  65.     setting temp directory to /usr/tmp in /etc/obconfig
  66.     setting administrative directory to /usr/local/oracle/backup/admin in /etc/obconfig
  67.     setting version to 10.4.0.4.0 in /etc/obconfig
  68.     protecting the Oracle Secure Backup directory
  69.     creating /etc/rc.d/init.d/observiced
  70.     activating observiced via chkconfig
  71.     initializing the administrative domain

  72. ****************************** N O T E ******************************
  73. On Linux systems Oracle recommends that you answer no to the next two
  74. questions. The preferred mode of operation on Linux systems is to use
  75. the /dev/sg devices for attach points as described in the 'ReadMe'
  76. and in the 'Installation and Configuration Guide'.


  77. Is station20 connected to any tape libraries that you'd like to use with
  78. Oracle Secure Backup [no]?

  79. Is station20 connected to any tape drives that you'd like to use with
  80. Oracle Secure Backup [no]?

  81. Installation summary:

  82.     Installation  Host                OS          Driver     OS Move    Reboot
  83.         Mode      Name                Name      Installed?  Required?  Required?

  84.     admin         station20           Linux     no          no         no   

  85. 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>
复制代码


回复

使用道具 举报

0

主题

11

帖子

86

积分

注册会员

Rank: 2

积分
86
QQ
发表于 2018-4-10 15:51:20 | 显示全部楼层
老师 改成磁带机后备份报错 不知道错哪了
  1. RMAN> backup datafile 5;

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

  20. RMAN>
复制代码
回复 支持 反对

使用道具 举报

0

主题

11

帖子

86

积分

注册会员

Rank: 2

积分
86
QQ
发表于 2018-4-10 16:06:45 | 显示全部楼层
叶俊海 发表于 2018-4-10 15:51
老师 改成磁带机后备份报错 不知道错哪了

重启后可以了
回复 支持 反对

使用道具 举报

0

主题

3

帖子

16

积分

新手上路

Rank: 1

积分
16
发表于 2018-4-10 21:21:37 | 显示全部楼层
老师,备份后一直卡在那了,不过看进程好像有在运行,不知道怎么回事
  1. RMAN> backup database;

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


回复 支持 反对

使用道具 举报

0

主题

3

帖子

16

积分

新手上路

Rank: 1

积分
16
发表于 2018-4-10 21:24:38 | 显示全部楼层
这是我磁带机的配置和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. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 11 05:23:19 2018

  3. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  4. connected to target database: ORCL (DBID=1497044535, not open)

  5. RMAN> show all;

  6. using target database control file instead of recovery catalog
  7. RMAN configuration parameters for database with db_unique_name ORCL are:
  8. CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
  9. CONFIGURE BACKUP OPTIMIZATION ON;
  10. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  11. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  12. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  13. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  14. CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
  15. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  16. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 2;
  17. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  18. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
  19. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  20. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  21. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  22. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  23. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  24. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  25. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  26. RMAN>
复制代码

回复 支持 反对

使用道具 举报

640

主题

995

帖子

7333

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
7333
 楼主| 发表于 2018-4-11 17:24:56 | 显示全部楼层
吴家硕 发表于 2018-4-10 21:24
这是我磁带机的配置和rman的配置,麻烦老师解答下

见:http://www.botangdb.com/mytec/my ... 01607/00900024.html
回复 支持 反对

使用道具 举报

640

主题

995

帖子

7333

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
7333
 楼主| 发表于 2018-4-11 17:25:00 | 显示全部楼层
吴家硕 发表于 2018-4-10 21:24
这是我磁带机的配置和rman的配置,麻烦老师解答下

见:http://www.botangdb.com/mytec/my ... 01607/00900024.html
回复 支持 反对

使用道具 举报

9

主题

23

帖子

107

积分

注册会员

Rank: 2

积分
107
发表于 2018-4-14 07:18:43 | 显示全部楼层
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累加配置?不然每次恢复操作系统挺麻烦的
回复 支持 反对

使用道具 举报

9

主题

23

帖子

107

积分

注册会员

Rank: 2

积分
107
发表于 2018-4-14 12:47:12 | 显示全部楼层

这个问题解决了,就是猜测的设置方式?不能根据sgX来设置,而是必须设置为3,4
回复 支持 反对

使用道具 举报

640

主题

995

帖子

7333

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
7333
 楼主| 发表于 2018-4-16 09:32:53 | 显示全部楼层
tangjiangdong 发表于 2018-4-14 12:47
这个问题解决了,就是猜测的设置方式?不能根据sgX来设置,而是必须设置为3,4

是的,只有lib01的tape03和tape04可用。这个虚拟带库也可以用在生产环境。
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Botang唐波's Oracle Station   

GMT+8, 2018-5-26 00:43 , Processed in 0.226883 second(s), 25 queries .

快速回复 返回顶部 返回列表