• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » Oracle Flashback Database explained and limitation

Oracle Flashback Database explained and limitation

April 27, 2014 by techgoeasy Leave a Comment

What is Flashback Database
a)New feature from 10.1 onwards, Uses past block images to back out changes to a oracle database
b)During normal database operation, Oracle occasionally logs past block images in flashback logs
c)Flashback logs are  written sequentially not archived
d) Oracle automatically creates, resizes and deletes flashback logs in the flash recovery area
e) DBA should be aware of flashback logs to monitor performance,to decide how much space to allocate to flash recovery area
f)Allows database to be recovered to a previous time to correct problems caused by logical data corruptions,user errors

How flashback database works
a)Before images are used to restore database to a point in the past
b)Forward recovery is then used to bring the database to a consistent state
c) So it both used the flashback logs and archive log . Both should be available to flash back the database.
d) past block images are created using the new process RVWR background process

How to configure flashback database
a)Archiving must be enabled
b)Flash recovery area must be configured using
DB_RECOVERY_FILE_DEST_SIZE – size of flashback recovery area in bytes
DB_RECOVERY_FILE_DEST – location of flashback recovery area
c)Open the database in MOUNT EXCLUSIVE mode and turn on the flashback feature:
SQL> STARTUP MOUNT EXCLUSIVE;
SQL> ALTER DATABASE FLASHBACK ON;
d) Set the Flashback Database retention target:
DB_FLASHBACK_RETENTION_TARGET
To enable Flashback Database, Issue the following command:
SQL> select flashback_on from  v$database;
e)To disable disable Flashback Database, issue the following command
SQL> ALTER DATABASE FLASHBACK OFF;
f)Monitor logging in the Flashback Database logs:

SQL> select begin_time, flashback_data,
db_data, redo_data, ESTIMATED_FLASHBACK_SIZE
from   v$flashback_database_stat;

g)Monitor the Flashback Database retention target:
SQL> select * from   v$flashback_database_log;

More information about Flashback Database
a)Flashback uses a flashback generation buffer
Size of generation buffer is recorded in V$SGASTAT
Size is determined by _flashback_generation_buffer_size
defaults to 4194304
b) Flashback uses the recovery writer (RVWR) background process to copies flashback blocks from flashback generation buffer to flashback logs
c)All blocks are logged when they first become dirty Includes data, indexes, undo, segment headers, bitmaps
d)  Subsequent changes not necessarily logged
e) Amount of flashback redo log generated roughly equivalent to value of physical writes statistics
f) Very similar design to LGWR  ie. Changes initially written to memory buffer and RVWR subsequently flushes flashback records to disk

Related Articles

Queries for Flashback Database
Recover drop/truncate/delete table on primary using flashback on standby database
how to Flashback when we have dataguard
Flashback PDB in Oracle Database 12c Release 2
Oracle Flashback query

Filed Under: Oracle, Oracle Database Tagged With: Flashback Database

Reader Interactions

Leave a Reply Cancel reply

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

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • ORA-28007: the password cannot be reused
  • What is crontab in Linux
  • How to change apps password in EBS R12.2
  • How to find weblogic version in Unix & Windows
  • How to use RMAN Catalog Command

Copyright © 2022 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us