Posts

Showing posts from May 8, 2014

Oracle 10g/11g:Open(READ-WRITE) physical standby database in flashback mode

Image
Oracle 10g/11g:Open(READ-WRITE) physical standby database in flashback mode    In this post, We will do DR Drill activity by open physical standby database in flashback mode. Sometimes it is require when we need to check our dr is sufficient to handle the load same as production and also before switchover we can check if any problems in physical standby. It is very simple and handy by enabling flashback mode on physical standby database.Once task of testing (DR DRILL) finishes we flash back database to guarantee restore point. After testing we can start real time sync from production to DR Server. Follow the easy steps on primary and standby database. Please note that there is no rollback if any error on DR.  1.On Standby Database A) Set up a flash recovery area. (Skip this step if FRA already configured)  If Flash Recovery Area (FRA ) is not configured in the standby then enable it and make sure to give enough space for to FRA SQL> ALTER