Continous Log Restore using Ontape

Hello IDS 11.10.FC2W4 I want to try out the continous log restore using ontape. The version of Dynamic Server is identical on both the primary and secondary systems. From the manual i read the following steps: 1.On the primary system, perform a level-0 archive with the following command: ontape -s -L 0 2.On the secondary system, copy the files or mount the tape (as assigned by LTAPEDEV) and perform a physical restore with the following command: ontape -p Respond to the following prompts: Continue restore? Y Do you want to back up the logs? N Restore a level 1 archive? N After the physical restore completes, the database instance waits in fast recovery mode to restore logical logs. 3.On the primary system, back up logical logs with the following command: ontape -a -- I'm using the directory feature to backup the logical logs and alarmprogram.sh to triger the logical log backup on event 23 so i have a directory where all the logs from the last level 0 are available 4.On the secondary system, copy the files or mount the tape that contains the backed up logical logs from the primary system. Perform a logical log restore with the following command: ontape -l -C -- After the step 2 the db is in fast recovery mode,now do i have to run ontape -l -C ( considering that I'm copying every logical log generated on theprimray to the secondry in directory to which the LTAPEDEV points )in this mode? 5.Repeat steps 3 and 4 for all logical logs that are available to back up and restore. --supposing that step 4 holds good and i finish restoring all the logical logs from primary on to this secondry then do i have to follow the step 6 as it is? 6.If you are doing continuous log restore on a secondary system as an emergency standby, run the following commands to complete restoring logical logs and quiesce the server. If logical logs are available to restore: ontape -l After all available logical logs are restored: ontape -l -X -- whats does the above 2 command accomplish? If a new log file is generated on primary and is copied on to secondry then will that log be auto restored on the secondry ? What would be the state of secondry as long as continous log restoration is enabled? would it be read only as HDR or always in quescient mode ? Let me know if i have not been able to clearly mention my doubts and Pls simplify the working of continous logical log restoration... Thanking you Regards Vikas.

On Monday 06 October 2008 13:04:11 VIKAS HIVARKAR wrote: > Hello > IDS 11.10.FC2W4 > I want to try out the continous log restore using ontape. > > The version of Dynamic Server is identical on both the primary and > secondary systems. > > From the manual i read the following steps: > 1.On the primary system, perform a level-0 archive with the following > command: ontape -s -L 0 > > 2.On the secondary system, copy the files or mount the tape (as assigned by > LTAPEDEV) and perform a physical restore with the following command: > ontape -p> > Respond to the following prompts: > Continue restore? Y > Do you want to back up the logs? N > Restore a level 1 archive? N > > After the physical restore completes, the database instance waits in fast > recovery mode to restore logical logs. > > 3.On the primary system, back up logical logs with the following command: > ontape -a> > -- I'm using the directory feature to backup the logical logs and > alarmprogram.sh to triger the logical log backup on event 23 so i have a > directory where all the logs from the last level 0 are available > > 4.On the secondary system, copy the files or mount the tape that contains > the backed up logical logs from the primary system. Perform a logical log > restore with the following command: > ontape -l -C> > -- After the step 2 the db is in fast recovery mode,now do i have to run > ontape -l -C ( considering that I'm copying every logical log generated on> the primray to the secondry in directory to which the LTAPEDEV points )in > this mode? Yes. > > 5.Repeat steps 3 and 4 for all logical logs that are available to back up > and restore. > --supposing that step 4 holds good and i finish restoring all the logical > logs from primary on to this secondry then do i have to follow the step 6 > as it is? If you want to finish the continuous log restore and switch the 'secondary' to Quiescent mode then following step 6 is OK. > > 6.If you are doing continuous log restore on a secondary system as an > emergency standby, run the following commands to complete restoring logical > logs and quiesce the server. > > If logical logs are available to restore: > > ontape -l> > After all available logical logs are restored: > > ontape -l -X> > -- whats does the above 2 command accomplish? ontape -l -X switch the server to Quiescent mode directly while ontape -lrestores logical logs befor switching the server to Quiescent mode. > > If a new log file is generated on primary and is copied on to secondry then > will that log be auto restored on the secondry ? No. > > What would be the state of secondry as long as continous log restoration is > enabled? would it be read only as HDR or always in quescient mode ? Its in Fast Recovery mode until ontape -l or ontape -l -X is called. > > Let me know if i have not been able to clearly mention my doubts and Pls > simplify the working of continous logical log restoration... I think continuous log restore works simple. Andreas > > Thanking you > > Regards > Vikas. > > > *************************************************************************** >**** Forum Note: Use "Reply" to post a response in the discussion forum. -- Andreas Breitfeld; Informix Development Munich IBM Deutschland Research & Development GmbH; Vorsitzender des Aufsichtsrats: Martin Jetter; Geschaeftsfuehrung: Erich Baier; Sitz der Gesellschaft: Boeblingen; Registergericht: Amtsgericht Stuttgart, HRB 243294