Hi,
One of the tables in our database has been effected with wrong updation. Our intention was to update some 5 records at once, but 24000 records out of 1 million records are updated due to lack of specific condition.
Is there any way other approaching DBA where we can roll back the update and bring back the records to its previous status?
Is there any way other approaching DBA where we can roll back the update and bring back the records to its previous status?
once a program has properly terminated, the changes have been committed and no roll backs are possible
You just incurred in a programming/analysis error and as such must be fixed by other means than standared Data Base utilities
... if there is an image copy available of the table before the_wrong_program_execution
You might ask support to reload it and operations to rerun all the jobs affecting the table in question
but You need to carefully coordinate everything
The updation happened was on test data base. We wanted to know if there is any process that can be done to roll back the updations.
Any way...next course of action is taken.
Joined: 19 May 2007 Posts: 989 Location: Virginia, USA
You can do a recover to a point in time if there have been no updates since your mass updates but if there are foreign keys you will have to check these and if your mass update caused any cascading changes you would have to fix those also. It is best to ask the DBA for help.
