Delphix Products

 View Only

  • 1.  RMAN cannot load the SBT Library for database

    Posted 05-02-2022 02:37:00 PM
    can't take a snapshot, can someone help me?
    Recovery Manager: Release 18.0.0.0.0 - Production on Mon May 2 19:23:15 2022 Version 18.4.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. RMAN> Spooling started in trace file: /var/opt/delphix/toolkit/Delphix_c3f16482e693_969f6770c729_8_host/toolkits/link/oracle/linux/x86/lib64/SNL.1.3.JbASKpxRkoyd2sfTx614R6Zg.log RMAN> connected to target database: XE (DBID=2964642690) RMAN> 2> echo set on RMAN> SET ENCRYPTION OFF; executing command: SET encryption using target database control file instead of recovery catalog RMAN> RUN { 2> # add block options 3> SET NOCFAU; 4> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; 5> 6> ALLOCATE CHANNEL DLPX_CHANNEL_0 DEVICE TYPE sbt 7> PARMS='SBT_LIBRARY=/var/opt/delphix/toolkit/Delphix_c3f16482e693_969f6770c729_8_host/toolkits/link/oracle/linux/x86/lib64/libobk_proxy.so, 8> BLKSIZE=262144, 9> ENV=( 10> DELPHIX_CONFIG_DIR=/var/opt/delphix/toolkit/Delphix_c3f16482e693_969f6770c729_8_host/toolkits/link/oracle/linux/x86/lib64, 11> DELPHIX_SERVER=ip-172-31-63-62, 12> DELPHIX_INSTANCE=SNL.1.3.JbASKpxRkoyd2sfTx614R6Zg, 13> DELPHIX_CHANNEL=DLPX_CHANNEL_0, 14> DELPHIX_PROXY=127.0.0.1, 15> DELPHIX_PORT=37048 16> )'; 17> 18> ALLOCATE CHANNEL DLPX_CHANNEL_1 DEVICE TYPE sbt 19> PARMS='SBT_LIBRARY=/var/opt/delphix/toolkit/Delphix_c3f16482e693_969f6770c729_8_host/toolkits/link/oracle/linux/x86/lib64/libobk_proxy.so, 20> BLKSIZE=262144, 21> ENV=( 22> DELPHIX_CONFIG_DIR=/var/opt/delphix/toolkit/Delphix_c3f16482e693_969f6770c729_8_host/toolkits/link/oracle/linux/x86/lib64, 23> DELPHIX_SERVER=ip-172-31-63-62, 24> DELPHIX_INSTANCE=SNL.1.3.JbASKpxRkoyd2sfTx614R6Zg, 25> DELPHIX_CHANNEL=DLPX_CHANNEL_1, 26> DELPHIX_PROXY=127.0.0.1, 27> DELPHIX_PORT=37048 28> )'; 29> 30> SET COMMAND ID TO 'SNL.1.3.JbASKpxRkoyd2sfTx614R6Zg'; 31> # add pre-backup options 32> 33> BACKUP 34> # add backup options 35> NOEXCLUDE 36> FORCE COPIES 1 37> AS BACKUPSET 38> FILESPERSET 5 39> TAG 'DLPX202205021623127EE5E82CFAB5' 40> FORMAT '%U' 41> MAXSETSIZE 129G 42> SKIP OFFLINE 43> DATABASE ROOT PLUGGABLE DATABASE 'PDB$SEED' 44> INCLUDE CURRENT CONTROLFILE; 45> 46> # archive logs covering backup period 47> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; 48> # archive logs after backup period. Required for accurate time based recovery 49> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; 50> 51> CHANGE 52> BACKUP OF 53> CONTROLFILE DATABASE CONTROLFILE SPFILE 54> DEVICE TYPE sbt 55> TAG 'DLPX202205021623127EE5E82CFAB5' 56> UNAVAILABLE; 57> } executing command: SET NOCFAU sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of allocate command on DLPX_CHANNEL_0 channel at 05/02/2022 19:23:17 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library Additional information: 4156 RMAN> RMAN> exit Recovery Manager complete.




    ------------------------------
    [Hebert] [Souza]
    [Technical consult]
    [TGV]
    [Brazil]
    ------------------------------


  • 2.  RE: RMAN cannot load the SBT Library for database
    Best Answer

    Posted 05-02-2022 07:28:00 PM
    Hi Hebert.

     As the error indicates, this is typically a permissions problem. Has it worked previously?  I would suggest checking the following..

     - Login as the oracle user, and confirm you can access the files in /var/opt/delphix/toolkit/Delphix_c3f16482e693_969f6770c729_8_host/toolkits/link/oracle/linux/x86/lib64
     - Refresh the Environment and attempt again.
     - There may be debug files in /var/opt/delphix/toolkit/Delphix_c3f16482e693_969f6770c729_8_host/toolkits/link/oracle/linux/x86/lib64 directory, review these for further errors.
     - Confirm the Delphix OS user is a member of the Oracle install and DBA groups ( typically oinstall and dba ).

    If this does not resolve the issue, then you may want to raise a case with Delphix Support for further review.



    ------------------------------
    Matt Watson
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------

    Original Message


  • 3.  RE: RMAN cannot load the SBT Library for database

    Posted 05-04-2022 03:57:00 PM
    Hi Matt.

    As indicated we tested, and we found that the oracle user was not having access to the folder in the toolkit we put the user in oinstall and it works perfectly.

    Thanks a lot for helping!

    ------------------------------
    [Hebert] [Souza]
    [Technical consult]
    [TGV]
    [Brazil]
    ------------------------------

    Original Message


Related Content