A Novel Approach of Using Data Guard for Disaster Recovery & Rolling Upgrades

Though we already had a standardized way (from Oracle) for Disaster Recovery policy, a major crash of the PLM database made our DBAs to come up with a proposal to execute a procedure using Data Guard together with Oracle Transportable Tablespace which resulted in the successful and timely migration of the PLM Production from Oracle 9.2.0.3 on HP N-Class to Oracle 9.2.0.5 on HP-Superdome in just 8 minutes.This same procedure also gives a fast, reliable way to upgrade from Oracle9i to Oracle Database10g with minimal downtime.And future database upgrades get even easier using Data Guard 10g Rolling Upgrades.