Online tablespace recovery for export
First Claim
1. A method comprising performing a machine-executed operation involving instructions, wherein the machine-executed operation is at least one of:
- A) sending said instructions over transmission media;
B) receiving said instructions over transmission media;
C) storing said instructions onto a machine-readable storage medium; and
D) executing the instructions;
wherein said instructions are instructions which, when executed by one or more processors, cause 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; and
generating from a backup of said source database one or more tablespace instances for export of said one or more source tablespaces.
1 Assignment
0 Petitions
Accused Products
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.
87 Citations
20 Claims
-
1. A method comprising performing a machine-executed operation involving instructions, wherein the machine-executed operation is at least one of:
-
A) sending said instructions over transmission media;
B) receiving said instructions over transmission media;
C) storing said instructions onto a machine-readable storage medium; and
D) executing the instructions;
wherein said instructions are instructions which, when executed by one or more processors, cause 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; and
generating from a backup of said source database one or more tablespace instances for export of said one or more source tablespaces. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A method comprising performing a machine-executed operation involving instructions, wherein the machine-executed operation is at least one of:
-
A) sending said instructions over transmission media;
B) receiving said instructions over transmission media;
C) storing said instructions onto a machine-readable storage medium; and
D) executing the instructions;
wherein said instructions are instructions which, when executed by one or more processors, cause 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; and
recovering said one or more tablespace instances to a certain point-of-time based on redo logs for the source database. - View Dependent Claims (8, 9, 10)
-
-
11. A machine-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the 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; and
generating from a backup of said source database one or more tablespace instances for export of said one or more source tablespaces. - View Dependent Claims (12, 13, 14, 15, 16)
-
-
17. A machine-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the 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; and
recovering said one or more tablespace instances to a certain point-of-time based on redo logs for the source database. - View Dependent Claims (18, 19, 20)
-
Specification