I don't know the real restriction. But i have a suggestion to avoid it. Check if you can use this dsmc archive -archmc=ORACLE_DIARIO -desc="TST11 OFFLINE ORACLE_DIARIO 20010216.153447" /oracle/rdbms/8.0.5/dbs/initTST11.ora '/TST11/*/*.dbf' The single quotes inhibits the shell to interpret the wildcards. So you can archive a lot of files in a single dsmc-command. You must check if my specification meets your requirements: are all files includet you want to back up, but not any other file? Sergio Cherchyk schrieb: > > Hi everybody! > > I'm trying to backup ORACLE databases using a script that uses an > ARCHIVE command to which a list of files to back up is given, so that > the final command is something like this: > > dsmc archive -archmc=ORACLE_DIARIO -desc="TST11 OFFLINE ORACLE_DIARIO > 20010216.153447" /oracle/rdbms/8.0.5/dbs/initTST11.ora > /TST11/dbs/system01.dbf /TST11/data/ajes_data.dbf > /TST11/data/amul_data.dbf /TST11/index/amul_ind.dbf > /TST11/rollback/rbs.dbf /TST11/temporary/temporary.dbf > /TST11/dbs/user.dbf /TST11/index/ajes_ind.dbf /TST11/data/eul_data.dbf > /TST11/data/eft_data.dbf /TST11/index/eft_ind.dbf > /TST11/data/cheques_data.dbf /TST11/index/cheques_ind.dbf > /TST11/redologs1/log3a.dbf /TST11/redologs2/log2b.dbf > /TST11/redologs1/log1a.dbf /TST11/redologs1/ctrl1.dbf > /TST11/redologs2/ctrl2.dbf /TST11/redologs1/ctrl3.dbf > /TST11/dbs/cfstby.dbf > > The error message that I get after this command is issued is: > > ANS1102E Excessive number of command line arguments passed to the > program! > ANS1133W An expression might contain a wildcard not enclosed in quotes > > Not seeing any wildcards and not finding a limit in the number of > parameters to be passed to an ARCHIVE command, I thought that it should > have failed because an exesive number of characters in the command line. > TSM specifies 256 character as a maximun limit, so it appeared natural > to me that this command doesn't work. > > However this, the following comman DOES work, even if it is largely > superior to 256 characters in length: > > dsmc archive -archmc=ORACLE_DIARIO -desc="TST1 OFFLINE ORACLE_DIARIO > 20010216.152135" /oracle/rdbms/7.3.4/dbs/initTST1.ora > /TST1/dbs/system01.dbf /TST1/dbs/user.dbf /TST1/data/data.dbf > /TST1/rollback/rbs.dbf /TST1/temporary/temporary.dbf /TST1/index/ind.dbf > /TST1/redologs1/log1a.dbf /TST1/redologs2/log1b.dbf > /TST1/redologs2/log2b.dbf /TST1/redologs2/log2a.dbf > /TST1/redologs1/log3a.dbf /TST1/redologs2/log3b.dbf > /TST1/redologs2/log4b.dbf /TST1/redologs2/log4a.dbf /TST1/dbs/ctrl1.dbf > /TST1/redologs1/ctrl2.dbf /TST1/redologs2/ctrl3.dbf /TST1/dbs/cfstby.dbf > /TST1/archivelog > > Does anyone know which is the real restriction that I'm not respecting > in the first example? > > The client is TSM 3.7.2 in an AIX 4.3.2 > > Thanks in advance > -- > -------------------------------------------- > Sergio R. Cherchyk > Arquitectura Tecnológica - Midrange > Banco Río de la Plata S.A. - Grupo BSCH > Mire 480, 2do piso - 1036 Cap. Fed. > Argentina > Tel. (054)-11-4341-1643 > Fax. (054)-11-4341-1264 > -------------------------------------------- -- Mit freundlichen Grüßen Bernhard Unold
begin:vcard n:Unold;Bernhard tel;work:+49 7071/29-80130 x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Bernhard Unold end:vcard
