Search Box

Google

Saturday, December 09, 2006

Moving logical logs backup to disk
All 6 messages in topic - view as tree
From: gsturkenb...@lic.co.nz - view profile
Date: Wed, Dec 6 2006 10:58 pm
Email: gsturkenb...@lic.co.nz


Hi,


Does anyone know how to redirect our logical logs backup from tape to
disk? We currently use a storage manager and onbar and a seperate server
with tape drive for this purpose. The sys admin guys want to retire the
seperate server with tape drive.


This is our configuration:
Operating System: Solaris 9
Database: Informix 7.30.UC2
Storage Manager:Solstice Backup 5.1 Turbo 10


Thanks
Gerry


Reply » Rate this post: Text for clearing space


From: darko - view profile
Date: Thurs, Dec 7 2006 9:33 am
Email: "darko"




- Hide quoted text -
- Show quoted text -

gsturkenb...@lic.co.nz wrote:
> Hi,

> Does anyone know how to redirect our logical logs backup from tape to
> disk? We currently use a storage manager and onbar and a seperate server
> with tape drive for this purpose. The sys admin guys want to retire the
> seperate server with tape drive.


> This is our configuration:
> Operating System: Solaris 9
> Database: Informix 7.30.UC2
> Storage Manager:Solstice Backup 5.1 Turbo 10


> Thanks
> Gerry



Does it mean that you will not have external storage manager any more?
Then you can use ISM (Informix Storage Manager) with OnBar, that is
bundled with IDS, without additional costs. It is some kind of Legato
Networker. It is fairly easy to set up to make backups on disks, as far
as I remember when I was playing with it.

(BTW: is Solstice Backup also a kind of Legato? If it is, it might be a
bit easier to adapt to ISM. But keep in mind that it is not possible to
use ISM and "full" Legato Networker on the same server, so that might
disqualify ISM if you want to have Solstice Backup on the same server).


You should upgrade your IDS version, if possible. I do not expect it is
supported these days.


Darko Krstic


Reply » Rate this post: Text for clearing space


From: Captain Pedantic - view profile
Date: Thurs, Dec 7 2006 10:52 am
Email: "Captain Pedantic"



"darko" wrote in message


news:1165476806.499806.171160@n67g2000cwd.googlegroups.com...


> gsturkenb...@lic.co.nz wrote:
>> Does anyone know how to redirect our logical logs backup from tape to
>> disk? We currently use a storage manager and onbar and a seperate server
>> with tape drive for this purpose. The sys admin guys want to retire the
>> seperate server with tape drive.


When did "retire" become a transitive verb?

Reply » Rate this post: Text for clearing space


From: Superboer - view profile
Date: Thurs, Dec 7 2006 3:55 pm
Email: "Superboer"

Hmmm... thin ice, looong time ago....

for ism you have


ISM_DATA_POOL ISMData


ISM_LOG_POOL ISMLogs


onconfig values where ISM_DATA_POOL points to the name of your pool
where dbspaces are sent to and ISM_LOG_POOL
points to the name of the where the logs are sent to.


if i recall correctly under solstice=legato??????? this is controled
using env vars.


NSR_DATA_POOL


NSR_LOG_POOL


So check your env for these.


create a pool which is disk and set the env var NSR_LOG_POOL to that
pool.


Superboer.


gsturkenb...@lic.co.nz schreef:



- Hide quoted text -
- Show quoted text -

> Hi,

> Does anyone know how to redirect our logical logs backup from tape to
> disk? We currently use a storage manager and onbar and a seperate server
> with tape drive for this purpose. The sys admin guys want to retire the
> seperate server with tape drive.


> This is our configuration:
> Operating System: Solaris 9
> Database: Informix 7.30.UC2
> Storage Manager:Solstice Backup 5.1 Turbo 10


> Thanks
> Gerry


> --=_alternative 0073330ACC25723C_=
> Content-Type: text/html
> X-Google-AttachSize: 756


>
Hi,
>

>
Does anyone know how to redirect our
> logical logs backup from tape to disk? We currently use a storage manager
> and onbar and a seperate server with tape drive for this purpose. The sys
> admin guys want to retire the seperate server with tape drive.

>

>
This is our configuration:
>
Operating System: Solaris 9
>
Database: Informix 7.30.UC2
>
Storage Manager:Solstice Backup  5.1
> Turbo 10

>

>
Thanks
>
Gerry

>

> --=_alternative 0073330ACC25723C_=--



Reply » Rate this post: Text for clearing space


From: Robert Seifert - view profile
Date: Thurs, Dec 7 2006 5:18 pm
Email: Robert Seifert


Gerry,

You mentioned that the sys admin guys at your site want to retire the
seperate server with tape drive.
Just for clarification, does this mean that this server also is the storage
manager server or is this just the configured backup target with tape
devices only?


If this is the last case, and you want to have the ability to switch from
tape to disk devices you could label new volumes on new volume pools on the
storage manager server, for example named as NSRINFDISKDATA or *LOGS. After
labeling new volumes using disk devices and assigned to one of created
volume pools as mentioned above, the switch from tape to disk devices by
changing the related env vars at storage manager client should work.


Then, at storage manager client (db host) site you may change the related
env vars from
e.g.(The following is for Legato, but as far as I remember Soltice might
have similiar env vars)


NSR_DATA_VOLUME_POOL=NSRINFDATA
NSR_LOG_VOLUME_POOL=NSRINFLOGS


to


NSR_DATA_VOLUME_POOL=NSRINFDISKDATA
NSR_LOG_VOLUME_POOL=NSRINFDISKLOGS


See also thread ' Logical log backups [7889]'.
Of course, this needs to be tested, also the restore.


HTH,


Robert


Robert Seifert
_________________________________________________________________
IBM Deutschland GmbH, Information Management Solutions, Software,
Informix Products, Advanced Support


Elite VAR support engineer
Development Support for IBM Informix Products on-site @ SAP
c/o SAP AG, -PS03-,Neurottstrasse 16, D-69190 Walldorf, Germany
_________________________________________________________________


informix-list-boun...@iiug.org wrote on 06.12.2006 21:58:17:



- Hide quoted text -
- Show quoted text -

> Hi,


> Does anyone know how to redirect our logical logs backup from tape
> to disk? We currently use a storage manager and onbar and a seperate
> server with tape drive for this purpose. The sys admin guys want to
> retire the seperate server with tape drive.


> This is our configuration:
> Operating System: Solaris 9
> Database: Informix 7.30.UC2
> Storage Manager:Solstice Backup 5.1 Turbo 10


> Thanks
> Gerry_______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list



Reply » Rate this post: Text for clearing space


From: gsturkenb...@lic.co.nz - view profile
Date: Fri, Dec 8 2006 1:02 am
Email: gsturkenb...@lic.co.nz


Hi Robert,


The storage manager backup client runs on the database server, the storage
manager backup server and tape run on a different server.


We actually want to get rid of the storage manager backup software and
just use informix to output the logs and database backups to disk.
They can then be backed up to tape from the disk copy.


We already do informix external backups to disk. We just need to backup
the logical logs to disk as well.


Thanks
Gerry


Robert Seifert
08/12/2006 04:18 a.m.


To
gsturkenb...@lic.co.nz
cc
informix-l...@iiug.org, informix-list-boun...@iiug.org
Subject
Re: Moving logical logs backup to disk


Gerry,


You mentioned that the sys admin guys at your site want to retire the
seperate server with tape drive.
Just for clarification, does this mean that this server also is the
storage
manager server or is this just the configured backup target with tape
devices only?


If this is the last case, and you want to have the ability to switch from
tape to disk devices you could label new volumes on new volume pools on
the
storage manager server, for example named as NSRINFDISKDATA or *LOGS.
After
labeling new volumes using disk devices and assigned to one of created
volume pools as mentioned above, the switch from tape to disk devices by
changing the related env vars at storage manager client should work.


Then, at storage manager client (db host) site you may change the related
env vars from
e.g.(The following is for Legato, but as far as I remember Soltice might
have similiar env vars)


NSR_DATA_VOLUME_POOL=NSRINFDATA
NSR_LOG_VOLUME_POOL=NSRINFLOGS


to


NSR_DATA_VOLUME_POOL=NSRINFDISKDATA
NSR_LOG_VOLUME_POOL=NSRINFDISKLOGS


See also thread ' Logical log backups [7889]'.
Of course, this needs to be tested, also the restore.


HTH,


Robert


Robert Seifert
_________________________________________________________________
IBM Deutschland GmbH, Information Management Solutions, Software,
Informix Products, Advanced Support


Elite VAR support engineer
Development Support for IBM Informix Products on-site @ SAP
c/o SAP AG, -PS03-,Neurottstrasse 16, D-69190 Walldorf, Germany
_________________________________________________________________


informix-list-boun...@iiug.org wrote on 06.12.2006 21:58:17:



- Hide quoted text -
- Show quoted text -

> Hi,


> Does anyone know how to redirect our logical logs backup from tape
> to disk? We currently use a storage manager and onbar and a seperate
> server with tape drive for this purpose. The sys admin guys want to
> retire the seperate server with tape drive.


> This is our configuration:
> Operating System: Solaris 9
> Database: Informix 7.30.UC2
> Storage Manager:Solstice Backup 5.1 Turbo 10


> Thanks
> Gerry_______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list



Reply » Rate this post: Text for clearing space


End of messages

No comments: