Wednesday , April 24 2024

Make A Flashback Database

In today’s article, we will learn how to create a Flashback Database with the help of commands.

1. We check the existing data of the table on which Logical Corruption will be performed.

2. We create a restore point before the transaction is performed.

3. We are learning SCN.

4. We perform deletion.

5. We close the database.

6. The database opens in MOUNT mode.

7. Flashback Database is created.

8. By opening the database read only, it is checked whether the deleted data has been retrieved or not.

9. The database is closed and opened with RESETLOGS.

10. Other instances are also opened.

11. Other Flashback commands.



Leave a Reply

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