Oracle 19c New Feature Automatic Flashback of Standby Database

Posted by Gavin Soorma
On July 2, 2019
0 Comments

One of the new features in Oracle 19c is that either when a flashback or point-in-time recovery is performed on the primary database in an Oracle Data Guard configuration, the same operation is also performed on the standby database as well. Following a flashback or PITR operation, the primary database is then opened with the […]

Posted by Gavin Soorma
On August 18, 2009
2 Comments

This scenario will show how we can use a combination of FLASHBACK database and also recovery to take a database back in time to undo a TRUNCATE operation and then roll forward the database after the flashback operation to bring it to the current point in time. INSERT ROWS INTO TABLE MYOBJ – THIS WILL […]

Posted by Arjun Raja
On August 11, 2009
0 Comments

FLASHBACK DATABASE – IMPACT OF RESETLOGS- A flashback database can be completed and the database can either be opened for READ ONLY or opened with a RESETLOGS option. As long as the RESETLOGS option is not used, a flashback can be rolled back . Example – Create table test – insert some records – select […]

Posted by Gavin Soorma
On July 22, 2009
1 Comments

After a data guard failover operation has been performed, instead of recreating the original primary database as the new standby database, we can use the FLASHBACK DATABASE to SCN command instead. This is particulary important in case the size of the primary database would mean a long backup and restore RMAN operation to recreate the […]

Posted by Gavin Soorma
On July 14, 2009
0 Comments

If we are using Guaranteed Restore Points with Flashback logging turned on, we need to exercise care that we drop restore points that are not in use or that we allocate sufficient space for the flashback logs as specified by the init.ora parameter db_recovery_file_dest_size. This is because the flashback logs will be retained and not […]

Posted by Gavin Soorma
On July 13, 2009
1 Comments

Oracle Flashback Technology provides a set of features available on 9i or higher version that support viewing and rewinding data back and forth in time to recover from Logical Corruptions while the database is online. Flashback Technology gives you 6 different ways to track and fix logical corruption through different approach. Oracle Flashback Query feature […]

Posted by Gavin Soorma
On July 9, 2009
0 Comments

PROMPT How Far Back Can We Flashback To (Time)? PROMPT select to_char(oldest_flashback_time,'dd-mon-yyyy hh24:mi:ss') "Oldest Flashback Time" from v$flashback_database_log; PROMPT PROMPT How Far Back Can We Flashback To (SCN)? PROMPT col oldest_flashback_scn format 99999999999999999999999999 select oldest_flashback_scn from v$flashback_database_log; PROMPT PROMPT Flashback Area Usage SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE; PROMPT col ROUND(SPACE_LIMIT/1048576) heading "Space Allocated (MB)" format 999999 […]

Posted by Gavin Soorma
On June 29, 2009
0 Comments

SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE; SELECT * FROM V$RECOVERY_FILE_DEST; col ROUND(SPACE_LIMIT/1048576) heading "Space Allocated (MB)" format 999999 col round(space_used/1048576) heading "Space Used (MB)" format 99999 col name format a40 select name, round(space_limit/1048576),round(space_used/1048576) from v$RECOVERY_FILE_DEST;

News

Oracle 19c New Feature Automatic Flashback of Standby Database

Using FLASHBACK to rollback a TRUNCATE

Flashback database – with and without resetlogs.

Flashback Database after a Data Guard Failover

Guaranteed Restore Points can cause a database hang

Flashback Table, Flashback Database,Flashback Query – examples

Script – Monitor Flashback Logs

Monitor the Flashback area space usage