Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Guaranteed restore point in Oracle 11g

User_8E9DZNov 12 2015 — edited Nov 18 2015

Before performing any update activity of the database perform the below steps for creating restrore points by which we can restore the database to the before_update state.

SQL> shutdown immediate;

SQL> startup mount;

SQL> select log_mode,flashback_on from v$database;

If the database in NO ARCHIVE LOG MODE , enable the archive log mode mode

SQL> ALTER DATABASE ARCHIVELOG;

SQL> create restore point BEFORE_SCHEMA_CHANGES guarantee flashback database;

SQL> alter database open;

SQL> /*If an error occurs during update process*/

SQL> shutdown immediate;

SQL> startup mount;

SQL> flashback database to restore point BEFORE_SCHEMA_CHANGES;

SQL> alter database open resetlogs;

QL> select flashback_on from v$database;

FLASHBACK_ON

------------------

RESTORE POINT ONLY

Comments

Post Details

Added on Nov 12 2015
#general-database-discussions-ideas, #not-considering
3 comments
1,510 views