We are going to have look at another part of the Oracle database. Flashback is going to be the topic of our discussion of today. Let’s start with its introduction after that with its example.

Being DBA we have to make us familiar with Flashback technology. It is considered as a good feature of Oracle Database.

What is flashback technology? 

Let’s have a technical definition of flashback technology.

Oracle Flashback Technology is a group of Oracle Database features that that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery.

We can perform multiple tasks with the help of flashback technology some of them are mention below:-

  • It performs queries that return past data
  • We can perform queries that return metadata that shows a detailed history of changes to the database.
  • Recover tables or rows to a previous point in time is the most beautiful feature of flashback technology.
  • We can see that it automatically track and archive transactional data changes.
  • It rolls back a transaction and its dependent transactions while the database remains online.

Before use flashback technology we have to set some location and parameters so Oracle Database can give us better solutions.

RVWR Background Process

A new RVWR background process is started when Flashback Database is enabled. It is similar to the LGWR (log writer) process. The new process writes Flashback Database data to the Flashback Database logs.

Enabling Flashback Database:

Make sure the database is in archive mode and FLASHBACK_ON Yes

Configure the recovery area(if necessary) by setting the two parameters:

  • db_recovery_file_dest
  • db_recovery_file_dest_size

Open the database in MONT mode and turn on the flashback feture:

Test Case

Another Example:

Thanks for giving valuable time to add new gems to Oracle’s treasure.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.