RE: OnArchive questions
Posted in 1996
Eric,
I can help with Q1, see below..
On 22 April 1996, Eric Sze wrote...
>
> I have a few question about using OnArchive to backup SAP database.
> Hope anybody know the solution can help me to solve them.
>
> If I have setup volume set :LOGTAP with 3 tapes labelled LOGT1, LOGT2,
LOGT3.
> and DBTAP with 3 tapes labelled DBT1, DBT2, DBT3. All tape expiry date
is set
> to 1 day only.
> Everyday, I will use a DBTAP (archive database) tape and LOGTAP (logical
log)
> tape.
> my archive command: onarchive
'archive/dbspaceset=*/vset=DBTAP/apart/level=0'
> my backup command: onarchive
>
'backup/logfile/continuous/nocurrent/vset=LOGTAP/expiry_date=0001-00:00:00
'
>
> Q1. After all tapes in volume set DBTAP is used, the archive command
prompt me
> to define a new volume.
> How can I reuse the old tapes (eg. DBT1) instead of adding a new volume
to
> this volume set ?
>
You can reuse tapes by removing the requests that create them. Say for
example you create request 1, an archive onto tape DBT1, request 2 is an
archive onto tape DBT2 and request 3 is an archive onto tape DBT3. If you
"remove/request=1" using OnArchive you will free tape DBT1 for re-use.
May I ask why you are using the "apart" keyword on your archives?
Regards
Dave Harding
hardid02@bh.bbc.co.uk
(the message may not reflect the correct user, address etc)
> Q2. When I read the online.sapdev.id2.log message to monitor my backup
logical
> log command, I found that the backup can automatically start when a new
> logically log is created. However, it will not automatically backup
complete
> until I press ctrl+c. It seen different from ontape command 'ontape -c'.
> Is it normal ?
>
> Q3. According to SAP installation manual page 6-9 for the command
:arcvolum
> ".. to replace a missing volume which already appears in the catalog
list, you
> can simply enter the label of the volume you wish to replace."
> I tried, but I can't work. Although the label is entered, it seem to
redefine
> a new volume appended to the existing volume set ???
>
> Hardware :IBM RS/6000 AIX
> DataBase: SAP/R3 version 2.2E under Informix 6.0
>
> Hope anyone know the answer can email to me.
> Thanks a lot!
>
> EricSze
> ericsze@cuhk.edu.hk
>
>