Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 634
  • Last Modified:

what is a rollback script

what is a rollback script..
0
tonydba
Asked:
tonydba
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?
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
 
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.
0
 
tonydbaAuthor Commented:
Yes fine..
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

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