July 10, 2004 at 12:16 pm
Issue: We have recently installed the PeopleSoft financials system at our company. We are in the process of formulating a disaster recovery plan. If we should have an issue with 1 business Unit and restoring the database is the only choice..... We want to know if restoring the database by business unit is an option ?
In our legacy System the business units have their own files. Hence you can restore files for 1 business unit without impacting the others.
Details:
It has been proposed that we get a list of the tables and our system support team would restore the entire database to a test environment. They would then pull out the data for the necessary business Unit and copy it over to production. This way the other business units would not loose all of their work. We are especially concerned about trying to recovery from AR_UPDATE and Payment Predictor abends.
Help:
We would like to get the opinion of others and know for sure if it is reasonable to try to restore the database for 1 business Unit only.
Any input would be appreciated.
Thank you,
Jvann67@bekco.com
July 12, 2004 at 11:23 am
This sounds like a legacy minded solution. While it would probably work, when working with a database, recovery from abends *should* be painless if well written due to transaction logging within the database. The basic idea is that you start a transaction, do your updates and end the transaction. If anything fails between the start of the transaction and the end of the transaction, the entire posting fails and is backed out automatically.
Good Luck!
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply