07-04-2013 02:10 AM
We are using DataProtector to backup and restore/recover our databases.
For one particular schema we want to do an upgrade and make a recovery point at some time.
To achieve that I could make an export and import it again after a failure durin the upgrade.
Perhaps it is easier to perform a tabelspace recovery for that schema in time and use DataProtector for that?
07-05-2013 06:57 AM
sorry to be very picky....but still I do not see the database vendor name / version / DP Version / Client OS etc. anywhere in the post.
Since you mention tablespace, is it Oracle? If so, rman provides a way to restore single tablespace, you might want to take a look at that.
07-08-2013 04:06 AM
usually Oracle tablespace restore to a point in time is a very tedious process consuming much time. Also you should note that when you restore a tablespacce to a particular point in time (say X), then the backups done before X are unusable, so we've had a case when the developer "thought" that one particular version was good for him, and we went through the ordeal, but it turned out that he had introduced the problem before the restored version, but we did not have any possibility to go back, we had to restore to another instance and recover till the other point in time.
Anyway, there is a good documentation about it from Oracle side:
PS: If it is a common occurance (to restore one schema) then it would be better to configure flashback, its much faster and seamless.