RE: Starting Data Replication Question

Maria, I think the same as Paul. I would use "ontape -p" instead, it works very well and it is recommended in the manuals. Remember that you do not need "just a full restore" . As Paul says, you need a "full restore for replication". That leaves the secondary (spu12) in recovery mode, and then you should be able to execute: "onmode -d secondary spu12" to set the secondary's mode. and then... "onmode -d primary spu11" to set the primary's mode (that should be in On-line/standard mode) If this does not work, as Paul says, check your onconfig file, and I add: check your "sqlhosts" file (and the solaris services file) in both machines! Note: You do not need to do a backup in a tape. You can use a file instead. Try to create a file (with informix user) and then change the path in the onconfig file. So, you can use also a remote file (use the same for backup and restore), look at the doc, it is explained very well. Regards, Javier > -----Original Message----- > From: Maria C. Lopez [mailto:lopez@arl.army.mil] > Sent: 11 January 2001 13:41 > To: mosserp@WellsFargo.COM > Cc: informix-list@iiug.org; Maria C. Lopez > Subject: Re: Starting Data Replication Question > > > Hello, > > Yes, I mentioned the wrong computer, spu12 is in recovery mode. > The ondatartr supposely does a physical recovery. I am > starting to believe that > it is the recovered rootdbs and root.chunk that are not right > on spu12. I would > have to wait for my system administrator to get back from > sick leave to set up a > tape for me to try the ontape command. > > Yes, my DR parameters are identical on both machines. > Should I be able to see the status of the Databases using > onmonitor when the > server is in recovery mode? > Should I be able to set the mode to secondary even if spu12 > can't connect to > spu11? > > If it is of any help for you, here is the result of the > recovery from the log > file: > > Wed Jan 10 13:42:17 2001 > > 13:42:17 Event alarms enabled. ALARMPROG = > '/opt/informix/etc/no_log.sh' > 13:42:22 DR: DRAUTO is 0 (Off) > 13:42:22 Requested shared memory segment size rounded from> 600KB to 608KB > 13:42:23 Informix Dynamic Server Version 7.30.UC3 Software> Serial Number AAC# > > J451944 > 13:42:24 Informix Dynamic Server Initialized -- Shared> Memory Initialized. > 13:42:24 Dataskip is now OFF for all dbspaces > 13:42:24 Recovery Mode > 13:42:26 Physical Restore of rootdbs started. > > 13:42:34 Checkpoint Completed: duration was 0 seconds. > 13:42:35 Physical Restore of rootdbs Completed. > 13:42:35 Checkpoint Completed: duration was 0 seconds.> > Thanks! > > -Maria > > > > mosserp@wellsfargo.com wrote: > > > Actually, spu12 (secondary) should be the one in recovery > mode; it should be > > left in that state after you did the restore. I don't know what the > > onarchive command is (no manual here, and I've never used > the beast), but > > make sure that you do only a "physical" restore, not a > regular logical > > restore. With ontape, you'd want to do "ontape -p", > instead of "ontape -r". > > Maybe you could give us the output from the message log from spu12 > > immediately after you do the restore?? Also, make sure > that your DR... > > parameters in your onconfig file are set identical on both servers. > > > > HTH, > > Paul Mosser > > > > -----Original Message----- > > From: Maria C. Lopez [mailto:lopez@arl.army.mil] > > Sent: Monday, January 08, 2001 12:26 PM > > To: informix-list@iiug.org > > Subject: Starting Data Replication Question > > > > Hello, > > > > I have been assigned to set two computers as servers for > replication, > > spu11 and spu12, using Informix! > > I have followed all the steps for a physical backup on > spu11 (primary) > > and have restored the database on spu12 (secondary). I followed the > > steps on the "Universal Server Administrator's Guide", chapter 30, > > "Using Data Replication", section "Starting Data Replication for the > > First Time." These steps included using onarchive and ondatartr. > > Everything seems all right as far as the backup is concerned. > > > > Following the steps, I set spu11 to primary, and that works. > > When I try to set spu12 as secondary I get an error. > > > > The command is, onmode -d secondary spu11. > > The feedback is DR: Unable to change server type. > > > > The server spu11 is on the right mode, recovery, according to the > > manual. > > > > Any suggestions? > > > > -Maria >