Eric M Russell (5/8/2015)

---

Bradley Deem (5/7/2015)

---

Phil Parkin (5/7/2015)

---

'Flashback'. What is that?

Sorry, Oracle terminology. In SQL Server this would be Snapshot. Regardless, use technology to allow you to rollback to the point in time before deployment without the need of a restore operation. I've edited my previous post for clarification.

Has anyone here actually used Dabase Snapshots to rollback a deployment? Will it rollback only DML and DDL modifications made by your session, or is it a point in time rollback for the entire database?

Oracle's Flashback featureset goes well beyond SQL Server snapshots. For example, they have some interesting SELECT statement extensions for querying previous versions of table rows.

-- The following query retrieves the state of the employee record for JOHN at 9:30AM, April 4, 2003:

SELECT * FROM employee AS OF TIMESTAMP

TO_TIMESTAMP('2003-04-04 09:30:00', 'YYYY-MM-DD HH:MI:SS')

WHERE name = 'JOHN';

-- This update then restores John's information to the employee table:

INSERT INTO employee

(SELECT * FROM employee AS OF TIMESTAMP

TO_TIMESTAMP('2003-04-04 09:30:00', 'YYYY-MM-DD HH:MI:SS')

WHERE name = 'JOHN');

http://docs.oracle.com/cd/B13789_01/appdev.101/b10795/adfns_fl.htm