xmeta restore

devanars · Post by **devanars** » Tue Dec 22, 2009 9:31 am

We are using only one server to store xmeta and busines tables. DBA use to take backup everyday for that server. we need to restore earlier day backup now.
here is the thing we are plannng to resore only database. is there any effect or correption for the datastage application if we do like this. Please advise guru's

ray.wurlod · Post by **ray.wurlod** » Tue Dec 22, 2009 4:00 pm

Assuming that XMETA was backed up properly (with the database quiesced or shut down and using database utilities) then you can restore objects in the database as at the time the backup was taken.

If there have been objects created or amended in the interim, their status may be undetermined. It depends on precisely why you need to restore how you need to proceed (total or partial restore) and requires both thoughtfulness and planning.

devanars · Post by **devanars** » Tue Dec 22, 2009 4:35 pm

Backup has been taken properly and need full restore.
If restore earlier backup, Application ( unix and websphere) are in sync or will go out of sync?

chulett · Post by **chulett** » Tue Dec 22, 2009 5:56 pm

Yes, what about the 'Universe' repository? Does that not need to stay in sync with XMETA?

devanars · Post by **devanars** » Wed Dec 23, 2009 8:53 am

If xmeta and Application are in sync then all are going to be in sycn i believe! what do you say?

ray.wurlod · Post by **ray.wurlod** » Wed Dec 23, 2009 4:07 pm

What about after you're restored an old version of XMETA ?

chulett · Post by **chulett** » Wed Dec 23, 2009 4:54 pm

That was my question - I don't see how you can restore XMETA back to an older copy without doing the same with the Universe repository. They are a matched set now.

devanars · Post by **devanars** » Wed Dec 23, 2009 5:33 pm

There is no change in Application. The change is with xmeta only. So Application objects will call required things from xmeta when ever necessary from the tool designer or director.
---------.
what is the procedure to take backup all together(universe repository and xmeta). at least i will try to maintain here after.

Sreenivasulu · Post by **Sreenivasulu** » Sat Dec 26, 2009 11:01 am

If there has been no change to the datastage jobs then you can use the backup of xmeta. no issues

Regards
Sreeni