Re: Replication setup problem
David Williams wrote:
} In article <6a28fu$cdo@cssun.mathcs.emory.edu>, Christian Winterhager
} <christian.winterhager@orbit.de> writes
} >Hi,
} >
} >secondary server hangs in Recovery Mode!
} >
} >We have ODS 7.22 UC2 on both machines, and SCO 5.0
} >All Things are identical and we start with
} >1. an archive Levele 0 on machine A (the primary server).
} Yes Step 1 i.e. ontape -s -L 0..
}
} >2. on machine A: Log.Log Backup
} Not needed
}
} >3. on machine A: onmode -d primary machine_b
} Yes Step 2
} >4. on machine B (the secondary Server): physical restore from the
} >step-1-Backup
} Yes Step 3 i.e. ontape -p
}
} >5. on machine B: Changing machine B to secondary Server
} >
} Yes Step 4 i.e. onmode -d secondary machine_A
}
} >From this point the secondary Server hangs in Recovery Mode?
}
} on machine B ontape -l (logical restore).
}
} This is from Online Admin Guide 7.1 Volume 1 Pages 30-12 and 30-13
}
} It says (on page 30-13, Right hand side of the page i.e. Seconday
} Server, Below onmode command and Messages to message log.
}
} "IF all logical log records written to the primary database server
} since step 1 still reside on the primary database server disk, teh
} secondary database server reads these records to perform logical
} recovery (otherwise step 5 must be performed)."
}
} Since you have done a Log. log backup to tape on the primary, the
} primary no longer has a record of the logical logs on that tape. Hence
} the secondary cannot get them from the primary. You need to feed them
} to the secondary, by doing an ontape -l and giving it the logical log
} tape.
Thank you David for your comments , but the problem is, that ontape -l on the
secondary Server is refused with the error message
Logical Log Recovery is allready in progress.....
And thats the point: there IS a logical recovery in progress, as you can see
starting "onmonitor", and so he cannot do this command!
BTW: Replication works fine, any SQL-Commands on the primary server are replicated
to the secondary Server, but i wonder about the state "Recovery"....
Any Ideas?