Restores using Incrementals

From: mkb <mkb125NOmkSPAM_at_yahoo.com.invalid>
Date: 2000/07/05
Message-ID: <06b8403a.b77f2489@usw-ex0104-031.remarq.com>#1/1

Here's a scenario I'd like some comments on.

I have a production database and need to sync it up using export/import.

Day 1
I do a full export from production and restore to test.

Day 2
I do an incremental from production, and restore using imp inctype=system followed by imp inctype=restore.

Day 3
To keep in sync repeat steps from Day 2...

I assume that the test db can only be read-only since if anything changes, I'll need to retore the full export from Day 1 and apply the incrementals.

So, is this feasible, or will I have to restore the full exports each day?

Thanks

mkb

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 05 2000 - 00:00:00 CDT