Guaranteed restore point in Oracle 11g

User_8E9DZ

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

top.gun

This is a poll, so what are we voting on?

William Robertson

I don't see any new feature proposal. I think this suggestion is in the wrong forum.

Unknown

I don't see any new feature proposal. I think this suggestion is in the wrong forum.

Moving to the General DB forum.

LKR