Hi,

1) the online backup of the informix database is NOT consistent without
logfiles.

2) in your nsrdbmi script set the parameter: DO_LOGFILE_BACKUPS=YES and
define a NSR_LOG_VOLUME_POOL, after backup is done you can do an saveset- or
volume clone.

regards
Klaus



-----Ursprüngliche Nachricht-----
Von: Julio Porras [mailto:Julio.Porras AT VENALUM.COM DOT VE]
Gesendet am: Donnerstag, 3. April 2003 20:57
An: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Betreff: [Networker] Cloning Informix online full database backups

We perform an automatic online full Informix database backup (onbar -b -L0)
every Saturday night, starting at 8pm and ending at 3am Sunday approximately
to the DBMIData pool. While the backup is running, a number of log files are
filled up with transactional data and saved automatically to the DBMILogs
pool.

We need to clone the full backup data, but we are concerned about
transactional log files not being included in the clone tape.

I have some questions:

1. Is the data of an informix full online backup consistent (without de log
files) or do I need the log files in order to restore a consistent database.

2. If no, how can I automatically clone every full backup, including the log
files that were filled up while the backup was running?

Thanks for your help and advise.

Julio Porras
Especialista de Sistemas
CVG Venalum
286-9506898
416-7985875

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=