LLOGS backup
Posted in 2007
Topics: Backup & Restore, Logging & Checkpoints, Versions, Editions & End-of-Life
I have a client who is running IDS 7.31 UD6 and is doing a level 0 backup each
night, using:
ontape -s -L0
The issue is that the logical logs do not move to a 'B' status. I suggested
running:
ontape -s -a -L0
with no success. Currently they are manually managing the logs; is there a way
to do this with the nightly backup?
TIA
Hi:
backup for logs, you can execute the following thing:
1. Continuous backup of logical logs
$ ontape -c
2. Automatic backup of logical logs
$ ontape -a
Bye
============================================================
Sintaxis ontape
usage:
{ -a |
-c |
-l |
-p [-e] [-rename {-f <filename> |
-p <old path> -o <old offset> -n <new path> -o <new
offset>...}]
-S |
-r [-rename {-f <filename> |
-p <old path> -o <old offset> -n <new path> -o <new
offset>...}]
[-D DBspace_list] |
-s [[-L archive_level][-F]] [-A database_list] [-B database_list]
[-N database_list] [-U database_list] }
-a Automatic backup of logical logs
-c Continuous backup of logical logs
-l Logical restore
-p [-e] Physical restore (-e for external physical restore)
-r Full restore DBspaces/BLOBspaces as listed
-s Archive full system
-A set the following database(s) to ansi logging
-B set the following database(s) to buffered logging
-F Backup without updating archive information (useful for HDR, cloning
etc.)
-N set the following database(s) to no logging
-S Salvage logical logs only
-U set the following database(s) to unbuffered logging
-rename rename chunks during cold restore
with -rename options :
-f <filename> pathname of file containing list of mapped
chunk pathnames and offsets
-p old pathname of chunk
-o old offset of chunk
-n new pathname of chunk
-o new offset of chunk
The freedom of Linux ... The power of Informix
>From: "DAN HESS" <dan.hess@sungardbi-tech.com>
>Reply-To: ids@iiug.org
>To: ids@iiug.org
>Subject: LLOGS backup [9055]
>Date: Tue, 1 May 2007 16:56:45 -0400 (EDT)
>
>I have a client who is running IDS 7.31 UD6 and is doing a level 0 backup
>each
>night, using:
>
>ontape -s -L0>
>The issue is that the logical logs do not move to a 'B' status. I suggested
>running:
>
>ontape -s -a -L0>
>with no success. Currently they are manually managing the logs; is there a
>way
>to do this with the nightly backup?
>
>TIA
>
>
>*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
Consigue aquí las mejores y mas recientes ofertas de trabajo en América
Latina y USA: http://latam.msn.com/empleos/