Re: [Networker] Cloning Informix online full database backups

 Hi,
You should be able to find which savesets to clone
with mminfo and export that info to a file. Use the
same file as input to nsrclone to perform the actual
cloning.

// Matts

 --- Julio Porras <Julio.Porras AT VENALUM.COM DOT VE> skrev:
> OK, I have my nsrdbmi script is like this:
>
> NSR_DATA_VOLUME_POOL="DBMIData"
> DO_LOGFILE_BACKUPS=YES
> NSR_LOG_VOLUME_POOL="DBMILogs"
> DO_BOOTFILE_BACKUPS=YES
> BOOTFILE_LIST=/informix/PR1/nsrblist
> NSR_COMPRESSION=TRUE
> INFORMIXDIR=/informix/PR1
> ONCONFIG=onconfig.prodb.pr1
> INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts.soc
>
PATH=$INFORMIXDIR/bin:/bin:/usr/sbin:/opt/networker/bin:/usr/opt/networker/b
> in:/usr/bin
> NSR_DEBUG_FILE=/nsr/applogs/xbsa.messages
> NSR_DEBUG_LEVEL=2
>
> My server is Networker 6.02 on Windows NT 4.0 and
> this client is SAP R/3
> Informix Database server on UNIX (HP-UX 11)
>
> I don't think I want to start a volume clone, since
> I have data from other
> database backups (DEV, QAS) in the same volume and I
> don't want that data
> cloned (only PRD). Also because database data goes
> to one volume pool
> (DBMIData) and logfile data goes to a different
> volume pool (DBMILogs).
>
> If I start a saveset clone, do I have to specify to
> networker ALL the
> savesets I want to clone? Because every Informix
> dbspace goes to a separate
> saveset, and every logfile goes to a separate
> saveset also.
>
> When I do my manual cloning, I select about 70
> entries (savesets) to clone,
> including DATA from all my dbspaces and all LOGS
> used from full backup start
> time to full backup end time from the resulting
> networker's clone save set
> "query".
>
> So, my question is:
>
> How can I "AUTOMATICALLY" clone (not via save set
> clone menu, but via
> command line with "nsrclone") every full backup,
> including the log files
> that were filled up while the backup was running?
>
> Thanks again.
>
> Julio Porras
> Especialista de Sistemas
> CVG Venalum
> 286-9506898
> 416-7985875
>
> -----Original Message-----
> From: Grohal Klaus [mailto:klaus.grohal AT siemens DOT com]
>
> Sent: Viernes, 04 de Abril de 2003 05:08 a.m.
> To: Legato NetWorker discussion; Julio Porras
> Subject: AW: [Networker] Cloning Informix online
> full database backups
>
> 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.
>
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

_____________________________________________________
Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express
Se mer på: http://se.docs.yahoo.com/info/express/help/index.html

--
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.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=