Oninit cdi / Archive
Talk to an expert →

Backup from RSS server

Posted in 2010

Topics: High Availability & Replication, Server Administration, Migration, Import/Export & Data Conversion, Platform-Specific Issues, Clustering, Grid & MACH11, Versions, Editions & End-of-Life

MURALI PAZHAYANNUR — — source: IIUG Forums & Mailing Lists

I am testing on a RSS server setup for the first time. The RSS server will be used to backup the Production databases so that we can restore any one of 4 distinct instances we have on our Development box. Currently we use 'onunload/onload' process to backup/restore Production databases to Development instances. I tested onunload on the RSS server (after setting STOP_APPLY=1) and got a 'The onunload utility is not supported on a secondary database server in a cluster'. Is there any other backup utility that I can use to accomplish what I want? Any idea if onunload/onload utility is likely to be supported on a secondary server in the future? {This is on IDS 11.50.FC5//HP-UX 11.23 Ia64.) Here is the output: RSS server 3 /home/muralip > oninit 4 /home/muralip > onmode -wf STOP_APPLY=1 5 /home/muralip > onunload -b 20 -s 0 -t /backup/unloads/advisordirect_unload.fil advisordirect The onunload utility is not supported on a secondary database server in a cluster. 6 /home/muralip > onstat - IBM Informix Dynamic Server Version 11.50.FC5W2 -- Read-Only (RSS) -- Up 00:06:14 -- 846416 Kbytes

↪ replying to MURALI PAZHAYANNUR
Alexandre Marini — — source: IIUG Forums & Mailing Lists

You could use the new ontape STDIO backup and restore, simultaneously, to do it. Alexandre Marini Tecnologia da Informação - DBA SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf <http://www.iiug.org>; MURALI PAZHAYANNUR escreveu: > I am testing on a RSS server setup for the first time. The RSS server will be > used to backup the Production databases so that we can restore any one of 4 > distinct instances we have on our Development box. Currently we use > 'onunload/onload' process to backup/restore Production databases to > Development instances. I tested onunload on the RSS server (after setting > STOP_APPLY=1) and got a 'The onunload utility is not supported on a secondary > database server in a cluster'. Is there any other backup utility that I can > use to accomplish what I want? Any idea if onunload/onload utility is likely > to be supported on a secondary server in the future? > {This is on IDS 11.50.FC5//HP-UX 11.23 Ia64.) > > Here is the output: > > RSS server > 3 /home/muralip > oninit > 4 /home/muralip > onmode -wf STOP_APPLY=1 > 5 /home/muralip > onunload -b 20 -s 0 -t > /backup/unloads/advisordirect_unload.fil advisordirect > The onunload utility is not supported on a secondary database server in a > cluster. > 6 /home/muralip > onstat - > > IBM Informix Dynamic Server Version 11.50.FC5W2 -- Read-Only (RSS) -- Up > 00:06:14 -- 846416 Kbytes> > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > >

↪ replying to MURALI PAZHAYANNUR
Nilesh Ozarkar — — source: IIUG Forums & Mailing Lists

If you upgrade to 11.50.xC6, you could perform the external backup on the RSS server and use that backup to restore any server in the cluster. details here - http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.bar.doc/ids_ bar_503.htm - Nilesh - ids-bounces@iiug.org wrote on 04/19/2010 02:29:35 PM: > From: > > "MURALI PAZHAYANNUR" <pmurali@ftportfolios.com>: > > To: > > ids@iiug.org > > Date: > > 04/19/2010 02:30 PM > > Subject: > > Backup from RSS server [19742] > > Sent by: > > ids-bounces@iiug.org > > I am testing on a RSS server setup for the first time. The RSS server will be > used to backup the Production databases so that we can restore any one of 4 > distinct instances we have on our Development box. Currently we use > 'onunload/onload' process to backup/restore Production databases to > Development instances. I tested onunload on the RSS server (after setting > STOP_APPLY=1) and got a 'The onunload utility is not supported on a secondary > database server in a cluster'. Is there any other backup utility that I can > use to accomplish what I want? Any idea if onunload/onload utility is likely > to be supported on a secondary server in the future? > {This is on IDS 11.50.FC5//HP-UX 11.23 Ia64.) > > Here is the output: > > RSS server > 3 /home/muralip > oninit > 4 /home/muralip > onmode -wf STOP_APPLY=1 > 5 /home/muralip > onunload -b 20 -s 0 -t > /backup/unloads/advisordirect_unload.fil advisordirect > The onunload utility is not supported on a secondary database server in a > cluster. > 6 /home/muralip > onstat - > > IBM Informix Dynamic Server Version 11.50.FC5W2 -- Read-Only (RSS) -- Up > 00:06:14 -- 846416 Kbytes> > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Glossary