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

Thread: Tivoli/Rman/9i

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    94

    Tivoli/Rman/9i

    Tried to run a backup direct to tape and received :
    RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE

    Oracle 9i
    Solaris 10

    IBM Tivoli Storage Manager for Databases:
    Data Protection for Oracle
    Version 5, Release 3, Level 3.0

    Backup script:

    prompt> rman target / catalog=rmannew/rmannew@repo cmdfile=backup_rman_inc0

    Recovery Manager: Release 9.2.0.8.0 - 64bit Production

    Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

    connected to target database: COOPPROD (DBID=421256345)
    connected to recovery catalog database

    RMAN> run {
    2> allocate channel t1 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/u1/app/oracle/TSM/tdpo.opt_COOPPROD)';
    3> backup
    4> incremental level 0
    5> filesperset 3
    6> format 'full_%d_%s_%p_%t'
    7> (database);
    8> change archivelog all validate;
    9> backup
    10> format 'arch_%d_%s_%p_%t'
    11> filesperset 10
    12> (archivelog until time 'Sysdate-3' all delete input);
    13> release channel t1;
    14> }
    15>
    16>
    allocated channel: t1
    channel t1: sid=28 devtype=SBT_TAPE
    channel t1: Data Protection for Oracle: version 5.3.3.0

    Starting backup at 01-DEC-09
    channel t1: starting incremental level 0 datafile backupset
    channel t1: specifying datafile(s) in backupset
    input datafile fno=00013 name=/u2/oradata/COOPPROD/cfa01.dbf
    input datafile fno=00021 name=/u3/oradata/COOPPROD/coa_index.dbf
    input datafile fno=00012 name=/u3/oradata/COOPPROD/aura_index01.dbf
    channel t1: starting piece 1 at 01-DEC-09

    channel t1: finished piece 1 at 01-DEC-09
    piece handle=full_COOPPROD_94_1_704469246 comment=API Version 2.0,MMS Version 5.3.3.0
    channel t1: backup set complete, elapsed time: 01:18:58
    channel t1: starting incremental level 0 datafile backupset
    channel t1: specifying datafile(s) in backupset
    input datafile fno=00028 name=/u2/oradata/COOPPROD/cfa02.dbf
    input datafile fno=00002 name=/u4/oradata/COOPPROD/undotbs01.dbf
    input datafile fno=00023 name=/u3/oradata/COOPPROD/ftreg_index01.dbf
    channel t1: starting piece 1 at 01-DEC-09
    channel t1: finished piece 1 at 01-DEC-09
    piece handle=full_COOPPROD_95_1_704473984 comment=API Version 2.0,MMS Version 5.3.3.0
    channel t1: backup set complete, elapsed time: 00:32:06
    channel t1: starting incremental level 0 datafile backupset
    channel t1: specifying datafile(s) in backupset
    input datafile fno=00029 name=/u4/oradata/COOPPROD/coop_interface01.dbf
    input datafile fno=00022 name=/u2/oradata/COOPPROD/ftreg01.dbf
    input datafile fno=00030 name=/u2/oradata/COOPPROD/ftreg02.dbf
    channel t1: starting piece 1 at 01-DEC-09
    channel t1: finished piece 1 at 01-DEC-09
    piece handle=full_COOPPROD_96_1_704475910 comment=API Version 2.0,MMS Version 5.3.3.0
    channel t1: backup set complete, elapsed time: 00:16:25
    channel t1: starting incremental level 0 datafile backupset
    channel t1: specifying datafile(s) in backupset
    input datafile fno=00020 name=/u2/oradata/COOPPROD/coa01.dbf
    input datafile fno=00011 name=/u2/oradata/COOPPROD/aura01.dbf
    input datafile fno=00018 name=/u2/oradata/COOPPROD/cfglog.dbf
    channel t1: starting piece 1 at 01-DEC-09
    channel t1: finished piece 1 at 01-DEC-09
    piece handle=full_COOPPROD_97_1_704476896 comment=API Version 2.0,MMS Version 5.3.3.0
    channel t1: backup set complete, elapsed time: 00:07:55
    channel t1: starting incremental level 0 datafile backupset
    channel t1: specifying datafile(s) in backupset
    input datafile fno=00017 name=/u3/oradata/COOPPROD/cfa_index01.dbf
    input datafile fno=00019 name=/u3/oradata/COOPPROD/cfglog_index01.dbf
    input datafile fno=00026 name=/u3/oradata/COOPPROD/takeon_index.dbf
    channel t1: starting piece 1 at 01-DEC-09
    channel t1: finished piece 1 at 01-DEC-09
    piece handle=full_COOPPROD_98_1_704477371 comment=API Version 2.0,MMS Version 5.3.3.0
    channel t1: backup set complete, elapsed time: 00:07:25
    channel t1: starting incremental level 0 datafile backupset
    channel t1: specifying datafile(s) in backupset
    including current SPFILE in backupset
    including current controlfile in backupset
    input datafile fno=00001 name=/u2/oradata/COOPPROD/system01.dbf
    channel t1: starting piece 1 at 01-DEC-09
    channel t1: finished piece 1 at 01-DEC-09
    piece handle=full_COOPPROD_99_1_704477816 comment=API Version 2.0,MMS Version 5.3.3.0
    channel t1: backup set complete, elapsed time: 00:04:56
    channel t1: starting incremental level 0 datafile backupset
    channel t1: specifying datafile(s) in backupset
    input datafile fno=00009 name=/u2/oradata/COOPPROD/users01.dbf
    input datafile fno=00008 name=/u2/oradata/COOPPROD/tools01.dbf
    input datafile fno=00024 name=/u2/oradata/COOPPROD/snaplog.dbf
    channel t1: starting piece 1 at 01-DEC-09
    channel t1: finished piece 1 at 01-DEC-09
    piece handle=full_COOPPROD_100_1_704478112 comment=API Version 2.0,MMS Version 5.3.3.0
    channel t1: backup set complete, elapsed time: 00:04:45
    channel t1: starting incremental level 0 datafile backupset
    channel t1: specifying datafile(s) in backupset
    input datafile fno=00005 name=/u2/oradata/COOPPROD/example01.dbf
    input datafile fno=00010 name=/u2/oradata/COOPPROD/xdb01.dbf
    input datafile fno=00003 name=/u2/oradata/COOPPROD/cwmlite01.dbf
    channel t1: starting piece 1 at 01-DEC-09
    channel t1: finished piece 1 at 01-DEC-09
    piece handle=full_COOPPROD_101_1_704478397 comment=API Version 2.0,MMS Version 5.3.3.0
    channel t1: backup set complete, elapsed time: 00:04:15
    channel t1: starting incremental level 0 datafile backupset
    channel t1: specifying datafile(s) in backupset
    input datafile fno=00004 name=/u2/oradata/COOPPROD/drsys01.dbf
    input datafile fno=00007 name=/u2/oradata/COOPPROD/odm01.dbf
    input datafile fno=00025 name=/u2/oradata/COOPPROD/takeon.dbf
    channel t1: starting piece 1 at 01-DEC-09
    channel t1: finished piece 1 at 01-DEC-09
    piece handle=full_COOPPROD_102_1_704478652 comment=API Version 2.0,MMS Version 5.3.3.0
    channel t1: backup set complete, elapsed time: 00:04:35
    channel t1: starting incremental level 0 datafile backupset
    channel t1: specifying datafile(s) in backupset
    input datafile fno=00006 name=/u3/oradata/COOPPROD/indx01.dbf
    channel t1: starting piece 1 at 01-DEC-09
    channel t1: finished piece 1 at 01-DEC-09
    piece handle=full_COOPPROD_103_1_704478927 comment=API Version 2.0,MMS Version 5.3.3.0
    channel t1: backup set complete, elapsed time: 00:04:55
    Finished backup at 01-DEC-09

    released channel: t1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of crosscheck command at 12/01/2009 16:49:06
    RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE


    Can't see a crosscheck in there? Any help would be great.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    It looks to me you are using a shared connection to connect to rman, while doing rman always use a dedicated connection.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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