DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: database session terminated unexpectedly RMAN 10038

  1. #1
    Join Date
    Sep 2001
    Posts
    200
    Hi out there;
    I am on OPS. AIX 4.3 with tivoli/tsm as storage manager.
    I want to restore from cluster A to B. I have the backup of A. No problem. Now when I run the restore it fails about 3/4 through with one infamous error "database session terminated unexpectedly for channel ....". No ORA- message. The listener is fine. I turned RMAN debugging on and below is the output as well.
    Can someone help?



    ERROR message
    ################
    restoring datafile 00395 to /dev/rprod_1024_004
    =====================================================
    =============== ERROR MESSAGE STACK FOLLOWS ==========
    =======================================================
    fatal error in recovery manager
    fatal error during execution of command
    database session for channel t1 terminated unexpectedly





    #################################################
    RESTORE SCRIPT (NB fails about halfway through)
    #################################################
    run
    {
    allocate channel t1 type 'sbt_tape' connect internal/xxxx@xxxx parms
    'ENV=(
    #DSMI_DIR=/usr/tivoli/tsm/client/ba/bin,
    #DSMI_ORC_CONFIG=/tsm/cfg/ccs1_dsm.opt,
    #DSMI_ORC_CONFIG=/usr/tivoli/tsm/client/ba/bin/ccs1_oracle.opt,
    DSMO_NODE=ccsp1,
    DSMO_DEBUG=49,
    DSMO_PSWDPATH=/usr/tivoli/tsm/client/oracle/bin)';
    #DSMI_LOG=/usr/tivoli/tsm/client/ba/bin)';
    restore controlfile;
    sql 'alter database mount shared';
    restore database;
    #recover database;
    #sql 'alter database open';
    release channel t1;
    }

    ###############################################
    DEBUG Trace from RMAN at time session ends
    ################################################

    EXEC SQL AT TARGET declare vsn varchar2 ( 20 ) ; begin vsn := dbms_rcvman . getP
    ackageVersion ; kg_vsnkg_vsn_i := vsn ; if vsn is not null then kg_vsnub4
    := to_number ( substr ( vsn , 1 , 2 ) || substr ( vsn , 4 , 2 ) || substr ( vsn
    , 7 , 2 ) ) ; end if ; end ;
    sqlcode=0
    krmxr: callback returned TRUE, skipping sleep
    krmxpoq: xc=539433176, action="0000876 STARTED", col_l=15, ind=0, sid=10
    krmxr: sleeping for 1 seconds
    krmxpoq: xc=539433176, action="0000876 STARTED", col_l=15, ind=0, sid=10
    krmxr: sleeping for 2 seconds
    krmxpoq: xc=539433176, action="0000876 STARTED", col_l=15, ind=0, sid=10
    krmxr: sleeping for 4 seconds
    krmxpoq: xc=539433176, action="0000876 STARTED", col_l=15, ind=0, sid=10
    krmxr: sleeping for 8 seconds
    krmxpoq: xc=539433176, action="0000876 STARTED", col_l=15, ind=0, sid=10
    krmxr: sleeping for 10 seconds
    krmxpoq: xc=539433176, action="0000876 STARTED", col_l=15, ind=0, sid=10
    krmxr: sleeping for 10 seconds
    krmxpoq: xc=539433176, action="0000876 STARTED", col_l=15, ind=0, sid=10
    krmxr: sleeping for 10 seconds
    krmxpoq: xc=539433176, action="0000876 STARTED", col_l=15, ind=0, sid=10

    Life is what is happening today while you were planning tomorrow.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here are some questions on this?

    Is your ORACLE_HOME environment configured correctly. LD_LIBRARY_PATH, and etc.

    IS the libraries like libobk linked properly to the /usr/lib/libobk.so

    Did you check your alert_SID.log for any ORA messages or any trace generations

    Can you run the rman in the debug mode
    Code:
        rman target ... catalog ... debug trace /path/filename.log
    and check for what exactly happens with the RMAN.

    Did you check the sbtio.log normally generated under $ORACLE_BASE/admin/SID/udump

    Consult tivoli, oracle will not help you with the third party backup softwares.

    I notice that you have posted a few messages at oracle support but hope it doesn't go on vein Contact Tivoli first and they would help you to figure out. At times you have to be patient to get the level 2 support woh would be most informed about the issues. Take it easy and contact Tivoli.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2001
    Posts
    200
    thanks
    out there. My libraries PATH is fine. and everything else is OK.
    There are some suggestions from Oracle site that this may have to do with the ADSM server running out of shared memory. Any comment?
    The piece of junk code in my post is the debug file of RMAN (with the 'sleeping seconds'). It quite big so I just pasted the last lines here.
    Posted below are some excepts from the sbtio.log file
    Thanks
    Tony

    (64622) OBK-sbt:<12/14/2001:13:22:21> ReadPswdFromFile():/usr/tivoli/tsm/client/
    oracle/bin/TDPO.ccsp1 DSMO_FS=tsmob ANS0282E (RC168) Password file is not a
    vailable.

    (64622) OBK-sbt:<12/14/2001:13:22:21> odsmSess(): psReadPswd(): oer = 7011, errn
    o = 168.
    (64622) OBK-sbt:<12/14/2001:13:22:21> sbtopen(): sbtopen exit. odsmSess failed.
    rc = -1
    (23080) OBK-sbt:<12/14/2001:13:31:44> odsmSess(): # of dsmInit retries = 1
    (23080) OBK-sbt:<12/14/2001:13:31:44> queryObj(): ANS1302E (RC2) No objects
    on server match query

    (23080) OBK-sbt:<12/14/2001:13:31:44> sbtopen(): ANS1302E (RC2) No objects o
    n server match query
    140308) OBK-sbt:<12/24/2001:14:47:25> odsmSess(): # of dsmInit retries = 1
    140308) OBK-sbt:<12/24/2001:14:49:25> sbtread(): End of file reached. oer = 706
    , errno = 2505.
    140308) OBK-sbt:<12/24/2001:14:49:31> odsmSess(): # of dsmInit retries = 1
    140308) OBK-sbt:<12/24/2001:14:52:41> sbtread(): End of file reached. oer = 706
    , errno = 2505.
    140308) OBK-sbt:<12/24/2001:14:52:47> odsmSess(): # of dsmInit retries = 1
    140308) OBK-sbt:<12/24/2001:14:55:31> sbtread(): End of file reached. oer = 706
    , errno = 2505.


    Life is what is happening today while you were planning tomorrow.

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    First check your password file on the two servers ...

    (64622) OBK-sbt:<12/14/2001:13:22:21> ReadPswdFromFile():/usr/tivoli/tsm/client/
    oracle/bin/TDPO.ccsp1 DSMO_FS=tsmob ANS0282E (RC168) Password file is not available.


    Then contact Tivoli. Oracle will not be able to help you with this ...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Sep 2001
    Posts
    200
    Sam,
    I will follow your suggestions and see where I get.
    Thanks
    Tony
    Life is what is happening today while you were planning tomorrow.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width