Solved

what is a rollback script

Posted on 2014-04-01
5
476 Views
Last Modified: 2014-04-06
what is a rollback script..
0
Comment
Question by:tonydba
5 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39970316
Could be anything from a script that creates them to a script to report on them.

Can you provide some additional information?
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39970348
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
 
LVL 23

Expert Comment

by:David
ID: 39970416
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
 
LVL 15

Accepted Solution

by:
Devinder Singh Virdi earned 500 total points
ID: 39970853
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
 

Author Closing Comment

by:tonydba
ID: 39981691
Yes fine..
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Action link in Union Reports Not Working in OBIEE 11g 1 56
data lookup in Oracle - need suggestions 55 104
Oracle query output question 4 36
Oracle Pivot Question 8 45
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to recover a database from a user managed backup

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now