| Using Data Pump in Oracle 10g? [message #207494] |
Tue, 05 December 2006 15:10  |
Rustican
Messages: 51
Registered: July 2006
|
Member |
|
|
Is anyone familiar with using the Oracle 10g data pump tool? I'm setting up a back up database on another system and would like to transfer data from my main system to my back up.
If i only want to transfer the changes that occured since the last back up is there a method of using the data pump to only extract the delta? Is it possible to do this using the system change numbers?
thanks!
|
|
|
|
|
|
|
|
|
|
| Re: Using Data Pump in Oracle 10g? [message #208958 is a reply to message #208241] |
Tue, 12 December 2006 13:15  |
Rustican
Messages: 51
Registered: July 2006
|
Member |
|
|
On the Orcle Data Pump info page it said that Data pump supported "Fine-Grained Object Selection". LINK: http://www.oracle.com/technology/products/database/utilities/htdocs/data_pump_overview.html
In particular i was interested in
| Quote: | The QUERY parameter filters data by specifying a clause for a SQL SELECT statement, which is applied to all tables in the export job or to a specific table.
|
I was thinking of using Data Pump with a QUERY parameter filter to select particular data that i wanted to move to my back up database. Like all the records where customer_id = 12345. Or if i can use the database (SCN) status change numbers to get all the records after a certain date.
|
|
|
|
| Re: Using Data Pump in Oracle 10g? [message #208959 is a reply to message #208958] |
Tue, 12 December 2006 13:19 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>Like all the records where customer_id = 12345
That is possible. But you have to do it for every table. Cannot 'filter' based on date/scn (unless you have a date as column in table).
>>if i can use the database (SCN) status change numbers to get all the records after a certain date.
Exp/imp/expd/impdp are not capabale of doing this.
RMAN can do this.
[Updated on: Tue, 12 December 2006 13:19] Report message to a moderator |
|
|
|
| Re: Using Data Pump in Oracle 10g? [message #209150 is a reply to message #208959] |
Wed, 13 December 2006 09:13 |
Rustican
Messages: 51
Registered: July 2006
|
Member |
|
|
[quote title=Mahesh Rajendran wrote on Tue, 12 December 2006 13:19]>>Like all the records where customer_id = 12345
That is possible. But you have to do it for every table. Cannot 'filter' based on date/scn (unless you have a date as column in table).[quote]
Will RMAN let me do filtering against the database where customer_id = 12345? Basically i want to replicate a subset of data from my production to my backup server and continue to update it incrementally.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Using Data Pump in Oracle 10g? [message #211823 is a reply to message #209974] |
Tue, 02 January 2007 08:22 |
Rustican
Messages: 51
Registered: July 2006
|
Member |
|
|
I'm currently attempting to set up streams for my production database and am using the Oracle enterprise Manager to do so.
I've set up ARCHIVELOG mode on my database. No i'm using the 'Streams Global, Schema, Table and Subset Replication Wizard' in the Oracle enterprise Manager.
I'm at the point where it asks for my destination database which i assume is my back up database. But my back up database is not connected to any network so i'm not sure how to get past that.
I just want the streams to capture changes that i can export to the datapump or RMAN. Not exactly sure how to set it up.
I'm following the guide below using the 'Streams Tablespace Replication Wizard': http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14228/config_simple.htm#CACJHBBI
Do you have any experience with this? Thanks.
|
|
|
|
|
|
|
|
| Re: Using Data Pump in Oracle 10g? [message #213196 is a reply to message #211827] |
Tue, 09 January 2007 14:54 |
Rustican
Messages: 51
Registered: July 2006
|
Member |
|
|
| Mahesh Rajendran wrote on Tue, 02 January 2007 08:41 | >> But my back up database is not connected to any network
None of the options we discussed would work then.
In that case, export/import is the only option.
As we said before the only other option is to setup a remote standby database.
You can just copy the archivedlogs/backupsets and apply the changes there.
|
So can i set up a remote to my production server, use the streams to filter the data i need to the remote server. Then use RMAN to get the export of the remote to load my back up server?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
