Back up logical log in file IDS 10
Posted in 2010
Ali wanted ontape logical-log backups written to a file on IDS 10 (AIX); `ontape -a -t STDIO > logicallog` didn't work. Art suggested setting LTAPEDEV to a file, or to a directory so ontape auto-names files (e.g. host_servernum_Lognnnn), or using `ontape -a -t filepath`. A block-size error followed, and Art advised raising LTAPEBLK (64, 128, 256...) until accepted. Ali said the directory option appeared to be 11.x-only, and instead worked around it with a ksh script creating a timestamped file symlinked to the LTAPEDEV path and piping keystrokes to `ontape -a`; Karl confirmed a similar echo-piped approach under 9.4. No definitive single fix is recorded.
Topics: Backup & Restore, Logging & Checkpoints
Hi,
Can anyone give me an idea to take logical log backup in file?
IDS 10 on AIX
I can take a level 0 backup by this command : ontape -s -L 0 0t STDIO > level0
but this command didn't work : ontape -a -t STDIO > logicallog
Regards
Ali
Several choices:
1. Set LTAPEDEV to a file
2. SET LTAPEDEV to a directory/filesystem and ontape wil lname the back
up files according to their contents and the server and host.
3. Use: ontape -a -t filepath
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Mon, Nov 22, 2010 at 8:53 PM, ALI SHAHNAZI <ali@datasync.com.au> wrote:
> Hi,
> Can anyone give me an idea to take logical log backup in file?
> IDS 10 on AIX
> I can take a level 0 backup by this command : ontape -s -L 0 0t STDIO >
> level0
> but this command didn't work : ontape -a -t STDIO > logicallog
> Regards
> Ali
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf3054a5dfc00e340495aeb3ac
Thanks Art
But I got this error:
Performing automatic backup of logical logs.
The tape block size must be greater than the system page size
and a multiple of the system page size.InvalidLogbackup failed - function get
tranport buffer size failed code -1 errno 0
Program over.
My setting is :
LTAPEDEV /apps/db/llogs/log1 # a filename
LTAPEBLK 32
LTAPESIZE 0
So, try LTAPEBLK set to 64, 128, 256, 512, 1024, etc until you find a
setting that works.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Mon, Nov 22, 2010 at 9:12 PM, ALI SHAHNAZI <ali@datasync.com.au> wrote:
> Thanks Art
>
> But I got this error:
>
> Performing automatic backup of logical logs.
> The tape block size must be greater than the system page size
> and a multiple of the system page size.InvalidLogbackup failed - function
> get
> tranport buffer size failed code -1 errno 0
>
> Program over.
>
> My setting is :
> LTAPEDEV /apps/db/llogs/log1 # a filename
> LTAPEBLK 32
> LTAPESIZE 0>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf3054a64ded9c380495af212f
Thanks Art
I can't use "ontape -a -t ... "
I wrote this script :
#!/usr/bin/ksh
. /home/informix/env
backup_file=/apps/${INFORMIXSERVER}/llogs/${INFORMIXSERVER}_LLog_`date
+"%Y%m%d%H%%M%S`
touch ${backup_file}
chmod 660 ${backup_file}
ln -s ${backup_file} /apps/llogs/lloglink
echo '\\\\r n \\\\r' | ontape -a
gzip ${backup_file}
rm /apps/llogs/lloglink
and also set
LOGTAPEDEV /apps/llogs/lloglink
Regards
Ali
IF you set LTAPEDEV to the /apps/llogs directory, then ontape will manage
the filenames for you naming each logical log archive file something like:
<hostname>_<servernum>_Log<lognum>
so:
myhost_10_Log0000005335
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Tue, Nov 23, 2010 at 2:38 AM, ALI SHAHNAZI <ali@datasync.com.au> wrote:
> Thanks Art
> I can't use "ontape -a -t ... "
> I wrote this script :
>
> #!/usr/bin/ksh
> .. /home/informix/env
> backup_file=/apps/${INFORMIXSERVER}/llogs/${INFORMIXSERVER}_LLog_`date
> +"%Y%m%d%H%%M%S`
> touch ${backup_file}
> chmod 660 ${backup_file}
> ln -s ${backup_file} /apps/llogs/lloglink
> echo '\\\\r n \\\\r' | ontape -a
> gzip ${backup_file}
> rm /apps/llogs/lloglink
>
> and also set
> LOGTAPEDEV /apps/llogs/lloglink
>
> Regards
> Ali
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf3054a64d5ce7360495b67e09
I think this works for version 11 not 10. I have checked in this environment but it didn't work.
I have done this type of thing before under 9.4 and use this command
for the backup
#back up all logs
# \\
is for press enter y is for back latest log
echo '\\
y' | ontape -a