Utilizing a tablespace to export to a native database recovery environment
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.
1 . 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.
2 . The apparatus of claim 1 , wherein, to retrieve the file information, the instructions are executable by the at least one processor to cause the apparatus to:
retrieve the snapshot files and the incremental files from one or more databases in the foreign database recovery environment based on using the identifier of the tablespace to query the one or more databases.
3 . The apparatus of claim 1 , wherein the instructions are further executable by the at least one processor to cause the apparatus to:
receive, after exporting the file information and the script information to the source host, one or more images of the native database from the source host; and
generate updated snapshot files and incremental files for the native database based on the one or more images received from the source host.
4 . The apparatus of claim 1 , the instructions are further executable by the at least one processor to cause the apparatus to:
establish a connection between the source host and the backup host via one or more directories, wherein the file information and the script information are exported to the source host using the established connection.
5 . The apparatus of claim 1 , wherein:
the snapshot files comprise images of files and directories stored in the native database; and
the incremental files indicate changes made to the native database between a first point-in-time and a second point-in-time.
6 . The apparatus of claim 1 , wherein:
the source host comprises a first set of one or more virtual machines operating in the native database recovery environment; and
the backup host comprises a second set of one or more virtual machines operating in the foreign database recovery environment.
7 . The apparatus of claim 1 , wherein the foreign database recovery environment is configured to provide backup and recovery services for the native database recovery environment.
8 . The apparatus of claim 1 , wherein the foreign database recovery environment is different from the native database recovery environment.
9 . A computer-implemented method, comprising:
receiving, 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;
executing a job at a backup host operating in the foreign database recovery environment based on the export information, wherein executing the job further comprises:
generating 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
retrieving file information that comprises snapshot files and incremental files associated with the native database in which the tablespace is stored; and
exporting the file information and the script information from the backup host to a source host operating in the native database recovery environment.
10 . The computer-implemented method of claim 9 , wherein retrieving the file information comprises:
retrieving the snapshot files and the incremental files from one or more databases in the foreign database recovery environment based on using the identifier of the tablespace to query the one or more databases.
11 . The computer-implemented method of claim 9 , further comprising:
receiving, after exporting the file information and the script information to the source host, one or more images of the native database from the source host; and
generating updated snapshot files and incremental files for the native database based on the one or more images received from the source host.
12 . The computer-implemented method of claim 9 , further comprising:
establishing a connection between the source host and the backup host via one or more directories, wherein the file information and the script information are exported to the source host using the established connection.
13 . The computer-implemented method of claim 9 , wherein:
the snapshot files comprise images of files and directories stored in the native database; and
the incremental files indicate changes made to the native database between a first point-in-time and a second point-in-time.
14 . The computer-implemented method of claim 9 , wherein:
the source host comprises a first set of one or more virtual machines operating in the native database recovery environment; and
the backup host comprises a second set of one or more virtual machines operating in the foreign database recovery environment.
15 . The computer-implemented method of claim 9 , wherein the foreign database recovery environment is configured to provide backup and recovery services for the native database recovery environment.
16 . The computer-implemented method of claim 9 , wherein the foreign database recovery environment is different from the native database recovery environment.
17 . 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.
18 . The non-transitory computer-readable medium of claim 17 , wherein, to retrieve the file information, the instructions are executable by the at least one processor to:
retrieve the snapshot files and the incremental files from one or more databases in the foreign database recovery environment based on using the identifier of the tablespace to query the one or more databases.
19 . The non-transitory computer-readable medium of claim 17 , wherein the instructions are further executable by the at least one processor to:
receive, after exporting the file information and the script information to the source host, one or more images of the native database from the source host; and
generate updated snapshot files and incremental files for the native database based on the one or more images received from the source host.
20 . The non-transitory computer-readable medium of claim 17 , wherein the instructions are further executable by the at least one processor to:
establish a connection between the source host and the backup host via one or more directories, wherein the file information and the script information are exported to the source host using the established connection.