×

Systems and methods for managing snapshots of replicated databases

  • US 8,666,942 B2
  • Filed: 06/14/2012
  • Issued: 03/04/2014
  • Est. Priority Date: 12/10/2008
  • Status: Active Grant
First Claim
Patent Images

1. A system for performing data management operations in a computer network environment, the system comprising:

  • a target computer comprising computer hardware, the target computer coupled to a source computer, wherein the source computer has a native database application executing thereon and is coupled to at least one first storage device storing a source database including data generated by the native database application;

    at least one second storage device coupled to the target computer, wherein the target computer is configured to;

    generate a target database on the second storage device, the target database including a replicated version of at least some of the data in the source database;

    perform a first copy operation to generate a first copy of at least a portion of the target database, wherein performing the first copy operation puts the target database into an unclean shutdown state;

    subsequent to the first copy operation, commit a plurality of data transactions into the target database, the plurality of data transactions generated by the native database application and represented by a plurality of corresponding log entries, wherein the committing of the plurality of data transactions into the target database occurs prior to the plurality of data transactions being committed into the source database, wherein the data in the source database and the data in the target database are out of sync following the committing of the plurality of data transactions into the target database, and wherein the committing of the plurality of data transactions into the target database puts the target database into a clean shutdown state;

    subsequent to the committing of the plurality of data transactions into the target database, perform a second copy operation to generate a second copy of at least a portion of the target database which includes data corresponding to the plurality of committed data transactions, wherein the second copy is generated in the clean shutdown state; and

    revert the target database back to the unclean shutdown state in which the target database existed at the time the first copy operation was performed,wherein the clean shutdown state allows for offline access of the data in the respective target database or second copy without the need for the native database application, andwherein the unclean shutdown state requires the native database application for offline access of the data in the respective target database or second copy.

View all claims
  • 4 Assignments
Timeline View
Assignment View
    ×
    ×