Online tablespace recovery for export

• US 7,610,314 B2
• Filed: 10/07/2005
• Issued: 10/27/2009
• Est. Priority Date: 10/07/2005
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Wong, Lik, Tran, Hung, Souder, Benny, Stamos, James, Sanchez, Francisco
• Primary Examiner(s): Fleurantin; Jean B
• Application Number:
  US11/245,589
• Publication Number:
  US 20070083563A1
• Time in Patent Office: 1,481 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-206, 709/203, 711/161, 711/162
• US Class Current: 1/1
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99953 Recoverability

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

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.

2. 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.

3. The method of claim 2, wherein the point-in-time is user-selected.

4. 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.

5. The method of claim 4, wherein the auxiliary database server and said another database server comprise the same executable software.

6. 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.

7. The method of claim 1, wherein the specific source tablespaces to be exported are user-selected.

8. The method of claim 1, wherein the auxiliary database system comprises a minimum configuration sufficient to support restoration and recovery of the source tablespaces.

9. 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.

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.

11. 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.

12. The method of claim 10, wherein after recovering said one or more tablespace instances, removing said auxiliary database system from said node.

13. 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.

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.

15. 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.

16. The machine-readable storage medium of claim 15, wherein the point-in-time is user-selected.

17. 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.

18. The machine-readable storage medium of claim 17, wherein the auxiliary database server and said another database server comprise the same executable software.

19. 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.

20. 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.

21. The machine-readable storage medium of claim 14, wherein the specific source tablespaces to be exported are user-selected.

22. 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.

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.

24. 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.

25. 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.

26. 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.