dsmc h 30 gives the answer: ANS1081E Invalid search file specification 'string' entered. Explanation: You entered a file specification or search string that contains incorrect characters or contains wildcard characters in the drive specification or file system name. System Action: Processing stopped. User Response: Enter a correct file specification as described in the appropriate Using the Backup-Archive Client book for the particular operating system. 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. 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
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
