Pavan DBA's Blog

The DBA Knowledge Store

RMAN no channel allocated for maintenance

Posted by Pavan DBA on December 23, 2010


Many a times, when you issue some commands in RMAN you may receive following error

RMAN> run
{
allocate channel c1 device type sbt_tape;
delete noprompt obsolete;
}

released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 12/23/2010 10:57:21
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

Cause:
This is because of command change across versions especially between 9i and 10g. The command which we used above is for 10g and will not work in 9i.

Solution:
Use the below way to use rman commands in 9i

RMAN> allocate channel for maintenance type sbt_tape;

allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=1059 devtype=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: VERITAS NetBackup for Oracle – Release 6.0 (2008012304)

3 Responses to “RMAN no channel allocated for maintenance”

  1. shashi said

    can we can rman backup in standby setup while database is in recovery mode?

  2. Mohanty said

    To see the details on the error stack, create a RMAN trace file,like following

    rman catalog rmancatalog/password123@dbname.world target / trace=/tmp/rman1.trc

    then

    debug all ;

    exit

    Check the trace file rman1.trc file at /tmp/

    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

    Regards,
    Mohanty

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: