• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 658
  • Last Modified:

what is a rollback script

what is a rollback script..
1 Solution
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?
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..!!
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.
Devinder Singh VirdiLead 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.
tonydbaAuthor Commented:
Yes fine..
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.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now