When Reconcile command is used in the procedure for hot backup and resync, it gives the following error :
"Child process failed: RESETLOGS has been detected.reconcile cannot run in that situation"
Reconcile command failed as the sequence number was not provided.
For example: reconcile queue for datasource-datadest
Provide the sequence number in the syntax of reconcile command.
Syntax for the reconcile command using seq no:
reconcile queue fordatasource-datadest seq sequence_number
Example:
sp_ctrl (sysB)>reconcile queue SysA for o.oraA-o.oraB seq 1234
The data is reconciled for default post queue o.oraA-o.oraB, which is the data stream replicating from source instance oraA to target instance oraB to the end of Oracle log number 1234.
Reconcile command recovers up to sequence number/scn number/to flush.
Note:In the above example If unsure about the sequence number to recover upto, Use Oracle alert log on the target to find the sequence number the database was recovered upto.
Refer the Shareplex Reference Manual for more details on Reconcile Command.
NOTE: When the database is opened with resetlogs option then reconcile should be issued with a sequence number. Reconcile can be issued without a sequence number before opening the database with resetlogs option . Then reconcile command recovers upto the last recovered log.
