How To Create a Restore Point On Oracle

 

With the flashback database we can use the restore point to return the database to a time in the past.

For more detailed information about the Flasback Database you can read the article “What is FLASBACK DATABASE And How To FLASHBACK

With the command below, create a restore point while the database is in mount mode.

 

You can list existing restore points with the help of the following script.

 

You can also delete an existing restore point using the following script.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *