1 2 Previous Next 18 Replies Latest reply: Jan 11, 2013 6:40 PM by mseberg RSS

    RMAN-03009: failure of allocate command on t1 channel, ORA-03113

    9233598
      I am doing a refresh of test environment from production backups.

      The both environments are aix, and same version of oracle 11g.

      I am using this command to restore controlfile autobackup first:
      run
      {
      allocate channel t1 type 'SBT_TAPE';
      send 'NSR_ENV=(NSR_SERVER=networker,NSR_CLIENT=servername,,NSR_AES_ENCRYPTION=TRUE)';
      set controlfile autobackup format for device type 'sbt_tape' to '/NMO_v_%F';
      restore controlfile to '+DAT/PRD/PRD_autobackup.ctl' from autobackup;
      restore controlfile from '+DAT/PRD/PRD_autobackup.ctl';
      release channel t1;
      }

      However it kept giving me following error:
      Recovery Manager: Release 11.1.0.7.0 - Production on Tue Jan 8 00:16:38 2013

      Copyright (c) 1982, 2007, Oracle. All rights reserved.

      connected to target database: PRD (not mounted)

      RMAN>
      executing command: SET DBID

      RMAN>
      using target database control file instead of recovery catalog
      Oracle instance shut down

      RMAN>
      connected to target database (not started)
      Oracle instance started

      Total System Global Area 3774861312 bytes

      Fixed Size 2159312 bytes
      Variable Size 553651504 bytes
      Database Buffers 3204448256 bytes
      Redo Buffers 14602240 bytes

      RMAN> 2> 3> 4> 5> 6> 7> 8> 9>
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03009: failure of allocate command on t1 channel at 01/08/2013 00:16:45
      ORA-03113: end-of-file on communication channel


      Please help. Thanks.
        • 1. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
          mseberg
          Hello;

          I would check the ASM diskgroup and make sure I have the two convert parameters if the diskgroups are not the same.

          Also remember you have to be NOMOUNT for the control file restore and then mount for the rest.

          Best Regards

          mseberg
          • 2. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
            9233598
            We have done this refresh every three months, all had no issue before.

            I checked old log, it shows oracle db not started also, all worked. Seems this time canot allocate a channel.

            and ora-03113 means what?
            • 3. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
              mseberg
              Hello again;

              A non active connection is being killed. If this were a duplicate I'll check for Firewall changes.

              This is probably what I would try :
              startup nomount
              
              rman nocatalog
              
              connect target
              
              restore controlfile to '+DAT/PRD/PRD_autobackup.ctl' from OLD_PATH
              You are correct - autobackup

              I must be trying too many things at once.

              Would look at running with with log and trace :

              $ORACLE_HOME/bin/rman debug trace rman.trc log rman.log

              I'm thinking you'll find a mismatch between some library and you either need to compile or replace a library version.





              Best Regards

              mseberg

              Edited by: mseberg on Jan 8, 2013 7:50 AM
              • 4. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
                9233598
                but this controlfile autobackup is from tape.
                • 5. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
                  user569151
                  test it manually.

                  Edited by: user569151 on Jan 8, 2013 8:49 AM
                  • 6. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
                    9233598
                    I did each step manually on rman prompt, here is the results:

                    rman target /

                    Recovery Manager: Release 11.1.0.7.0 - Production on Tue Jan 8 13:21:48 2013

                    Copyright (c) 1982, 2007, Oracle. All rights reserved.

                    connected to target database: PRD (not mounted)

                    RMAN> set DBID=123456789

                    executing command: SET DBID

                    RMAN> shutdown immediate;

                    using target database control file instead of recovery catalog
                    Oracle instance shut down

                    RMAN> startup nomount pfile='/tmp/initPRD.ora';

                    connected to target database (not started)
                    Oracle instance started

                    Total System Global Area 3774861312 bytes

                    Fixed Size 2159312 bytes
                    Variable Size 553651504 bytes
                    Database Buffers 3204448256 bytes
                    Redo Buffers 14602240 bytes

                    RMAN> run
                    2> {
                    3> allocate channel t1 type 'SBT_TAPE';
                    4> send 'NSR_ENV=(NSR_SERVER=nsr,NSR_CLIENT=clientname,NSR_AES_ENCRYPTION=TRUE)';
                    5> set controlfile autobackup format for device type 'sbt_tape' to '/NMO_v_%F';
                    6> restore controlfile to '+PRD_DAT/PRD/PRD_autobackup2.ctl' from autobackup;
                    7> restore controlfile from '+PRD_DAT/PRD/PRD_autobackup2.ctl';
                    8> release channel t1;
                    9> }

                    RMAN-00571: ===========================================================
                    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                    RMAN-00571: ===========================================================
                    RMAN-03009: failure of allocate command on t1 channel at 01/08/2013 13:22:40
                    ORA-03113: end-of-file on communication channel

                    RMAN> run
                    2> {
                    allocate channel t1 type 'SBT_TAPE';
                    3> send 'NSR_ENV=(NSR_SERVER=nsr,NSR_CLIENT=clientname,NSR_AES_ENCRYPTION=TRUE)';
                    set controlfile autobackup format for device type 'sbt_tape' to '/NMO_v_%F';
                    restore controlfile to '+PRD_DAT/PRD/PRD_autobackup2.ctl' from autobackup;
                    4> 5> 6> 7> }

                    RMAN-00571: ===========================================================
                    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                    RMAN-00571: ===========================================================
                    RMAN-03009: failure of allocate command on t1 channel at 01/08/2013 13:23:18
                    ORA-03113: end-of-file on communication channel

                    please help.Not sure what went wrong here.
                    • 7. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
                      CKPT
                      9233598 wrote:
                      I did each step manually on rman prompt, here is the results:

                      rman target /

                      Recovery Manager: Release 11.1.0.7.0 - Production on Tue Jan 8 13:21:48 2013

                      Copyright (c) 1982, 2007, Oracle. All rights reserved.

                      connected to target database: PRD (not mounted)

                      RMAN> set DBID=123456789

                      executing command: SET DBID

                      RMAN> shutdown immediate;

                      using target database control file instead of recovery catalog
                      Oracle instance shut down

                      RMAN> startup nomount pfile='/tmp/initPRD.ora';

                      connected to target database (not started)
                      Oracle instance started

                      Total System Global Area 3774861312 bytes

                      Fixed Size 2159312 bytes
                      Variable Size 553651504 bytes
                      Database Buffers 3204448256 bytes
                      Redo Buffers 14602240 bytes

                      RMAN> run
                      2> {
                      3> allocate channel t1 type 'SBT_TAPE';
                      4> send 'NSR_ENV=(NSR_SERVER=nsr,NSR_CLIENT=clientname,NSR_AES_ENCRYPTION=TRUE)';
                      5> set controlfile autobackup format for device type 'sbt_tape' to '/NMO_v_%F';
                      6> restore controlfile to '+PRD_DAT/PRD/PRD_autobackup2.ctl' from autobackup;
                      7> restore controlfile from '+PRD_DAT/PRD/PRD_autobackup2.ctl';
                      8> release channel t1;
                      9> }

                      RMAN-00571: ===========================================================
                      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                      RMAN-00571: ===========================================================
                      RMAN-03009: failure of allocate command on t1 channel at 01/08/2013 13:22:40
                      ORA-03113: end-of-file on communication channel

                      RMAN> run
                      2> {
                      allocate channel t1 type 'SBT_TAPE';
                      3> send 'NSR_ENV=(NSR_SERVER=nsr,NSR_CLIENT=clientname,NSR_AES_ENCRYPTION=TRUE)';
                      set controlfile autobackup format for device type 'sbt_tape' to '/NMO_v_%F';
                      restore controlfile to '+PRD_DAT/PRD/PRD_autobackup2.ctl' from autobackup;
                      4> 5> 6> 7> }

                      RMAN-00571: ===========================================================
                      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                      RMAN-00571: ===========================================================
                      RMAN-03009: failure of allocate command on t1 channel at 01/08/2013 13:23:18
                      ORA-03113: end-of-file on communication channel

                      please help.Not sure what went wrong here.
                      Can you please check alert log file and share with us when the RMAN error-ed out.
                      and also enable RMAN trace and provide if you find additional information.

                      Example:
                      $ rman target / debug trace=/tmp/debug_rman_trace.trc log=/tmp/restore.txt
                      • 8. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
                        mseberg
                        Hello again;

                        OK, this
                        RMAN-03009: failure of allocate command on t1 channel at 01/08/2013 13:22:40
                        ORA-03113: end-of-file on communication channel
                        Says the the media software and Oracle probably have a mismatch. So I was wrong, this has nothing to do with how or where your control file is being restored from.

                        $ORACLE_HOME/bin/rman debug trace rman.trc log rman.log

                        I'm thinking the trace may offer a clue about a library version mismatch.

                        Best Regards

                        mseberg
                        • 9. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
                          9233598
                          alert log checked, there is no errors , no entries after the db started no mounted.

                          This is last of alert log:
                          RECO started with pid=16, OS id=549160
                          Tue Jan 08 13:22:29 2013
                          MMON started with pid=17, OS id=544776
                          Tue Jan 08 13:22:29 2013
                          MMNL started with pid=18, OS id=942390
                          lmon registered with NM - instance id 1 (internal mem no 0)
                          Reconfiguration started (old inc 0, new inc 2)
                          List of nodes:
                          0
                          Global Resource Directory frozen
                          * allocate domain 0, invalid = TRUE
                          Communication channels reestablished
                          Master broadcasted resource hash value bitmaps
                          Non-local Process blocks cleaned out
                          Resources and enqueues cleaned out
                          Resources remastered 0
                          Set master node info
                          Submitted all remote-enqueue requests
                          Dwn-cvts replayed, VALBLKs dubious
                          All grantable enqueues granted
                          Post SMON to start 1st pass IR
                          Submitted all GCS remote-cache requests
                          Reconfiguration complete
                          ORACLE_BASE from environment = /u01/oracle
                          • 10. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
                            CKPT
                            Can you please check ASM alert log also and enable trace at RMAN and post the log here. Thanks.
                            • 11. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
                              9233598
                              I did trace and log for rman, here is what rman log say:


                              RMAN> 2> 3> 4> 5> 6> 7>
                              RMAN-00571: ===========================================================
                              RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                              RMAN-00571: ===========================================================
                              RMAN-03009: failure of allocate command on t1 channel at 01/08/2013 14:12:41
                              ORA-03113: end-of-file on communication channel

                              RMAN>
                              RMAN-03090: Starting restore at 08-JAN-13
                              RMAN-08030: allocated channel: ORA_DISK_1
                              RMAN-08500: channel ORA_DISK_1: SID=424 device type=DISK

                              RMAN-08538: channel ORA_DISK_1: no AUTOBACKUP in 7 days found
                              RMAN-00571: ===========================================================
                              RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                              RMAN-00571: ===========================================================
                              RMAN-00601: fatal error in recovery manager
                              RMAN-03004: fatal error during execution of command
                              RMAN-00600: internal error, arguments [6000] [] [] [] []

                              rman.trc has this :
                              DBGSQL: error: ORA-01507: database not mounted [14:12:41.710] (krmkosqlerr)
                              DBGSQL: EXITED krmkosqlerr [14:12:41.710] elapsed time [00:00:00:00.000]
                              DBGRCV: host=TARGET, transclause: 1, needuntscn: 0 haveuntscn: 0 (krmkicat)
                              DBGRCV: Need to initialize target (krmkicat)
                              DBGRCV: Need to initialize rcvcat (krmkicat)
                              DBGRCV: Forced to recompute until scn due to resetAll (krmkicat)
                              DBGSQL: ENTERED krmkosqlerr [14:12:41.710]

                              DBGSQL: TARGET> select decode(open_mode, 'MOUNTED', 0, 'READ WRITE', 1, 'READ ONLY', 1, 0) into :isdbope
                              n from v$database [14:12:41.710]
                              DBGSQL: sqlcode = 1507 [14:12:41.711]
                              DBGSQL: error: ORA-01507: database not mounted [14:12:41.711] (krmkosqlerr)
                              DBGSQL: EXITED krmkosqlerr [14:12:41.711] elapsed time [00:00:00:00.000]

                              DBGSQL: TARGET> declare transclause boolean := FALSE; begin if (:transclause > 0) then transclause := TRU
                              E; end if; dbms_rcvman.resetAll(transclause => transclause); end; [14:12:41.716]
                              DBGSQL: sqlcode = 0 [14:12:41.716]
                              DBGSQL: B :transclause = 1
                              DBGRCVMAN: resetAll
                              DBGRCVMAN: ENTERING setRAflags
                              DBGRCVMAN: setRAflags kindMask=255 containerMask=15 actionMask=63
                              DBGRCVMAN: ENTERING setComputeRecoveryActionMasks816
                              DBGRCVMAN: ENTERING setComputeRecoveryActionMasks
                              DBGRCVMAN: EXITING setComputeRecoveryActionMasks
                              DBGRCVMAN: EXITING setComputeRecoveryActionMasks816
                              DBGRCVMAN: EXITING setRAflags
                              DBGRCVMAN: allIncarnations is set to FALSE
                              DBGRCVMAN: reset transclause
                              DBGRCVMAN: *****BsRecCache Statistics*****
                              DBGRCVMAN: Cache size=0 hit=0
                              DBGRCVMAN: rcvRecBackupAge= 0
                              DBGRCVMAN: thisBackupAge= 0
                              DBGRCVMAN: ENTERING setRedoLogDeletionPolicy
                              DBGRCVMAN: setRedoLogDeletionPolicy with policy = TO NONE
                              DBGRCVMAN: setRedoLogDeletionPolicy with alldest = 0
                              DBGRCVMAN: ENTERING validateStandbyConfig1
                              DBGRCVMAN: policy = TO NONE
                              DBGRCVMAN: alldest = 0
                              DBGRCVMAN: this_cftype not set
                              DBGRCVMAN: EXITING validateStandbyConfig1 with status = 1
                              DBGRCVMAN: EXITING setRedoLogDeletionPolicy with policy = TO NONE with alldest = 0
                              DBGANY: No untilscn in effect [14:12:41.722] (krmkicat)
                              DBGRCV: EXITED krmkicat
                              DBGMISC: ENTERED krmknmtr [14:12:41.722]
                              DBGSQL: ENTERED krmkosqlerr [14:12:41.722]

                              DBGSQL: TARGET> select decode(open_mode, 'MOUNTED', 0, 'READ WRITE', 1, 'READ ONLY', 1, 0) into :isdbope
                              n from v$database [14:12:41.722]
                              DBGSQL: sqlcode = 1507 [14:12:41.722]
                              DBGSQL: error: ORA-01507: database not mounted [14:12:41.723] (krmkosqlerr)
                              DBGSQL: EXITED krmkosqlerr [14:12:41.723] elapsed time [00:00:00:00.000]
                              DBGMISC: EXITED krmknmtr with status CHID [14:12:41.723] elapsed time [00:00:00:00.000]
                              DBGMISC: krmknmtr: the parse tree after name translation is: [14:12:41.723] (krmknmtr)
                              DBGMISC: 1 CHALLOC
                              DBGMISC: 1 CHID = t1
                              DBGMISC: 2 CHTYPE = SBT_TAPE
                              DBGMISC: EXITED krmknmtr with status allocate [14:12:41.723] elapsed time [00:00:00:00.024]
                              DBGMISC: ENTERED krmkdps [14:12:41.723]
                              DBGMISC: EXITED krmkdps [14:12:41.723] elapsed time [00:00:00:00.000]
                              DBGSQL: ENTERED krmkosqlerr [14:12:41.724]

                              DBGSQL: TARGET> select decode(open_mode, 'MOUNTED', 0, 'READ WRITE', 1, 'READ ONLY', 1, 0) into :isdbopen
                              from v$database [14:12:41.724]
                              DBGSQL: sqlcode = 1507 [14:12:41.724]
                              DBGSQL: error: ORA-01507: database not mounted [14:12:41.724] (krmkosqlerr)
                              DBGSQL: EXITED krmkosqlerr [14:12:41.724] elapsed time [00:00:00:00.000]
                              DBGMISC: EXITED krmkomp [14:12:41.725] elapsed time [00:00:00:00.026]
                              DBGPLSQL: the compiled command tree is: [14:12:41.725] (krmicomp)
                              DBGPLSQL: 1 CMD type=allocate cmdid=1 status=NOT STARTED
                              DBGPLSQL: 1 STEPstepid=1 cmdid=1 status=NOT STARTED chid=t1
                              DBGPLSQL: 1 TEXTNOD = -- devalloc
                              DBGPLSQL: 2 TEXTNOD = declare
                              DBGPLSQL: 3 TEXTNOD = devtype varchar2(255);
                              DBGPLSQL: 4 TEXTNOD = chid varchar2(255);
                              DBGPLSQL: 5 TEXTNOD = debug number := null;
                              DBGPLSQL: 6 TEXTNOD = options number := null;
                              DBGPLSQL: 7 TEXTNOD = node varchar2(255);
                              DBGPLSQL: 8 TEXTNOD = maxsize number;
                              DBGPLSQL: 9 TEXTNOD = kbytes number := null;
                              DBGPLSQL: 10 TEXTNOD = parallel binary_integer := null;
                              DBGPLSQL: 11 TEXTNOD = readrate number := null;
                              DBGPLSQL: 12 TEXTNOD = rate number := null;
                              DBGPLSQL: 13 TEXTNOD = sendcmd varchar2(256);
                              DBGPLSQL: 14 TEXTNOD = vendor varchar2(256);
                              DBGPLSQL: 15 TEXTNOD = israc boolean;
                              DBGPLSQL: 16 TEXTNOD = instname varchar2(17);
                              DBGPLSQL: 17 TEXTNOD = begin
                              DBGPLSQL: 18 TEXTNOD =
                              DBGPLSQL: 19 PRMVAL = chid := 't1'; debug := 9;
                              DBGPLSQL: 20 TEXTNOD = if debug is not null then
                              DBGPLSQL: 21 TEXTNOD = krmicd.execSql(
                              DBGPLSQL: 22 TEXTNOD = 'alter session set events ''immediate trace name krb_trace level '
                              DBGPLSQL: 23 TEXTNOD = ||debug||'''');
                              DBGPLSQL: 24 TEXTNOD = end if;
                              DBGPLSQL: 25 TEXTNOD = if options is not null then
                              DBGPLSQL: 26 TEXTNOD = krmicd.execSql(
                              DBGPLSQL: 27 TEXTNOD = 'alter session set events ''immediate trace name krb_options level
                              '
                              DBGPLSQL: 28 TEXTNOD = ||options||'''');
                              DBGPLSQL: 29 TEXTNOD = end if;
                              DBGPLSQL: 30 TEXTNOD = devtype := sys.dbms_backup_restore.deviceAllocate( ident => chid,
                              DBGPLSQL: 31 TEXTNOD = node => node,
                              DBGPLSQL: 32 PRMVAL = type=>'SBT_TAPE',dupcnt=>1
                              DBGPLSQL: 33 TEXTNOD = );
                              DBGPLSQL: 34 TEXTNOD = if kbytes is null then
                              DBGPLSQL: 35 TEXTNOD = maxsize := sys.dbms_backup_restore.deviceQuery
                              DBGPLSQL: 36 TEXTNOD = (sys.dbms_backup_restore.DEVICEQUERY_MAXSIZE);
                              DBGPLSQL: 37 TEXTNOD = else
                              DBGPLSQL: 38 TEXTNOD = maxsize := kbytes;
                              DBGPLSQL: 39 TEXTNOD = end if;
                              DBGPLSQL: 40 TEXTNOD = if maxsize > 0 then
                              DBGPLSQL: 41 TEXTNOD = sys.dbms_backup_restore.setlimit
                              DBGPLSQL: 42 TEXTNOD = (sys.dbms_backup_restore.kbytes, maxsize);
                              DBGPLSQL: 43 TEXTNOD = end if;
                              DBGPLSQL: 44 TEXTNOD = krmicd.setChannelInfo
                              DBGPLSQL: 45 TEXTNOD = (devtype,
                              DBGPLSQL: 46 TEXTNOD = node,
                              DBGPLSQL: 47 TEXTNOD = maxsize,
                              DBGPLSQL: 48 TEXTNOD = sys.dbms_backup_restore.deviceQuery
                              DBGPLSQL: 49 TEXTNOD = (sys.dbms_backup_restore.DEVICEQUERY_PROXY),
                              DBGPLSQL: 50 TEXTNOD = sys.dbms_backup_restore.deviceQuery
                              DBGPLSQL: 51 TEXTNOD = (sys.dbms_backup_restore.DEVICEQUERY_MAXPROXY));
                              DBGPLSQL: 52 TEXTNOD = if parallel is not null then
                              DBGPLSQL: 53 TEXTNOD = sys.dbms_backup_restore.setlimit
                              DBGPLSQL: 54 TEXTNOD = (sys.dbms_backup_restore.parallel, parallel);
                              DBGPLSQL: 55 TEXTNOD = end if;
                              DBGPLSQL: 56 TEXTNOD = if readrate is not null then
                              DBGPLSQL: 57 TEXTNOD = sys.dbms_backup_restore.setlimit
                              DBGPLSQL: 58 TEXTNOD = (sys.dbms_backup_restore.readrate, readrate);
                              DBGPLSQL: 59 TEXTNOD = end if;
                              DBGPLSQL: 60 TEXTNOD = if rate is not null then
                              DBGPLSQL: 61 TEXTNOD = sys.dbms_backup_restore.setlimit
                              DBGPLSQL: 62 TEXTNOD = (sys.dbms_backup_restore.max_read_kbytes, rate);
                              DBGPLSQL: 63 TEXTNOD = end if;
                              DBGPLSQL: 64 TEXTNOD = if sendcmd is not null then
                              DBGPLSQL: 65 TEXTNOD = sys.dbms_backup_restore.devicecommand(sendcmd, NULL);
                              DBGPLSQL: 66 TEXTNOD = end if;
                              DBGPLSQL: 67 TEXTNOD = krmicd.writeMsg(8030, chid);
                              DBGPLSQL: 68 TEXTNOD = krmicd.getInstance(instname, israc);
                              DBGPLSQL: 69 TEXTNOD = if (israc) then
                              DBGPLSQL: 70 TEXTNOD = krmicd.writeMsg(8605, chid, to_char(krmicd.getSid),
                              DBGPLSQL: 71 TEXTNOD = to_char(instname), devtype);
                              DBGPLSQL: 72 TEXTNOD = else
                              DBGPLSQL: 73 TEXTNOD = krmicd.writeMsg(8500, chid, to_char(krmicd.getSid), devtype);
                              DBGPLSQL: 74 TEXTNOD = end if;
                              DBGPLSQL: 75 TEXTNOD = vendor := sys.dbms_backup_restore.deviceQuery
                              DBGPLSQL: 76 TEXTNOD = (sys.dbms_backup_restore.DEVICEQUERY_VENDOR);
                              DBGPLSQL: 77 TEXTNOD = if vendor is not null then
                              DBGPLSQL: 78 TEXTNOD = krmicd.writemsg(8526, chid, vendor);
                              DBGPLSQL: 79 TEXTNOD = end if;
                              DBGPLSQL: 80 TEXTNOD = end;
                              DBGMISC: executing command allocate [14:12:41.732]
                              DBGRPC: krmxr - entering
                              DBGRPC: krmxpoq - returning rpc_number: 1 with status: FINISHED70 for channel default
                              DBGRPC: krmxr - channel default has rpc_count: 1
                              DBGRPC: ENTERED krmqgns
                              DBGRPC: krmqgns: looking for work for channel default (krmqgns)
                              DBGRPC: krmqgns: commands remaining to be executed: (krmqgns)
                              DBGRPC: CMD type=allocate cmdid=1 status=NOT STARTED
                              DBGRPC: 1 STEPstepid=1 cmdid=1 status=NOT STARTED chid=t1
                              DBGRPC: krmxcc - entering
                              DBGRPC: krmxcc - creating context for channel No-chid
                              DBGMISC: ENTERED krmksimronly [14:12:41.785]
                              DBGMISC: EXITED krmksimronly [14:12:41.786] elapsed time [00:00:00:00.000]
                              DBGRPC: krmxcc - seting up for out-of-band
                              DBGRPC: krmxpos - setting up channel No-chid
                              DBGRPC: krmxpos - channel No-chid attached to target polling channel
                              DBGRPC: krmxcc - using default sga_heap_size of 16777216
                              DBGRPC: krmxcc - created context for channel No-chid
                              DBGMISC: krmqopen: opening new channel context for channel t1, instid 1 [14:12:41.791]
                              DBGRPC: krmxcr - channel t1 resetted
                              DBGRPC: krmqgns: no work found for channel default (krmqgns)
                              DBGRPC: (krmqgns)
                              DBGRPC: EXITED krmqgns with status 1
                              DBGRPC: ENTERED krmqgns
                              DBGRPC: krmqgns: looking for work for channel t1 (krmqgns)
                              DBGRPC: krmqgns: commands remaining to be executed: (krmqgns)
                              DBGRPC: CMD type=allocate cmdid=1 status=NOT STARTED
                              DBGRPC: 1 STEPstepid=1 cmdid=1 status=NOT STARTED chid=t1
                              DBGRPC: krmqgns: channel t1 assigned step 1 (krmqgns)
                              DBGRPC: (krmqgns)
                              DBGRPC: EXITED krmqgns with status 0
                              DBGRPC: krmxcis - channel t1, calling pcicmp
                              DBGRPC: krmxr - channel t1 calling peicnt
                              DBGRPC: krmxrpc - channel t1, error 3113 received for rpc 1 before receiving 3123
                              DBGRPC: krmxr - channel t1 returned from peicnt
                              DBGRPC: krmxr - channel t1 has disconnected (step_60)
                              DBGRPC: krmxr - exiting with 3
                              DBGMISC: krmqexe: unhandled exception on channel t1 [14:12:41.952]
                              DBGMISC: ENTERED krmkjcl [14:12:41.952]
                              • 12. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
                                mseberg
                                Unfortunately all this does is confirm this issue is caused by having no tape channel.

                                This error is kind of a bear :

                                krmqexe: unhandled exception on channel t1


                                Until the cause of this is found I believe everything that happens after is bogus.

                                Might ask the media vendor for input.

                                Best Regards

                                mseberg
                                • 13. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
                                  9233598
                                  Alert log has nothing specific. all normal messages.
                                  • 14. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
                                    9233598
                                    Is there a way to check the rman tape channel working or not?
                                    1 2 Previous Next