This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jan 11, 2013 3:56 PM by 9233598 RSS

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

9233598 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    but this controlfile autobackup is from tape.
  • 5. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
    user569151 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Alert log has nothing specific. all normal messages.
  • 14. Re: RMAN-03009: failure of allocate command on t1 channel, ORA-03113
    9233598 Newbie
    Currently Being Moderated
    Is there a way to check the rman tape channel working or not?
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points