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