How Oracle Purge RecycleBin
In this post, we'll talk about the following topics. Feature of Recyclebin Prerequisite of Using Recyclebin Ways to Purge Recyclebin Feature of Recyclebin Since 10g,… Read More »How Oracle Purge RecycleBin
Flashback
How Oracle Restore Table from Recycle Bin
Restoring Dropped Table There're several ways that can recover your table: Export/Import: You can use impdp (or imp) utility to import your dropped table from… Read More »How Oracle Restore Table from Recycle Bin
How to Recover Truncated Tables in Oracle
Truncate Table can destroy all data of a table with little footprints (No undo, little redo), only metadata left there. If you are responsible for… Read More »How to Recover Truncated Tables in Oracle
Converting Standby Database to Snapshot (4/4) - With Flashback Tablespace Disabled
Converting Standby Database to Snapshot (3/4) - With Flashback Database DisabledSome standby conversions could be more complicated than usual, especially converting back to physical standby.… Read More »Converting Standby Database to Snapshot (4/4) - With Flashback Tablespace Disabled
Converting Standby Database to Snapshot (3/4) - With Flashback Database Disabled
Converting Standby Database to Snapshot (2/4) - Convert ManuallyIt would be better to make sure flashback database is enabled before conversion, but it seems not… Read More »Converting Standby Database to Snapshot (3/4) - With Flashback Database Disabled
Converting Standby Database to Snapshot (1/4) - Convert by Broker
Converting Standby Database to Snapshot (0/4) - An Overview Before you convert a physical standby database, you must make sure FRA is configured properly. [oracle@standby01… Read More »Converting Standby Database to Snapshot (1/4) - Convert by Broker
Converting Standby Database to Snapshot (0/4) - An Overview
The feature of standby conversion can change a standby database into a fully updatable test one. For a more smooth operation, we usually make flashback enabled… Read More »Converting Standby Database to Snapshot (0/4) - An Overview
How to Failover to a Standby Database Manually and Rebuild Data Guard - By Example
Since a fast-start failover (automatic failover) could become a false failover when the observer or the standby database cannot connect to the primary database within… Read More »How to Failover to a Standby Database Manually and Rebuild Data Guard - By Example
How Oracle Enable Flashback Database
Enabling Flashback Database Flashback Database can rewind an entire database back to a state of point-in-time, just before operation failures which involved whole database. The… Read More »How Oracle Enable Flashback Database
How to Check Current System Change Number (SCN)
System Change Number Some DBAs will schedule a cron job to capture System Change Number (SCN) periodically to save as a Timestamp/SCN mapping reference. To… Read More »How to Check Current System Change Number (SCN)