Roy,

Yup, no issues.

---RMAN SCRIPT
run {
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=tdpo_dir/ORACLE_tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=tdpo_dir/ORACLE_tdpo.opt)';
allocate channel t3 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=tdpo_dir/ORACLE_tdpo.opt)';
set command id to 'rmanbkp';
...
release channel t1;
release channel t2;
release channel t3;
}

....

---RMAN LOG
...
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t2

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t3



-----Original Message-----
From: Marquez, Chris
To: 'Ferguson, Roy '; 'LazyDBA.com Discussion '
Sent: 9/30/2003 4:03 PM
Subject: RE: RMAN not releasing channel

Roy,

I do this with my Tivoli-RMAN-Oracle scripts and have not noticed any
issues. I will check my RMAN log files to be sure all channels are
released, but I always just exit RMAN at the end of my backup.

I do know that when I moved from Legato to Tivoli, with Tivoli I *HAD
TO& allocate all channels first then do *ALL* my backup syntax, the
release.
With Legato I would allocate, release....allocate, release....allocate,
release... several time throughout my script...no go with Tivoli-TDPO.

run {
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=tdpo_dir/ORACLE_tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=tdpo_dir/ORACLE_tdpo.opt)';
allocate channel t3 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=tdpo_dir/ORACLE_tdpo.opt)';
allocate channel t4 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=tdpo_dir/ORACLE_tdpo.opt)';

set command id to 'rmanbkp';

backup archivelog until time 'sysdate-0' all format
'%d_arch_%u_%p_%c.bkp' delete input;

backup database include current controlfile format
'%d_%u_%p_%c.bkp';

release channel t1;
release channel t2;
release channel t3;
release channel t4;
}

hth

Chris Marquez
Oracle DBA

-----Original Message-----
From: Ferguson, Roy
To: LazyDBA.com Discussion
Sent: 9/30/2003 3:44 PM
Subject: RMAN not releasing channel

I am experiencing a problem with RMAN backing up to tape (sbt_tape -
Tivoli). I allocate 2 channels. After backing up, the first channel is
released but the second one does not. I have to manually exit from the
RMAN backup for it to complete successfully.

Log output:
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1

RMAN-03022: compiling command: release
RMAN-03023: executing command: release

Question: Is there a statement or command to force the release of a
channel so I don't have to do it manually? or does anyone know of a way
to resolve this?

Thanks in advance,

Roy

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page