Utilizing a tablespace to export to a native database recovery environment

1. A system comprising:

at least one processor and memory having instructions that, when executed, cause the at least one processor to perform operations comprising:

receiving file information and script information, over a network, via directories, at a source host operating in a native database recovery environment, the file information and the script information being received from a backup host, the backup host utilizing foreign snapshot files and foreign incremental files for storing the file information, the file information including native snapshot files and native incremental files, the script information including scripts that execute, at the source host, to further perform operations comprising:

mounting the directories;

opening an auxiliary database;

restoring a tablespace in the auxiliary database based on the native snapshot files and a tablespace identifier identifying the tablespace;

recovering the tablespace in the auxiliary database based on the native incremental files, the recovery including application of incremental changes to the auxiliary database to recover the tablespace in the auxiliary database to a point-in-time that was selected at the backup host;

exporting tablespace metadata information from the auxiliary database;

recovering the tablespace in a database based on the tablespace metadata information; and

unmounting the directories.

2. The system of claim 1 , wherein the recovering the tablespace in the database based on the tablespace metadata information further comprises:

importing the tablespace metadata information into the database;

restoring the tablespace in the database based on the native snapshot files and the tablespace identifier; and

recovering the tablespace in the database based on the native incremental files and the tablespace identifier, the recovery including application of the incremental changes to the database to recover the tablespace to the point-in-time that was selected.

3. The system of claim 1 , wherein the database includes a wholesale distribution database and wherein the tablespace includes a shipping table and wherein the shipping table includes a plurality of rows of shipping information.

4. The system of claim 1 , wherein the native snapshot files include snapshots of an image of the database and the native incremental files include incremental changes to the image of the database and wherein the incremental changes include transactions.

5. The system of claim 1 , wherein the receiving the file information and the script information, via the directories, at the source host includes utilizing a network file system protocol to receive the file information and script information, via the directories, at the source host.

6. The system of claim 1 , wherein the restoring the tablespace in the auxiliary database includes restoring the auxiliary database based on a native control file.

7. The system of claim 1 , wherein the database is a standalone database and the source host includes a first node including a source node.

8. The system of claim 1 , wherein the source host comprises a plurality of nodes that store a cluster database.

9. The system of claim 1 , wherein the instructions cause the at least one processor to perform operations further comprising:

receiving a backup agent at the source host; and

automatically discovering the database on the source host.

10. A method comprising:

receiving file information and script information, over a network, via directories, at a source host operating in a native database recovery environment, the file information and the script information being received from a backup host, the backup host utilizing foreign snapshot files and foreign incremental files for storing the file information, the file information including native snapshot files and native incremental files, the receiving the file information and the script information being performed by at least one processor, the script information including scripts that execute, at the source host, to further perform operations comprising:

mounting the directories;

opening an auxiliary database;

restoring a tablespace in the auxiliary database based on the native snapshot files and a tablespace identifier identifying the tablespace;

recovering the tablespace in the auxiliary database based on the native incremental files, the recovery including application of incremental changes to the auxiliary database to recover the tablespace in the auxiliary database to a point-in-time that was selected at the backup host;

exporting tablespace metadata information from the auxiliary database;

recovering the tablespace in a database based on the tablespace metadata information; and

unmounting the directories.

11. The method of claim 10 , wherein the recovering the tablespace in the database based on the tablespace metadata information further comprises:

importing the tablespace metadata information into the database;

restoring the tablespace in the database based on the native snapshot files and the tablespace identifier; and

recovering the tablespace in the database based on the native incremental files and the tablespace identifier, the recovery including application of the incremental changes to the database to recover the tablespace to the point-in-time that was selected.

12. The method of claim 10 , wherein the database includes a wholesale distribution database and wherein the tablespace includes a shipping table and wherein the shipping table includes a plurality of rows of shipping information.

13. The method of claim 10 , wherein the native snapshot files include snapshots of an image of the database and the native incremental files include incremental changes to the image of the database and wherein the incremental changes include transactions.

14. The method of claim 10 , wherein the receiving the file information and the script information, via the directories, at the source host includes utilizing a network file method protocol to receive the file information and script information, via the directories, at the source host.

15. The method of claim 10 , wherein the restoring the tablespace in the auxiliary database includes restoring the auxiliary database based on a native control file.

16. The method of claim 10 , wherein the database is a standalone database and the source host includes a first node including a source node.

17. The method of claim 10 , wherein the source host comprises a plurality of nodes that store a cluster database.

18. The method of claim 10 , further comprising:

receiving a backup agent at the source host; and

automatically discovering the database on the source host.

19. A machine-storage medium storing a set of instructions that, when executed by a processor, causes a machine to perform operations comprising:

receiving file information and script information, over a network, via directories, at a source host operating in a native database recovery environment, the file information and the script information being received from a backup host, the backup host utilizing foreign snapshot files and foreign incremental files for storing the file information, the file information including native snapshot files and native incremental files, the script information including scripts that execute, at the source host, to further perform operations comprising:

mounting the directories;

opening an auxiliary database;

restoring a tablespace in the auxiliary database based on the native snapshot files and a tablespace identifier identifying the tablespace;

recovering the tablespace in the auxiliary database based on the native incremental files, the recovery including application of incremental changes to the auxiliary database to recover the tablespace in the auxiliary database to a point-in-time that was selected at the backup host;

exporting tablespace metadata information from the auxiliary database;

recovering the tablespace in a database based on the tablespace metadata information; and

unmounting the directories.

20. The machine-storage medium of claim 19 , wherein the recovering the tablespace in the database based on the tablespace metadata information further comprises:

importing the tablespace metadata information into the database;

restoring the tablespace in the database based on the native snapshot files and the tablespace identifier; and

recovering the tablespace in the database based on the native incremental files and the tablespace identifier, the recovery including application of the incremental changes to the database to recover the tablespace to the point-in-time that was selected.