Flashback Database is to rewind the database to a target time, its usually much faster than a RESTORE operation followed by point-in-time recovery because no data files are restored.<\/p>\n\n
For Enable Flasback in Database Flash back Retention<\/strong><\/p>\n\n How far back one can flashback a database depends on how much flashback data Oracle has kept in the fast recovery area<\/p>\n\n alter system set DB_FLASHBACK_RETENTION_TARGET = 1440;<\/p>\n\n Check SCN from Database Check Usage of Flash Recovery Area Check Available in Recovery Destination Area Check Transaction Query Inside Flash Logs or what exactly store in flashback<\/strong><\/p>\n\n SELECT operation, undo_sql, table_name,COMMIT_TIMESTAMP SELECT table_name, count(*) Disable Flashback Database Flashback database to Specific Time More Flashback Database Options Flashback Database to Specific Restore Point<\/strong><\/p>\n\n flashback database to restore point before_changes;<\/p>\n\n Enable Flashback Table<\/strong><\/p>\n\n CREATE TABLE flashback_table_test ( Flashback Tables<\/strong><\/p>\n\n FLASHBACK TABLE flashback_table_test TO SCN 715315; Flashback Query for Table Data<\/strong><\/p>\n\n SELECT COUNT(*) SELECT COUNT(*) Emergency Cleanup Flashback Logs<\/strong><\/p>\n\n SELECT operation, undo_sql, table_name,COMMIT_TIMESTAMP FROM flashback_transaction_query;<\/p>\n\n alter database flashback off;<\/p>\n\n alter database flashback on;<\/p>\n\n <\/p>\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":333,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-353","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/comments?post=353"}],"version-history":[{"count":5,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/353\/revisions"}],"predecessor-version":[{"id":358,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/353\/revisions\/358"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media\/333"}],"wp:attachment":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media?parent=353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/categories?post=353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/tags?post=353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/strong>Database should be in Archive Mode
show parameter db_recovery_file_dest;
alter system set db_recovery_file_dest = ‘\/data\/fastrecoveryarea’;
alter system set db_recovery_file_dest_size=300g;
select flashback_on from v$database;
alter database flashback on;
select flashback_on from v$database;<\/p>\n\n
<\/strong>SELECT current_scn, TO_CHAR(SYSTIMESTAMP, ‘YYYY-MM-DD HH24:MI:SS’) FROM v$database;<\/p>\n\n
<\/strong>select * from v$flash_recovery_area_usage;<\/p>\n\n
<\/strong>select name, floor(space_limit \/ 1024 \/ 1024\/1024) “Size GB”, ceil(space_used \/ 1024 \/ 1024\/1024) “Used GB” from v$recovery_file_dest order by name;<\/p>\n\n
FROM flashback_transaction_query;<\/p>\n\n
FROM flashback_transaction_query group by table_name;<\/p>\n\n
<\/strong>alter database flashback off;<\/p>\n\n
<\/strong>sqlplus \/ as sysdba
shutdown immediate
startup mount exclusive
flashback database to timestamp sysdate-(1\/24\/12);
alter database open resetlogs;<\/p>\n\n
<\/strong>flashback database to timestamp {my_date};
flashback database to before timestamp {my_date};
flashback database to scn {my_scn};
flashback database to before scn {my_scn};<\/p>\n\n
id NUMBER(10)
);
ALTER TABLE flashback_table_test ENABLE ROW MOVEMENT;<\/p>\n\n
FLASHBACK TABLE flashback_table_test TO TIMESTAMP TO_TIMESTAMP(‘2004-03-03 10:00:00’, ‘YYYY-MM-DD HH:MI:SS’);<\/p>\n\n
FROM flashback_query_test AS OF TIMESTAMP TO_TIMESTAMP(‘2004-03-29 13:34:12’, ‘YYYY-MM-DD HH24:MI:SS’);<\/p>\n\n
FROM flashback_query_test AS OF SCN 722452;<\/p>\n\n