KB labels


Ticket Product Version

Ticket Category

Ticket Assignee


Hot Fixes

Published Fixes
Your Arcserve Support User Profile
First Name:
Last Name:
email:
Phone:
Company:*
Customer Type:
Language:

Country:
Region:

Time zone:
Follow

arcserve-KB : How to enable Data Rewind in SQL Scenario

Last Update: 2016-04-25 14:07:43 UTC

 

Description:

This document explain about Data Rewind and how to use it.

Data Rewind:

The Data Rewind recovery method allows you to rewind data to a point in time before it was corrupted. The rewind process takes place on the Replica Server before the reverse synchronization process starts. The Data Rewind method uses rewind points or bookmarks that enable you to reset the current data back to a previous state.

You can use this option only if you set the Recovery - Data Rewind option to On.

If this option is set to Off, the system will not register data rewind points.

Important! The data rewind process operates in one way only - there is no replay forward. After rewind, all data subsequent to the rewind point will be lost, since data after the rewind point will be overwritten with new data.

Note: The automatic registration of the rewind points starts only after the synchronization process is completed, and the message All modifications during synchronization period are replicated appears on the Event pane. Similarly, you cannot manually set bookmarks during synchronization.

To recover lost data using rewind points

  • On the manager, from the Scenario pane select the desired scenario and stop it.
  • [For the applicaions only] stop the database services on the Master host.
  • On the Manager, from the scenarios folder select the Replica host:

               Note: If multiple Replica Servers participate in the required scenario, select the Replica from which you want to recover data.

              

  • From the Tools menu, select Restore Data, or click the Restore Data button.

              The Recovery method page of the Restore Data wizard opens.

  • Select one of the Rewind data options, depending on whether you want the rewind data synchronized back to the Master (opton 2) or left on the Replica only (option 3)

              After you select a Rewind data option, a Recovery scenario is automatically created.

  • Click Next. The Rewind Point Selection page is displayed.
  • Wait until the Select Rewind Point button is enabled, and click it to view the existing rewind points.

              The Select Rewind Point dialog opens.

The Select Rewind Point dialog displays a list of all rewind points appropriate to the application you are pretecting. The include  modifications of folders and SQL checkpoints that were automatically registered by the system and user-defined bookmarks.

              The list can be filtered according to the rewind point type of another criteria, using the Filter Rewind Points pane on hte left.

  • Select the required rewind point, and click OK.

              Note: If you wan to use a Bookmark as the rewind point, it is best practice to select the closest rewind point that indicates an actual event.

              You return to the Rewind Point Selection page, now displaing information about the rewind point you selected.

  • Click Next, The Synchronization Method page is displayed.
  • Select the Block Synchronization method and click Finish.

CA ARCserve RHA rewinds the data to the point you selected. After the rewind process ends, you receive the following message in the Event pane: Rewind process is completed successfully.

If you chose to replace the data on the Master with the data on the Replica, CA ARCserve RHA starts a synchronization process from the Replica to the Master. Once the process ends, the temporary Recovery scenario is stopped and then deleted.

  • By default, once a data recovery occurs a Synchronization Report is generated.

             Now, the Replication process can restart on the original scenario.

 

 

 

 

 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments