Rollback
In order for DROPS to carry out the rollback process, certain systems and/or databases must conform to the following administrative prerequisites.
SQL Server rollback has been developed with SQL Server 2014 Express Edition version 12.0. The database to roll back must be in FULL recovery model. To perform the rollback, DROPS connects to the SQL Server database with the same user login as the application login to roll back.
Features not supported
- Data types: hierarchyid, spatial types, text, ntext, image, varchar(max), nvarchar(max), varbinary(max), sql_variant, table, xml, cursor, udt.
- Row > 8060 bytes
- Rollback of sequences
- Clustered table
- Sparse columns
- Partitioned tables
Oracle rollback has been developed in version 11g Release 2, more precisely 11.2.0.4. It runs both on Standard and Enterprise versions.
When rolling back LOB data, the data must be accessible in UNDO, limiting the elapsed time the rollback can be performed after the end of the client SQL batches.
Configuration
- The database must be in ARCHIVELOG
- Minimal supplemental logging must be enabled.
- Archive Log Files must be accessible when DROPS executes the rollback.
- When rolling back LOB data, UNDO must contain data to be rolled back.
Rights
To perform the rollback, DROPS connects to the Oracle database with a user login which must have the following rights:
- GRANT CREATE SESSION
- GRANT CREATE TYPE
- GRANT FLASHBACK ANY TABLE
- GRANT SELECT_CATALOG_ROLE
- GRANT EXECUTE_CATALOG_ROLE
- GRANT EXECUTE ON DBMS_LOGMNR
- GRANT EXECUTE ON DBMS_AUDIT_MGMT
- GRANT EXECUTE ON DBMS_UTILITY
- GRANT EXECUTE ON DBMS_LOCK
- GRANT EXECUTE ON DBMS_SESSION
- GRANT SELECT ANY TRANSACTION
- EXECUTE ON DBMS_FLASHBACK
- SELECT ON V_$LOGFILE
- SELECT ON V_$LOGMNR_CONTENTS
- SELECT ON DBA_AUDIT_TRAIL
- SELECT ON DBA_AUDIT_OBJECT
- SELECT ON DBA_OBJECTS
- SELECT ON DBA_LOBS
- SELECT ON DBA_CONSTRAINTS
- SELECT ON DBA_STMT_AUDIT_OPTS
- SELECT ON DBA_OBJ_AUDIT_OPTS
- SELECT ON V_$SESSION
- SELECT ON DBA_TAB_COLUMNS
- SELECT ON DBA_TABLES
- SELECT ON DBA_CONS_COLUMNS
- SELECT ON DBA_SEQUENCES
- SELECT ON DBA_DEPENDENCIES
- ALTER ANY TRIGGER
- SELECT ANY TABLE
Features not supported
- DDL operation is not supported, except TRUNCATE when the table is empty at the start of the capture.
- IOT tables
- BFILE datatype
- Simple and nested abstract datatypes (ADTs)
- Collections (nested tables and VARRAYs)
- Object refs