Flashback point in Oracle and commands to create Drop the Flashback Point in Oracle

This post explains you in details what is a Flashback or Restore point in Oracle and Commands to create the Flashback points and command to drop the flashback point.

What is a Flashback Point?

Flashback and restore points in Oracle database are data protection related features that permit you to wind back data in time to correct any teething troubles affected by logical data corruption or user errors within a designated time window. These features deliver a more capable alternative to point-in-time recovery and does not require a backup of the database to be restored first. 

The effects are similar to database point-in-time recovery (DBPITR). Flashback Database and restore points are not only effective in traditional database recovery situations but can also be useful during database upgrades, application changes deployments and application testing scenarios when test databases must be quickly created and re-created. Flashback Database also provides an efficient alternative to rebuilding a failed primary database after a Data Guard failover.

You can utilize flashback feature to view past conditions of information and rewind parts or the greater part of your database. When all is said in done, flashback feature are more effective and less troublesome than media recovery much of the time in which they apply.

Commands to Create Flashback restore point in Oracle.

1. Login to Oracle using orasid.
2. Go to Sqlplus
3. Enter the below command.

create restore point <Flashback point name> guarantee flashback database;

Flashback point name can be anything and is for reference eg: change number or change date.

Command to check if flashback point is created.

Select * from v$restore_point


Commands to Drop Flashback restore point in Oracle.

Drop restore point <Flashback point name>;

Command to check if flashback point is dropped successfully.

Select * from v$restore_point;