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 <Bernhard.Unold AT med.uni-tuebingen DOT de>
> > >
> > >   Bernhard Unold
> > >     <Bernhard.Unold AT med.uni-tuebingen DOT de>
> > >     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 <Bernhard.Unold AT med.uni-tuebingen DOT de>
>
>   Bernhard Unold
>     <Bernhard.Unold AT med.uni-tuebingen DOT de>
>     Work: +49 7071/29-80130
>   Additional Information:
>   Last Name    Unold
>   First Name   Bernhard
>   Version      2.1

--
--------------------------------------------
--------------------------------------------
Sergio R. Cherchyk
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
--------------------------------------------
=======================================================================