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

Thread: Rman

  1. #1
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    platform NT 4.0
    Oracle 8.1.6
    ===========
    can some body throw some light on this
    =========================
    #################### Begin ############################
    Mon 10/15/2001
    1:00p

    Recovery Manager: Release 8.1.6.0.0 - Production

    RMAN-06005: connected to target database: RTS2 (DBID=1130404946)
    RMAN-06009: using target database controlfile instead of recovery catalog

    RMAN> run {
    2> allocate channel t1 type 'SBT_TAPE';
    3> setlimit channel t1 kbytes 2097150 maxopenfiles 32 readrate 200;
    4>
    5>
    6> # Archive the current online log
    7> sql 'alter system archive log current';
    8>
    9> # save archive logs...
    10> backup
    11> filesperset 100
    12> format 'al_%d_t%t_s%s_p%p'
    13> (archivelog all delete input);
    14>
    15> # Release the tape device
    16> release channel t1;
    17> }
    18>
    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: t1
    RMAN-08500: channel t1: sid=9 devtype=SBT_TAPE
    RMAN-08526: channel t1: MMS Version 2.2.0.1

    RMAN-03022: compiling command: set limit
    RMAN-03023: executing command: set limit

    RMAN-03022: compiling command: sql
    RMAN-06162: sql statement: alter system archive log current
    RMAN-03023: executing command: sql

    RMAN-03022: compiling command: backup
    RMAN-03023: executing command: backup
    RMAN-08009: channel t1: starting archivelog backupset
    RMAN-08502: set_count=2383 set_stamp=443192408 creation_time=15-OCT-01
    RMAN-08014: channel t1: specifying archivelog(s) in backup set
    RMAN-08504: input archivelog thread=1 sequence=42428 recid=39610 stamp=443189933
    RMAN-08504: input archivelog thread=1 sequence=42429 recid=39611 stamp=443192403
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03007: retryable error occurred during execution of command: backup
    RMAN-07004: unhandled exception during command execution on channel t1
    RMAN-10035: exception raised in RPC: ORA-19506: failed to create sequential file, name="al_RTS2_t443192408_s2383_p1", parms=""
    ORA-27007: failed to open file
    ORA-19511: SBT error = 7009, errno = 0, sbtopen: can't connect with media manager
    RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

    Recovery Manager complete.
    Mon 10/15/2001
    1:01p
    sonofsita
    http://www.ordba.net

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What is your media manager? Check for more error messages in
    $ORACLE_BASE/admin/SID/udump/sbtio.log file


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    Oh sorry I forgot to mention that.

    Its is Legato 5.5 lsm build 111

    sonofsita
    http://www.ordba.net

  4. #4
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    the sbtio.log is empty
    sonofsita
    http://www.ordba.net

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Which library dows your $ORACLE_HOME/lib/libobk.so points to? In the Unix system it should be a symbolic link to your media manager library. If this had not been set correctly reset that, shutdown and start up your oracle instance and try again...

    in Solaris

    $ORACLE_HOME/lib/libobk.so --> /usr/lib/libobk.so

    The file name qualifier ".so" differ from OS to OS...



    Hope this would help you.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    there is no such file under oracle home. but under the nsr directory underwhich lsm software is installed i found a file by that name but it is dll file.There is no registration required for that in nt registry
    sonofsita
    http://www.ordba.net

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Parden my ignorence. I failed to notice your OS. Any how this seems to be the problem on the part of media manager. If you have upgraded your system and have not upgraded the media manager, then it could be an issue of that old media manager not being able to support the newer RMAN library. On such case I would suggest that you uninstall the older manager and install the newer one. If it was the case the media manager and oracle are of newer ones, then I could only suggest you to contact oracle on this regard...

    The problem can also be that the user logged into Windows NT is not authorized as a Legato user via Networker Administrator's Guide, or does not have NT administrator privileges.


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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