tablespace (234 Views)
Reply
Regular Advisor
A.G.M. Velthof
Posts: 203
Registered: ‎02-18-2002
Message 1 of 6 (234 Views)

tablespace

Hello,

 

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

Please use plain text.
Super Advisor
ThierryT
Posts: 304
Registered: ‎06-05-2009
Message 2 of 6 (198 Views)

Re: tablespace

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

Please use plain text.
Regular Advisor
A.G.M. Velthof
Posts: 203
Registered: ‎02-18-2002
Message 3 of 6 (193 Views)

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

Please use plain text.
Valued Contributor
nikhil_d
Posts: 122
Registered: ‎09-21-2012
Message 4 of 6 (177 Views)

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.

Please use plain text.
Regular Advisor
A.G.M. Velthof
Posts: 203
Registered: ‎02-18-2002
Message 5 of 6 (161 Views)

Re: tablespace

Sorry, You are right.

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

 

Regards, Alfons

Please use plain text.
Valued Contributor
nikhil_d
Posts: 122
Registered: ‎09-21-2012
Message 6 of 6 (154 Views)

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.

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation