Perhaps you get a better result by using a backslash to mask the asterisk. We are using in our Oracle-save-script: dsmc archive -servername=$ADSMSERV -archmc=$ADSMCLASS -DELETEFILES -verbose /bigspace/\*$ORACLE_SID* >> $ORACLEPROT and it works. The script is not written by me, but as far i know all important datasets are asked from oracle and copied to the "bigspace" directory before. adsmserv is the name of our adsmserver adsmclass ist the name of our mgmtclass oracle_sid is the name of the database (for example orc1) oracleprot is a dataset to keep the output from dsmc I remember that after beeing testet successfully there was the same problem if it went to production. With the \ masking the * this problem didn't occour again and all worked fine even with 100 files in one command. Sergio Cherchyk schrieb: > > Hi Bernhard. > > > Any idea? Perhaps tsm doesn't want to search several files systems. You > > can get the names of the filesystems with a simple df. > > So perhaps you can archive '/TST11/data/*.dbf /TST11/data/*.dbf .....' > > and so on if /TST11/data and /TST11/data/ are filesystems. > > It's not the case. TST1 is a filesystem itself. Here you have the output of df - k | > grep -w TST1: > > /dev/TST1 983040 420800 58% 778 1% /TST1 > > The problem seems to be related to the single quotes. I tried several combinations > (including '/TST11/data/*.dbf /TST11/data/*.dbf .....') and nothing works.The only > way that TSM accepts wildcards is by using double quotes, and in this case I also > have problems in many cases. The best approach that I found is to backup /TST1/ with > subdir=yes, but I'm archiving a lot of garbage in a few cases where there are lots > of "undesiderable" files in the file system. It really would be useful to me to find > out how to backup /TST1/*/*.dbf, but I couldn't do it so far. > > > From another > > answer i know that you can do up to 20 specifications in one > > tsm-command. > > > > Sergio Cherchyk schrieb: > > > > > > Bernhard. > > > Thanks for your reply. It seems to fit our requirements, if I manage myself to > > > do it work properly. > > > Unfortunately, I was busy these days so I didn't see your message until > > > yesterday. > > > I tested the command with the sintax that you gave me (cut & paste) but I > > > cannot have it running as I expect. > > > Instead, I have an error message: > > > > > > ANS1081E Invalid search file specification '/TST11/*/*.dbf' entered > > > > > > I'm running a 3.7.2 client and a 3.7.2 server, both in AIX machines. > > > What can I be doing wrong? > > > > > > Bernhard Unold wrote: > > > > > > > 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 > > > > > > > > ------------------------------------------------------------------------ > > > > > > > > Bernhard Unold <[EMAIL PROTECTED]> > > > > > > > > Bernhard Unold > > > > <[EMAIL PROTECTED]> > > > > Work: +49 7071/29-80130 > > > > Additional Information: > > > > Last Name Unold > > > > First Name Bernhard > > > > Version 2.1 > > > > > > -- > > > -------------------------------------------- > > > 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 > > > > ------------------------------------------------------------------------ > > > > Bernhard Unold <[EMAIL PROTECTED]> > > > > Bernhard Unold > > <[EMAIL PROTECTED]> > > Work: +49 7071/29-80130 > > Additional Information: > > Last Name Unold > > First Name Bernhard > > Version 2.1 > > -- > -------------------------------------------- > 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
