onarchive question -- help!

onarchive question -- help!

Post by Robert Dona » Sun, 31 Dec 1899 09:00:00



How can I use onarchive with just any (non-volume) tape?  I would like
to use onarchive to do my backups but can not find a way to tell it to
overwrite whatever tape I've given it, not to let it prompt me for an
appropriate volume.  

This is very simple with ontape, but not so simple with onarchive.  I
just want (for simple servers) a Monday-Friday tape that I can replace
when necessary without re-defining it as a volume.

Help.

Thanks,
Rob.
--
_________________________________
| Robert Donat                  |

| http://sashimi.wwa.com/~donat |
|_______________________________|

 
 
 

onarchive question -- help!

Post by Neil Trub » Sun, 31 Dec 1899 09:00:00


I'm not at work now and don't have my manuals, and don't fully
appreciate your problem.  But I use onarchive within a script which runs
at 0040 each day when I am nost certainly not present!  Have you looked

at onautovop, and the _vop suffix for onarchive volume sets which, from
memory, are the relevant sections?

Neil Truby

Chase Manhattan Bank

Bournemouth, UK

 
 
 

onarchive question -- help!

Post by Curtis Prest » Sun, 31 Dec 1899 09:00:00



the following was written: > How can I use onarchive with just any
(non-volume) tape?  I would > like

Quote:> to use onarchive to do my backups but can not find a way to tell it
> to
> overwrite whatever tape I've given it, not to let it prompt me for an
> appropriate volume.  

    You've been bitten by the ONarchive bug.  I will answer your
question in two ways.  First, Informix either already has, or will very
soon, drop support for Onarchive.  They bought it from a third party,
and it has never lived up to what they (or us) wanted it to be.  If you
want the simplicity of ontape, use ontape.  Why are you using onarchive?
 I can tell you that it does not let me sleep at night.  We spent months
developing an ONarchive setup.  It worked great, with one exception --
our three restore tests didn't work.

    Use ontape, my friend.  If you need all the volume management and
multi-threaded stuff, Informix now has 'onbar.'   It's supposed to be as
easy as ontape, but it is designed to work with a commercial backup
utility.

Quote:

> This is very simple with ontape, but not so simple with onarchive. I
> just want (for simple servers) a Monday-Friday tape that I can
> replace
> when necessary without re-defining it as a volume.

--
I am currently writing a book for O'Reilly Publishing about enterprise
backup and recovery, and would really appreciate hearing anything
you would like to ask me or tell me.  If you have problems with
something, then others will as well.  Can you think of anything
else that should go in such a book?
 
 
 

onarchive question -- help!

Post by Neil Trub » Sun, 31 Dec 1899 09:00:00


Quote:> I am currently writing a book for O'Reilly Publishing about enterprise
> backup and recovery, and would really appreciate hearing anything
> you would like to ask me or tell me.  If you have problems with
> something, then others will as well.  Can you think of anything
> else that should go in such a book?

Well, i can give you my opinion on a couple of aspects of Informix
back-up/recovery functionality.  It may be that I have missed something,
so I'm pleased to stand corrected:

1.      (I have a lot of trouble explaining this point to Informix pros.)  I
don't really understand why OnLine insists that you have the original
paths available for a restore.  It should be possible to do a restore as
follows; if the chunk(s) for the rootdbs, or any chunk for any other
dbspace, is unavailable then the user should be prompted for the name of
a valid alternative chunk location.  

2.      Doing a "strings" on an archive will allow you to pull off the
$ONCONFIG settings applicable at the time of the archive.  But so far as
I am aware, the timestamp of the archive is not available.  This could
be very useful.

3.      ontape should permit the user to specify an alternate location to
$TAPEDEV for the location of the archive (for those of us who archive to
disk).

Regards

Neil Truby
Chase Manhattan
Bournemouth, UK

 
 
 

onarchive question -- help!

Post by David William » Sun, 31 Dec 1899 09:00:00




Quote:>> I am currently writing a book for O'Reilly Publishing about enterprise
>> backup and recovery, and would really appreciate hearing anything
>> you would like to ask me or tell me.  If you have problems with
>> something, then others will as well.  Can you think of anything
>> else that should go in such a book?

>Well, i can give you my opinion on a couple of aspects of Informix
>back-up/recovery functionality.  It may be that I have missed something,
>so I'm pleased to stand corrected:

>1.     (I have a lot of trouble explaining this point to Informix pros.)  I
>don't really understand why OnLine insists that you have the original
>paths available for a restore.  It should be possible to do a restore as
>follows; if the chunk(s) for the rootdbs, or any chunk for any other
>dbspace, is unavailable then the user should be prompted for the name of
>a valid alternative chunk location.

 the original paths should be links to the actual devices since when you
replace a disk the device name may well change.

Quote:

>2.     Doing a "strings" on an archive will allow you to pull off the
>$ONCONFIG settings applicable at the time of the archive.  But so far as
>I am aware, the timestamp of the archive is not available.  This could
>be very useful.

  When you restore using ontape it first reads the tape and displays a
header which includes archive level (0,1,2) and date/time taken,
  You can then say say y/n as to whether or not you want to retore.

Quote:>3.     ontape should permit the user to specify an alternate location to
>$TAPEDEV for the location of the archive (for those of us who archive to
>disk).

  Again use links.

Quote:>Regards

>Neil Truby
>Chase Manhattan
>Bournemouth, UK

--
David Williams
 
 
 

onarchive question -- help!

Post by Paul van Wegen Es » Sun, 31 Dec 1899 09:00:00



>> I am currently writing a book for O'Reilly Publishing about enterprise
>> backup and recovery, and would really appreciate hearing anything
>> you would like to ask me or tell me.  If you have problems with
>> something, then others will as well.  Can you think of anything
>> else that should go in such a book?
>Well, i can give you my opinion on a couple of aspects of Informix
>back-up/recovery functionality.  It may be that I have missed something,
>so I'm pleased to stand corrected:
>1.  (I have a lot of trouble explaining this point to Informix pros.)  I
>don't really understand why OnLine insists that you have the original
>paths available for a restore.  It should be possible to do a restore as
>follows; if the chunk(s) for the rootdbs, or any chunk for any other
>dbspace, is unavailable then the user should be prompted for the name of
>a valid alternative chunk location.  

This is why informix recommends using a link when specifing chunks.
Changing the link changes the location of the chunk.

Quote:>2.  Doing a "strings" on an archive will allow you to pull off the
>$ONCONFIG settings applicable at the time of the archive.  But so far as
>I am aware, the timestamp of the archive is not available.  This could
>be very useful.
>3.  ontape should permit the user to specify an alternate location to
>$TAPEDEV for the location of the archive (for those of us who archive to
>disk).
>Regards
>Neil Truby
>Chase Manhattan
>Bournemouth, UK

-----------------------------------------------------------------------------

First State Computing Pty. Ltd.   | Phone: 061 2 2569887                      
Sydney. Australia.                | Fax:   061 2 2569727                      
-----------------------------------------------------------------------------
 
 
 

onarchive question -- help!

Post by Roger J. Alle » Sun, 31 Dec 1899 09:00:00



> > I am currently writing a book for O'Reilly Publishing about enterprise
> > backup and recovery, and would really appreciate hearing anything
> > you would like to ask me or tell me.  If you have problems with
> > something, then others will as well.  Can you think of anything
> > else that should go in such a book?
> Well, i can give you my opinion on a couple of aspects of Informix
> back-up/recovery functionality.  It may be that I have missed something,
> so I'm pleased to stand corrected:
> 1. (I have a lot of trouble explaining this point to Informix pros.)  I
> don't really understand why OnLine insists that you have the original
> paths available for a restore.  It should be possible to do a restore as
> follows; if the chunk(s) for the rootdbs, or any chunk for any other
> dbspace, is unavailable then the user should be prompted for the name of
> a valid alternative chunk location.  

Just create a link (or symbolic link) for the missing chunk path to the
path that you want it to really go to.  You should be able to plan this
before you start the restore.  The Online Administrator's Guide
recommends that instead of using the actual path, you use a link to it
when you add/create a chunk so that you can change the location with a
simple command.

[points 2 and 3 deleted cause I don't know or care]

--
Roger J. Allen                Rush-Presbyterian-St. Luke's Medical Center
System Administrator                                   Chicago,  IL   USA
Surgical Information Systems                       Voice:  (312)-942-4825

 
 
 

onarchive question -- help!

Post by Neil Trub » Sun, 31 Dec 1899 09:00:00




> > 1.    (I have a lot of trouble explaining this point to Informix pros.)  I
> > don't really understand why OnLine insists that you have the original
> > paths available for a restore.  It should be possible to do a restore as
> > follows; if the chunk(s) for the rootdbs, or any chunk for any other
> > dbspace, is unavailable then the user should be prompted for the name of
> > a valid alternative chunk location.

> Just create a link (or symbolic link) for the missing chunk path to the
> path that you want it to really go to.  You should be able to plan this
> before you start the restore.  The Online Administrator's Guide
> recommends that instead of using the actual path, you use a link to it
> when you add/create a chunk so that you can change the location with a
> simple command.

As I said, I have a lot of trouble explaining this point to Informix
pros.  I know that you CAN circumvent the requirement to have the
original paths available, but I don't think you should have to. THAT is
the point I was trying to get over.

Neil Truby

 
 
 

onarchive question -- help!

Post by Neil Trub » Sun, 31 Dec 1899 09:00:00


> Roger J. Allen                Rush-Presbyterian-St. Luke's Medical Center
> System Administrator                                   Chicago,  IL   USA
> Surgical Information Systems                       Voice:  (312)-942-4825



> > 1.    (I have a lot of trouble explaining this point to Informix pros.)  I
> > don't really understand why OnLine insists that you have the original
> > paths available for a restore.  It should be possible to do a restore as
> > follows; if the chunk(s) for the rootdbs, or any chunk for any other
> > dbspace, is unavailable then the user should be prompted for the name of
> > a valid alternative chunk location.

> Just create a link (or symbolic link) for the missing chunk path to the
> path that you want it to really go to.  You should be able to plan this
> before you start the restore.  The Online Administrator's Guide
> recommends that instead of using the actual path, you use a link to it
> when you add/create a chunk so that you can change the location with a
> simple command.

As I said, I have a lot of trouble explaining this point to Informix
pros.  I know that you CAN circumvent the requirement to have the
original paths available, but I don't think you should have to. THAT is
the point I was trying to get over.

Neil Truby

 
 
 

1. OnArchive questions

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

2. VB40 et VB50

3. onarchive question (fwd)

4. DTS library difference between SQL7 and SQL 2000

5. onarchive question

6. Please Help

7. online 7.22 onarchive questions -Reply

8. Stop sql server via command prompt

9. online 7.22 onarchive questions

10. Onarchive question

11. onarchive question

12. Onarchive, I need help