what is a rollback script

what is a rollback script..
tonydbaAsked:
Who is Participating?
 
Devinder Singh VirdiConnect With a Mentor Lead Oracle DBA TeamCommented:
Rollback term for DBAs generally goes to recovering data back to original.
Since you are asking rollback script, so I can assume:
1. You need to find if any session is doing rollback. Use V$transaction view to see which transaction will do rollback if get terminated or rollback signal.
2. You have DML script and need a backup plan if this script didn't provide desired results and need to revert data to original.
0
 
slightwv (䄆 Netminder) Commented:
Could be anything from a script that creates them to a script to report on them.

Can you provide some additional information?
0
 
Wasim Akram ShaikCommented:
Rollback Script in other terms would mean rollback steps, for suppose you are deploying/delivering a project on production environment

Incase the deliverable or deployment is a failure in such a case, there will be some plan to roll back such changes, in such event we will prepare rollback scripts..!!
0
 
DavidSenior Oracle Database AdministratorCommented:
AKA a "backout script".  Assuming that the install/upgrade steps are likewise documented, the backout dictates how to restore the environment to its pre-change image.  If a column datatype is modified, there must be a corresponding step to change it back.

It's never enough to just rely upon a "backup restore".  The installation, and the backout scripts, should be so specific that they could be followed by someone else in the author's absence.
0
 
tonydbaAuthor Commented:
Yes fine..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.