Optimizing utilization of a tablespace for exporting from a foreign database recovery environment

A method comprising:

• receiving a database from a source host operating in a native database recovery environment, the database being received at a backup host operating in a foreign database recovery environment, the foreign database recovery environment utilizing foreign snapshot files and foreign incremental files for storing the database, the receiving the database being performed by at least one processor;
• receiving export information at the backup host, the export information including a tablespace identifier that identifies a tablespace including tablespace metadata information and a point-in-time that identifies file information for export from the backup host to the source host, the source host operating in the native database recovery environment;
• initiating a job, on the backup host, responsive to receiving the export information, the job executing to cause the at least one processor to perform operations further comprising:
• generating script information based on the export information, the script information including scripts including logic for execution on the source host to import of the tablespace metadata information, at the point-in-time, to the database on the source host;
• creating one or more directories on the backup host based on the export information;
• materializing the file information on the backup host, the file information including native snapshot files and native incremental files;
• utilizing an auxiliary database, at the backup host, to generate tablespace metadata information based on the file information;
• and
• communicating the tablespace metadata information and the script information and the file information, via the directories, and over a network, to the source host, to enable the source host to recover the tablespace in the database in the native database recovery environment.

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

• receiving a database from a source host operating in a native database recovery environment, the database being received at a backup host operating in a foreign database recovery environment, the foreign database recovery environment utilizing foreign snapshot files and foreign incremental files for storing the database;
• receiving export information at the backup host, the export information including a tablespace identifier that identifies a tablespace including tablespace metadata information and a point-in-time that identifies file information for export from the backup host to the source host, the source host operating in the native database recovery environment;
• initiating a job, on the backup host, responsive to receiving the export information, the job executing to cause the at least one processor to perform operations further comprising:
• generating script information based on the export information, the script information including scripts including logic for execution on the source host to import of the tablespace metadata information, at the point-in-time, to the database on the source host;
• creating one or more directories on the backup host based on the export information;
• materializing the file information on the backup host, the file information including native snapshot files and native incremental files;
• utilizing an auxiliary database, at the backup host, to generate tablespace metadata information based on the file information;
• and
• communicating the tablespace metadata information and the script information and the file information, via the directories, and over a network, to the source host, to enable the source host to recover the tablespace in the database in the native database recovery environment.