Creating a "DR" like backup 1

[Exie]

Hi Folks,

I have an oracle DB instance sitting on Server1, then across an ADSL link I have another oracle instance on Server2.

I use Server2 for development work, and it has the same schemas as Server1, but with altered data.

I would like to backup one schema (eg. schemaA)from Server1 onto Server2 under and different schema name (eg. schemaB). This should be pretty straight forward.

....but I then want to keep updating Server2.schemaB from Server1.schemaA every night.

Is it possible to pickup the archive logs from server1 and replay all the transactions /changes from schemaA INTO schemaB on Server2.

... or perhaps I could use the redo logs ? or dump the tables and use diff or something <shrug>

Any tips ?

 

[stefanhei]

The easiest way to do this would be to use the tools exp (on server1 with option owner=schemaA) and imp (on server2 with option fromuser=schemaA and touser=schemaB).
You can't change owner with the archive-log method.

Stefan

 

[Exie]

Thanks!

The only catch with exp/imp is the whole schema is about 30GB, is there any way to do this incrementally ?

 

[stefanhei]

There's no standard incremental method I know of.
If you have a way to identify new records using your tables data the query-clause of export could help to build your own incrmental logic.
If the filesystem you use can handle 30GB the size is no issue for imp and exp.
A way to reduce the size is not to export indexes, but rebuild them by script in your target system.

 

[Exie]

Thanks, I'll see how I go.

I wasnt worried about the 30GB of disk, I was more worried about copying that over a modem link to get it over to the server.

If I cant extract delta's then I might just end up running another instance of oracle on ServerA, thats just going to make things a bit more tricky is all.

Thanks again.