ADSM-L

Re: ARCHIVE command - length restrictions

2001-03-01 10:03:27
Subject: Re: ARCHIVE command - length restrictions
From: Sergio Cherchyk <scherchyk AT BANCORIO.COM DOT AR>
Date: Thu, 1 Mar 2001 12:05:34 -0300
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
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
--------------------------------------------
=======================================================================
<Prev in Thread] Current Thread [Next in Thread>