Testing a Physical Standby using Snapshot Standby in Oracle 10g

TESTING A PHYSICAL STANDBY DATABASE IN ORACLE 10G Using SNapshot Standby This procedure is very useful when you have physical standby databases for testing and other purposes that require read-write access to the standby database. Also, it improves your checklist in the event of an error or disaster. By using Snapshot standby databases, redo data … Continue reading Testing a Physical Standby using Snapshot Standby in Oracle 10g

ORA-38753: Cannot flashback data file ; no flashback log data. ORA-01110: data file

CAUTION !!!! DO NOT DO THIS ON YOUR PRIMARY. IF YOU DO THEN YOU WOULD REQUIRE MEDIA RECOVERY ON THE DATAFILE YOU BROUGHT OFFLINE !!!   If your getting this error when you converting a Snapshot Standby Database (11gR2) back to Physical Standby Database. SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY; ERROR at line 1: … Continue reading ORA-38753: Cannot flashback data file ; no flashback log data. ORA-01110: data file

Oracle 11g Snapshot Standby Database (Read- Write mode for standby db)

Oracle 11g Dataguard introduced powerful new features viz. Active Data Guard and Snapshot Standby Database. Snapshot standby database specially is an amazing feature. Where you can convert your standby database into read-write mode while the log shipping is happening. Once you finish your testing (feel free to drop tables, run rogue update statements or anything … Continue reading Oracle 11g Snapshot Standby Database (Read- Write mode for standby db)