# US 7,610,314 B2 · Online tablespace recovery for export > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 7,610,314 B2 - Document ID: US7610314B2 - Status: Granted - Kind: B2 - Application number: 11/245,589 - Filed: 2005-10-07 - Published: 2007-04-12 - Granted: 2009-10-27 - Earliest claimed: 2005-10-07 - Assignees: Oracle International Corporation - Inventors: Benny Souder; James Stamos; Hung Tran; Francisco Sanchez; Lik Wong - Web page: https://patentgrep.com/patent/US7610314B2 ## CPC - G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor - Y10S 707/99931: Database or file accessing - Y10S 707/99953: Recoverability - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - Y10S: TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS ## Abstract To export source tablespaces, an auxiliary database system is created and started with a minimum configuration. Copies of versions of the source tablespaces are restored from database backups to the auxiliary database system. A copy of a version of a tablespace is referred to herein as a tablespace instance. The tablespace instances restored from database backups are recovered to a particular point-in-time. A script is then generated. The script can be executed by a database server of the destination database to import the tablespace instances. ## Claims ### Claim 1 A computer-implemented method, comprising: receiving a request to export one or more source tablespaces from a source database that includes a plurality of tablespaces, said plurality of tablespaces including said one or more source tablespaces; and in response to receiving said request, performing certain steps to export said one or more source tablespaces, said certain steps comprising: creating an auxiliary database system on a node, said auxiliary database system comprising an auxiliary database server and an auxiliary database; generating from a backup of said source database one or more tablespace instances for export of said one or more source tablespaces; and incorporating said one or more tablespace instances into said auxiliary database; wherein the method is performed by one or more computing devices. ### Claim 2 (depends on 1) The method of claim 1, wherein the certain steps include recovering said one or more tablespace instances to a certain point-of-time based on redo logs for said source database. ### Claim 3 (depends on 2) The method of claim 2, wherein the point-in-time is user-selected. ### Claim 4 (depends on 1) The method of claim 1, wherein creating an auxiliary database system includes creating the auxiliary database system on a node that already hosts another database server. ### Claim 5 (depends on 4) The method of claim 4, wherein the auxiliary database server and said another database server comprise the same executable software. ### Claim 6 (depends on 1) The method of claim 1, wherein after completing the generation of said one or more tablespace instances for export, removing said auxiliary database system from said node. ### Claim 7 (depends on 1) The method of claim 1, wherein the specific source tablespaces to be exported are user-selected. ### Claim 8 (depends on 1) The method of claim 1, wherein the auxiliary database system comprises a minimum configuration sufficient to support restoration and recovery of the source tablespaces. ### Claim 9 (depends on 1) The method of claim 1, further comprising: generating a metadata dump file describing one or more of the source tablespaces; and generating a script written in commands executable by a database server for attaching the one or more source tablespaces to the auxiliary database. ### Claim 10 A computer-implemented method, comprising: receiving a request to export one or more source tablespaces from a source database that includes a plurality of tablespaces, said plurality of tablespaces including said one or more source tablespaces; and in response to receiving said request, performing certain steps to export said one or more source tablespaces, said certain steps comprising: creating an auxiliary database system on a node, said auxiliary database system comprising an auxiliary database server and auxiliary database; restoring from a backup of said source database one or more tablespace instances of said one or more source tablespaces; recovering said one or more tablespace instances to a certain point-of-time based on redo logs for the source database; and incorporating said one or more table space instances into said auxiliary database; wherein the method is performed by one or more computing devices. ### Claim 11 (depends on 10) The method of claim 10, wherein creating an auxiliary database system includes creating the auxiliary database system on a node that already hosts another database server. ### Claim 12 (depends on 10) The method of claim 10, wherein after recovering said one or more tablespace instances, removing said auxiliary database system from said node. ### Claim 13 (depends on 10) The method of claim 10, further comprising: generating a metadata dump file describing one or more of the source tablespaces; and generating a script written in commands executable by a database server for attaching the one or more source tablespaces to the auxiliary database. ### Claim 14 A machine-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the steps of: receiving a request to export one or more source tablespaces from a source database that includes a plurality of tablespaces, said plurality of tablespaces including said one or more source tablespaces; and in response to receiving said request, performing certain steps to export said one or more source tablespaces, said certain steps comprising: creating an auxiliary database system on a node, said auxiliary database system comprising an auxiliary database server and auxiliary database; generating from a backup of said source database one or more tablespace instances for export of said one or more source tablespaces; and incorporating said one or more table space instances into said auxiliary database. ### Claim 15 (depends on 14) The machine-readable storage medium of claim 14, wherein the certain steps include recovering said one or more tablespace instances to a certain point-of-time based on redo logs for said source database. ### Claim 16 (depends on 15) The machine-readable storage medium of claim 15, wherein the point-in-time is user-selected. ### Claim 17 (depends on 14) The machine-readable storage medium of claim 14, wherein creating an auxiliary database system includes creating the auxiliary database system on a node that already hosts another database server. ### Claim 18 (depends on 17) The machine-readable storage medium of claim 17, wherein the auxiliary database server and said another database server comprise the same executable software. ### Claim 19 (depends on 14) The machine-readable storage medium of claim 14, wherein after completing the generation of said one or more tablespace instances for export, removing said auxiliary database system from said node. ### Claim 20 (depends on 14) The machine-readable storage medium of claim 14, the steps further comprising: generating a metadata dump file describing one or more of the source tablespaces; and generating a script written in commands executable by a database server for attaching the one or more source tablespaces to the auxiliary database. ### Claim 21 (depends on 14) The machine-readable storage medium of claim 14, wherein the specific source tablespaces to be exported are user-selected. ### Claim 22 (depends on 14) The machine-readable storage medium of claim 14, wherein the auxiliary database system comprises a minimum configuration sufficient to support restoration and recovery of the source tablespaces. ### Claim 23 A machine-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the steps of: receiving a request to export one or more source tablespaces from a source database that includes a plurality of tablespaces, said plurality of tablespaces including said one or more source tablespaces; and in response to receiving said request, performing certain steps to export said one or more source tablespaces, said certain steps comprising: creating an auxiliary database system on a node, said auxiliary database system comprising an auxiliary database server and auxiliary database; restoring from a backup of said source database one or more tablespace instances of said one or more source tablespaces; recovering said one or more tablespace instances to a certain point-of-time based on redo logs for the source database; and incorporating said one or more table space instances into said auxiliary database. ### Claim 24 (depends on 23) The machine-readable storage medium of claim 23, wherein creating an auxiliary database system includes creating the auxiliary database system on a node that already hosts another database server. ### Claim 25 (depends on 23) The machine-readable storage medium of claim 23, wherein after recovering said one or more tablespace instances, removing said auxiliary database system from said node. ### Claim 26 (depends on 23) The machine-readable storage medium of claim 23, the steps further comprising: generating a metadata dump file describing one or more of the source tablespaces; and generating a script written in commands executable by a database server for attaching the one or more source tablespaces to the auxiliary database.