HDR not working
Hi all,
It's my first time to configure a replicated machines. I'm using the same
machine specification (all hardware), same IDS 11.5, same all up to the
configuration. I also performed a backup using ontape -s -L 0 and ontape -r in
secondary.
on primary server, i performed
onmode -d primary secondaryserver
on secondary server, i performed "onmode -d secondary primaryserver.
I encountered the below message:
Fri Jan 8 01:58:20 2010
01:58:20 Event alarms enabled. ALARMPROG = '/opt/informix/etc/alarmprogram.sh'
01:58:20 Dynamically allocated new virtual shared memory segment (size 8316KB)
01:58:20 Booting Language <c> from module <>
01:58:20 Loading Module <CNULL>
01:58:20 Booting Language <builtin> from module <>
01:58:20 Loading Module <BUILTINNULL>
01:58:25 DR: DRAUTO is 0 (Off)
01:58:25 Dynamically allocated new message shared memory segment (size 544KB)
01:58:25 Dynamically allocated new message shared memory segment (size 544KB)
01:58:25 Dynamically allocated new virtual shared memory segment (size 8192KB)
01:58:25 IBM Informix Dynamic Server Version 10.00.FC4 Software Serial Number
AAA#B000000
01:58:30 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
01:58:30 Data replication type and state information reset. To start DR, use
the 'onmode -d' command and wait for the pair to be operational,
before shutting down the database server
01:58:30 Dataskip is now OFF for all dbspaces
01:58:30 Restartable Restore has been ENABLED
01:58:30 Recovery Mode
01:58:37 DR: new type = secondary, primary server name = ross1
01:58:37 DR: Trying to connect to primary server = ross1
01:58:37 DR: Cannot connect to primary server
01:58:37 DR: Turned off on secondary server
I also created /etc/hosts.equiv on both machines and add the names of the
machines. on sqlhosts, i included both servernames
use 'ontape -p' on the secondary
From:
"JACK PAPA" <informix2009@gmail.com>
To:
ids@iiug.org
Date:
01/07/2010 08:21 AM
Subject:
HDR not working [18604]
Sent by:
ids-bounces@iiug.org
Hi all,
It's my first time to configure a replicated machines. I'm using the same
machine specification (all hardware), same IDS 11.5, same all up to the
configuration. I also performed a backup using ontape -s -L 0 and ontape
-r in
secondary.
on primary server, i performed
onmode -d primary secondaryserver
on secondary server, i performed "onmode -d secondary primaryserver.
I encountered the below message:
Fri Jan 8 01:58:20 2010
01:58:20 Event alarms enabled. ALARMPROG =
'/opt/informix/etc/alarmprogram.sh'
01:58:20 Dynamically allocated new virtual shared memory segment (size
8316KB)
01:58:20 Booting Language <c> from module <>
01:58:20 Loading Module <CNULL>
01:58:20 Booting Language <builtin> from module <>
01:58:20 Loading Module <BUILTINNULL>
01:58:25 DR: DRAUTO is 0 (Off)
01:58:25 Dynamically allocated new message shared memory segment (size
544KB)
01:58:25 Dynamically allocated new message shared memory segment (size
544KB)
01:58:25 Dynamically allocated new virtual shared memory segment (size
8192KB)
01:58:25 IBM Informix Dynamic Server Version 10.00.FC4 Software Serial
Number
AAA#B000000
01:58:30 IBM Informix Dynamic Server Initialized -- Shared Memory
Initialized.
01:58:30 Data replication type and state information reset. To start DR,
use
the 'onmode -d' command and wait for the pair to be operational,
before shutting down the database server
01:58:30 Dataskip is now OFF for all dbspaces
01:58:30 Restartable Restore has been ENABLED
01:58:30 Recovery Mode
01:58:37 DR: new type = secondary, primary server name = ross1
01:58:37 DR: Trying to connect to primary server = ross1
01:58:37 DR: Cannot connect to primary server
01:58:37 DR: Turned off on secondary server
I also created /etc/hosts.equiv on both machines and add the names of the
machines. on sqlhosts, i included both servernames
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
From the secondary server environment try connecting to the primary server
"ross1" (using dbaccess). This will give you some hint as to why secondary
server can't connect to the primary server.
In secondary server's SQLHOSTS ensure that you are using soctcp protocol
and host/port number of primary server is correct.
- Nilesh -
ids-bounces@iiug.org wrote on 01/07/2010 08:20:27 AM:
> From:
>
> "JACK PAPA" <informix2009@gmail.com>
>
> To:
>
> ids@iiug.org
>
> Date:
>
> 01/07/2010 08:22 AM
>
> Subject:
>
> HDR not working [18604]
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Hi all,
>
> It's my first time to configure a replicated machines. I'm using the same
> machine specification (all hardware), same IDS 11.5, same all up to the
> configuration. I also performed a backup using ontape -s -L 0 and
> ontape -r in
> secondary.>
> on primary server, i performed
>
> onmode -d primary secondaryserver>
> on secondary server, i performed "onmode -d secondary primaryserver.
>
> I encountered the below message:
>
> Fri Jan 8 01:58:20 2010
>
> 01:58:20 Event alarms enabled. ALARMPROG = '/opt/informix/etc/
> alarmprogram.sh'
> 01:58:20 Dynamically allocated new virtual shared memory segment
> (size 8316KB)
> 01:58:20 Booting Language <c> from module <>
> 01:58:20 Loading Module <CNULL>
> 01:58:20 Booting Language <builtin> from module <>
> 01:58:20 Loading Module <BUILTINNULL>
> 01:58:25 DR: DRAUTO is 0 (Off)
> 01:58:25 Dynamically allocated new message shared memory segment (size
544KB)
> 01:58:25 Dynamically allocated new message shared memory segment (size
544KB)
> 01:58:25 Dynamically allocated new virtual shared memory segment
> (size 8192KB)
> 01:58:25 IBM Informix Dynamic Server Version 10.00.FC4 Software Serial
Number
> AAA#B000000
> 01:58:30 IBM Informix Dynamic Server Initialized -- Shared Memory
> Initialized.
>
> 01:58:30 Data replication type and state information reset. To start DR,
use
>
> the 'onmode -d' command and wait for the pair to be operational,
>
> before shutting down the database server
>
> 01:58:30 Dataskip is now OFF for all dbspaces
> 01:58:30 Restartable Restore has been ENABLED
> 01:58:30 Recovery Mode
> 01:58:37 DR: new type = secondary, primary server name = ross1
> 01:58:37 DR: Trying to connect to primary server = ross1
> 01:58:37 DR: Cannot connect to primary server
> 01:58:37 DR: Turned off on secondary server
>
> I also created /etc/hosts.equiv on both machines and add the names of the
> machines. on sqlhosts, i included both servernames
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Your mistake was that you have to perform a physical restore (ontape -p) not
a full restore (ontape -r). Run the restore again with -p instead of -r.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
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 Thu, Jan 7, 2010 at 9:20 AM, JACK PAPA <informix2009@gmail.com> wrote:
> Hi all,
>
> It's my first time to configure a replicated machines. I'm using the same
> machine specification (all hardware), same IDS 11.5, same all up to the
> configuration. I also performed a backup using ontape -s -L 0 and ontape -r
> in
> secondary.
>
> on primary server, i performed
>
> onmode -d primary secondaryserver>
> on secondary server, i performed "onmode -d secondary primaryserver.
>
> I encountered the below message:
>
> Fri Jan 8 01:58:20 2010
>
> 01:58:20 Event alarms enabled. ALARMPROG =
> '/opt/informix/etc/alarmprogram.sh'
> 01:58:20 Dynamically allocated new virtual shared memory segment (size
> 8316KB)
> 01:58:20 Booting Language <c> from module <>
> 01:58:20 Loading Module <CNULL>
> 01:58:20 Booting Language <builtin> from module <>
> 01:58:20 Loading Module <BUILTINNULL>
> 01:58:25 DR: DRAUTO is 0 (Off)
> 01:58:25 Dynamically allocated new message shared memory segment (size
> 544KB)
> 01:58:25 Dynamically allocated new message shared memory segment (size
> 544KB)
> 01:58:25 Dynamically allocated new virtual shared memory segment (size
> 8192KB)
> 01:58:25 IBM Informix Dynamic Server Version 10.00.FC4 Software Serial
> Number
> AAA#B000000
> 01:58:30 IBM Informix Dynamic Server Initialized -- Shared Memory
> Initialized.
>
> 01:58:30 Data replication type and state information reset. To start DR,
> use
>
> the 'onmode -d' command and wait for the pair to be operational,
>
> before shutting down the database server
>
> 01:58:30 Dataskip is now OFF for all dbspaces
> 01:58:30 Restartable Restore has been ENABLED
> 01:58:30 Recovery Mode
> 01:58:37 DR: new type = secondary, primary server name = ross1
> 01:58:37 DR: Trying to connect to primary server = ross1
> 01:58:37 DR: Cannot connect to primary server
> 01:58:37 DR: Turned off on secondary server
>
> I also created /etc/hosts.equiv on both machines and add the names of the
> machines. on sqlhosts, i included both servernames
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--00151747b690b81977047c950c7e
Thanks Art et.al, I've reviewed some documentations from IBM and it looks like
the "ontape -r" causes the problem, it should be "ontape -p" for physical
restore.... I'll try it one more time.
Thanks again....