Database backup, refresh and cloning system and method
An automated physical database backup, refresh and cloning system and method automatically generates scripts or commands for implementing one or more tasks related to physical database backup and/or database and application refresh or cloning operations between a source environment and a target environment. The scripts or commands make use of parameters describing the source and target environments, at least some of which are gathered prior to initiating backup and cloning. The tasks are performed during one or more backup, refresh and cloning phases. In some embodiments, scripts are automatically regenerated and executed after a failure associated with the source or target environment.
1. An automated, physical database backup method for use in a database backup computer system including a source environment, a target environment, and a control environment, the method comprising:
in the control environment:
automatically determining parameters relating to the source environment and the target environment, wherein the source environment and the target environment have different configurations;
automatically generating scripts for initiating one or more tasks relating to database backup operations between the source environment and the target environment, wherein automatically generating scripts includes using at least one parameter and wherein at least one task includes:
determining if datafiles can be copied from the source environment to the target environment; and
generating a copy script for copying datafiles from the source environment to the target environment if copying is possible;
automatically recognizing a failure associated with at least one of the source environment and the target environments; and
automatically regenerating at least one script in response to the failure associated with at least one of the source environment and the target environments.
2. An automated, physical database backup method for use in a database backup computer system including a source environment, a target environment, and a control environment, the method comprising:
in the control environment:
automatically determining parameters relating to the source environment and the target environment, wherein the source environment and the target environment have different configurations;
automatically generating scripts for initiating one or more tasks relating to database backup operations between the source environment and the target environment, wherein automatically generating scripts includes using at least one parameter and wherein at least one task includes:
determining if datafiles can be copied from the source environment; and
generating a copy script for copying datafiles from the source environment to the target environment if copying is possible;
automatically recognizing a failure associated with at least one of the source environment and the target environments; and
automatically regenerating at least one script in response to the failure associated with at least one of the source environment and the target environments.
3. An automated, physical database backup method for use in a database backup computer system including a source environment, a target environment, and a control environment, the method comprising:
in the control environment:
automatically determining parameters relating to the source environment and the target environment, wherein the source environment and the target environment have different configurations;
automatically generating scripts for initiating one or more tasks relating to database backup operations between the source environment and the target environment, wherein automatically generating scripts includes using at least one parameter and wherein at least one task includes:
determining if target schemas are to be preserved; and
generating scripts for preserving target schemas if target schemas are to be preserved;
automatically recognizing a failure associated with at least one of the source environment and the target environments; and
automatically regenerating at least one script in response to the failure associated with at least one of the source environment and the target environments.
4. An automated, physical database backup method for use in a database backup computer system including a source environment, a target environment, and a control environment, the method comprising:
in the control environment:
automatically determining parameters relating to the source environment and the target environment, wherein the source environment and the target environment have different configurations;
automatically generating scripts for initiating one or more tasks relating to database backup operations between the source environment and the target environment, wherein automatically generating scripts includes using at least one parameter and wherein at least one task includes:
determining if target tables are to be preserved; and
generating scripts for preserving target tables if target tables are to be preserved;
automatically recognizing a failure associated with at least one of the source environment and the target environments; and
automatically regenerating at least one script in response to the failure associated with at least one of the source environment and the target environments.