Logically consistent archive with minimal downtime
A sub-archive is initiated. The sub-archive saves changes that have occurred since a previous final archive. Changes to an operational database (i.e., the operational database that is being archived) are allowed during the first sub-archive. A final archive is initiated in series after the sub-archive has completed. The final archive does not allow changes to the operational database when the final archive is active. In one embodiment, the sub-archive may comprise a plurality of sub-archives that depend on an amount of outstanding changes that exist in the operational database.
1. A system comprising:
a microprocessor; and
a non-transitory computer readable medium, coupled with the microprocessor and comprising microprocessor readable and executable instructions that, when executed by the microprocessor, cause the microprocessor to:
initiate an archive process on an operational database, wherein the archive process comprises a sub-archive and a final archive, wherein the sub-archive comprises a plurality of sub-archives, and wherein the sub-archive and the final archive run in series;
initiate the sub-archive, wherein the sub-archive saves changes in the operational database that have occurred since a previous final archive, wherein a number of sub-archives in the plurality of sub-archives is based on a number of outstanding changes in the operational database since a previous final archive, wherein a delay time between each of the plurality of sub-archives is based on the number of outstanding changes in the operational database since the previous final archive and a series of progressively smaller incremental time values, and wherein changes to the operational database are allowed during the sub-archive;
receive a request from a user to access the operational database, and in response to the request to access the operational database, create a registration record for the user, wherein when the user is done accessing the operational database or when the user's access has been terminated the registration record is deleted; and
determine if the registration record exists: if the registration record exists, then do not initiate the final archive; and
if the registration record does not exist, then initiate the final archive, wherein no changes are allowed to the operational database during the final archive.
2. The system of claim 1 , wherein the number of sub-archives is further based on at least one of:
a defined number of sub-archives; and
a maximum number of sub-archives.
3. The system of claim 1 , wherein the sub-archive and the final archive comprise a complete archive.
4. The system of claim 1 , wherein the delay time between each of the plurality of sub-archives is further based on
an administered value.
5. The system of claim 1 , wherein the microprocessor readable and executable instructions further cause the microprocessor to:
read an archive field that indicates if the final archive is active, wherein if the final archive is active, all requests to access the operational database are denied.
6. The system of claim 1 , wherein the registration record includes a heartbeat field indicating the user is actively accessing the operational database.
7. The system of claim 6 , further comprising:
updating the heartbeat field to terminate a heartbeat thread when the user is done accessing the operational database.
8. A method comprising:
initiating, by a microprocessor, an archive process on an operational database, wherein the archive process comprises a sub-archive and a final archive, wherein the sub-archive comprises a plurality of sub-archives, and wherein the sub-archive and the final archive run in series;
initiating the sub-archive, wherein the sub-archive saves changes that have occurred since a previous final archive, wherein a number of sub-archives in the plurality of sub-archives is based on a number of outstanding changes in the operational database since a previous final archive, wherein a delay time between each of the plurality of sub-archives is based on the number of outstanding changes in the operational database since the previous final archive and a series of progressively smaller incremental time values, and wherein changes to the operational database are allowed during the sub-archive;
receiving a request from a user to access the operational database, and in response to the request to access the operational database, creating a registration record for the user, wherein when the user is done accessing the operational database or when the user's access has been terminated the registration record is deleted; and determining if the registration record exists:
if the registration record exists, then do not initiate the final archive; and
if the registration record does not exist, then initiate the final archive, wherein changes to the operational database are not allowed during the final archive.
9. The method of claim 8 , wherein the number of sub-archives is further based on at least one of:
a defined number of sub-archives; and
a maximum number of sub-archives.
10. The method of claim 8 , wherein the sub-archive and the final archive comprise a complete archive.
11. The method of claim 8 , wherein the delay time between each of the plurality of sub-archives is further based on
an administered value.
12. The method of claim 8 , further comprising:
reading an archive field that indicates if the final archive is active, if the final archive is active, all requests to access the operational database are denied.
13. The method of claim 8 , wherein the registration record includes a heartbeat field indicating the user is actively accessing the operational database.
14. The method of claim 13 , further comprising:
updating the heartbeat field to terminate a heartbeat thread when the user is done accessing the operational database.
15. A non-transitory computer readable medium having stored thereon instructions that cause a microprocessor to execute a method, the method comprising:
instructions to initiate an archive process on an operational database, wherein the archive process includes a sub-archive and a final archive, wherein the sub-archive comprises a plurality of sub-archives, and wherein the sub-archive and the final archive run in series;
instructions to initiate the sub-archive, wherein the sub-archive saves changes that have occurred since a previous final archive, wherein a number of sub-archives in the plurality of sub-archives is based on a number of outstanding changes in the operational database since a previous final archive, wherein a delay time between each of the plurality of sub-archives is based on the number of outstanding changes in the operational database since the previous final archive and a series of progressively smaller incremental time values, and wherein changes to the operational database are allowed during the sub-archive;
instructions to determine a request to access the operational database is received from a user, and in response to receiving the request from the user, create a registration record for the user, wherein when the user is done accessing the operational database or when the user's access has been terminated the registration record is deleted; and
instructions to determine if the registration record exists:
if the registration record exists, then instructions to not initiate the final archive; and
if the registration record does not exist, then instructions to initiate the final archive, wherein no changes are allowed to the operational database during the final archive.
16. The non-transitory computer readable medium of claim 15 , wherein the number of sub-archives is further based on at least one of:
a defined number of sub-archives; and
a maximum number of sub-archives.
17. The non-transitory computer readable medium of claim 15 , wherein the delay time of each of the plurality of sub-archives is further based on
an administered value.