Guaranteed restore point in Oracle 11g — oracle-tech

    Forum Stats

  • 3,702,038 Users
  • 2,239,552 Discussions
  • 7,835,729 Comments

Discussions

Guaranteed restore point in Oracle 11g

User_8E9DZUser_8E9DZ Posts: 238 Blue Ribbon

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

User_8E9DZvansul
-1
5 votes

Not considering · Last Updated

Comments

  • top.guntop.gun Posts: 3,666 Gold Crown

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

    William Robertson
  • William RobertsonWilliam Robertson Posts: 9,560 Bronze Crown

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

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

    Moving to the General DB forum.

    LKR

Sign In or Register to comment.