Re: RMAN with TSM anyone ?

Hi, we saw that the "ENV" directive within the rman script is very
important, we are running a little bit older versions but mayby this still
helps :

Here is a example how I do a full backup:

--------------------------------------------------------- SHELL SCRIPT (
COMMANDLINE)  BEGIN
COMMANDLINE)  BEGIN
------------------------------------------------------------------------
rman target internal/passwd@TARGET rcvcat rman/passwd@RMANDB cmdfile
rman target internal/passwd@TARGET rcvcat rman/passwd@RMANDB cmdfile
Filename_of_RMANSCRIPT

--------------------------------------------------------- SHELL SCRIPT END
---------------------------------------------------------------------------
---------------------------------------------------------------------------
----------------------------------------------------------- RMAN SCRIPT
----------------------------------------------------------- RMAN SCRIPT
BEGIN
BEGIN
------------------------------------------------------------------------
run
run
{
allocate channel t1 type 'sbt_tape' parms 
'ENV=(DSMI_ORC_CONFIG=/usr/lpp/adsm/bin/dsm.opt,
 DSMO_AVG_SIZE=1024, DSMO_NODE=EURO, DSMO_PSWDPATH=/usr/lpp/adsm/bin, 
DSMO_AVG_SIZE=5, DSMO_FS=adsmeuro)';

sql 'alter system archive log current';

backup
     incremental level =0
     format 'full_%s_%p_%d_%t'
     (database include current controlfile);
release channel t1;

allocate channel t3 type 'sbt_tape' parms 
'ENV=(DSMI_ORC_CONFIG=/usr/lpp/adsm/bin/dsm.opt, DSMO_AVG_SIZE=1024, 
DSMO_NODE=EURO,
DSMO_PSWDPATH=/usr/lpp/adsm/bin, DSMO_AVG_SIZE=5, DSMO_FS=adsmeuro)';

backup
     format 'archlog_%s_%p_%d_%t'
     (archivelog all filesperset = 100 delete input);
release channel t3;
}
----------------------------------------------------------- RMAN SCRIPT END  
------------------------------------------------------------------------
Hope this helps
Hope this helps

herfried




Stan Vernaillen <stvernaillen AT GE.COKECCE DOT COM>@VM.MARIST.EDU> on 
30.08.2001
15:43:34

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:  RMAN with TSM anyone ?


All,

Can someone send me an example of a simple RMAN script for use with TSM.

We run AIX 4.3.3, Oracle 8 and TSM client 3.7.2, so if someone has a
      similar setup, great, but anything wuld help I guess.







We installed  the TDP for oracle recently, but seem not able to do RMAN
      backups with TSM, the backup/archive client is ok.

If the message below sounds familiar to someone please let me know.


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19506: failed to create sequential
file, name="df_EDILIVE_23_1", parms=""
ORA-27007: failed to open file
IBM AIX RISC System/6000 Error: 2400: System call error number 2400.

Additional information: 7111
Additional information: 1
ORA-19511: SBT error = 7111, errno = 2400, sbtinit: system error
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

Recovery Manager complete.


Stan






****************************************************************************

The information contained in this transmission, which may be
confidential and proprietary, is only for the intended recipients.
Unauthorized use is strictly prohibited. If you receive this
transmission in error, please notify me immediately by telephone
or electronic mail and confirm that you deleted this transmission
and the reply from your electronic mail system.
****************************************************************************