Data Protector Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

tablespace

Valued Contributor

tablespace

Hello,

 

is there a way to recover a tablespace (schema) within dataprotector?

5 REPLIES
Super Advisor Super Advisor

Re: tablespace

this is very vague...more details/versions/explain what u trying to achieve etc etc....

Valued Contributor

Re: tablespace

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?

 

Regards, Alfons

Valued Contributor

Re: tablespace

Hi,

 

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.

Valued Contributor

Re: tablespace

Sorry, You are right.

It is DP 7.01, Oracle 10.2.04 the OS is HPUX ia11.31

 

Regards, Alfons

Highlighted
Valued Contributor

Re: tablespace

Hi Alfons,

 

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:

http://docs.oracle.com/cd/B12037_01/server.101/b10734/rcmtspit.htm

 

Regards,

Nikhil

 

PS: If it is a common occurance (to restore one schema) then it would be better to configure flashback, its much faster and seamless.