Restore using DSA with NO BUILD option.

Database
Enthusiast

Restore using DSA with NO BUILD option.

Hi,

I have a large restore around 5 TB, I'm using DSA to Backup and restore. I want to restore with NO BUILD option and BUILD the tables separately using ARCMAIN(Build Data Table (xx.yy) ...) . I do not find no build option in DSA. Can anybody help? 

I could do the same thing in TARA by unchecking BUILD option and build separately.

Any help will be highly appreciated.

3 REPLIES
Junior Supporter

Re: Restore using DSA with NO BUILD option.

Tables which are being restored using DSA cannot be built by BUILD command using ARCMAIN.

DSA restore job will automatically perform the build as one of the job phases.


Abhishek Jadhav
Enthusiast

Re: Restore using DSA with NO BUILD option.

Thanks Abhishek for your reply. My question was, is it possible to  BUILD the table separately after restore completed with NO BUILD just like ARCMAIN.

Anyway I got the answer from TD university course 51409.

Thaks.

Enthusiast

Re: Restore using DSA with NO BUILD option.

You might be abe to prevent the BUILD phase to complte by removing the access rigihts that it requres.