OnArchive questions
Posted in 1996
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 ?
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