US 2025/0086070 A1 · UTILIZING A TABLESPACE TO EXPORT TO A NATIVE DATABASE RECOVERY ENVIRONMENT

Abstract

Systems and methods to utilize a tablespace to export to a native database recovery environment are described. The system receives file information and script information at a source host that operates in a native database recovery environment. The file information and the script information are received from a backup host that utilizes foreign snapshot files and foreign incremental files for storing the file information. The file information includes native snapshot files and native incremental files. The script information includes one or more scripts that execute, at the source host, to perform operations comprising: mounting the directories; opening an auxiliary database; restoring a tablespace in the auxiliary database; recovering the tablespace in the auxiliary database based on the native incremental files; exporting the tablespace metadata information from the auxiliary database; recovering the tablespace in the database based on the tablespace metadata information; and unmounting the directories.

Claims20

Dependent claims

An apparatus, comprising:

at least one processor;
memory coupled to the at least one processor;
and
instructions stored in the memory, wherein the instructions are executable by the at least one processor to:
receive, at a foreign database recovery environment, export information that indicates an identifier of a tablespace and a point-in-time to which the tablespace is to be recovered, wherein the tablespace is stored at a native database in a native database recovery environment;
execute a job at a backup host operating in the foreign database recovery environment based on the export information, wherein the instructions to execute the job are executable by the at least one processor to:
generate script information based on the export information, the script information comprising scripts for recovering the tablespace at the point-in-time in the native database recovery environment;
and
retrieve file information that comprises snapshot files and incremental files associated with the native database in which the tablespace is stored;
and
export the file information and the script information from the backup host to a source host operating in the native database recovery environment.

8 more elements

A non-transitory computer-readable medium storing code, the code comprising instructions executable by at least one processor to:

receive, at a foreign database recovery environment, export information that indicates an identifier of a tablespace and a point-in-time to which the tablespace is to be recovered, wherein the tablespace is stored at a native database in a native database recovery environment;
execute a job at a backup host operating in the foreign database recovery environment based on the export information, wherein the instructions to execute the job are executable by the at least one processor to:
generate script information based on the export information, the script information comprising scripts for recovering the tablespace at the point-in-time in the native database recovery environment;
and
retrieve file information that comprises snapshot files and incremental files associated with the native database in which the tablespace is stored;
and
export the file information and the script information from the backup host to a source host operating in the native database recovery environment.

4 more elements

Dependencies are inferred from the claim text.

Utilizing a tablespace to export to a native database recovery environment

Life of this patent

Utilizing a tablespace to export to a native database recovery environment

Life of this patent

Abstract

Claims20