I have published a new video Flashback PDB in RAC with DG.
Here are some important considerations / commands when you want to use Flashback :
1. Ensure that you have FLASHBACK_ON in the Database (at both Primary and Standby). If you don't have FLASHBACK_ON, ensure that you create the RESTORE POINT WITH GUARANTEE FLASHBACK DATABASE at both Primary and Standby. (In the latter case, the Flashback SCN / Point In Time of the Standby must be lower than that of the Primary).
3. Monitor the FRA (Recovery Area) (V$FLASH_RECOVERY_AREA_USAGE) and Oldest Flashback Time (in V$FLASHBACK_DATABASE_LOG). If necessary, increase DB_FLASHBACK_RETENTION_TARGET and DB_RECOVERY_FILE_DEST_SIZE to ensure that you don't run out of space for the Flashback Logs !
2. If you have used dgmgrl -- i.e. Data Guard Broker Configuration, all commands to Stop Redo Shipping / Resume Redo Shipping, Stop Redo Apply / Resume Redo Apply must be issued through dgmgrl. Do not use SQL commands.
3. At the Standby the Flashback command uses the "STANDBY" clause to identify that you are doing a Flashback for a Standby.
Some older Blog Posts on FLASHBACK DATABASE are at Blog Series on Flashback Database.
No comments:
Post a Comment