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

Loading...
Thumbnail Image

Authors

Akhtar, Auf
Rizvi, Syed S.
Elleithy, Khaled M.

Issue Date

2008-03

Type

Article

Language

en_US

Keywords

Oracle Data Guard , Database , Disaster recovery

Research Projects

Organizational Units

Journal Issue

Alternative Title

Abstract

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.

Description

© ASEE 2008

Citation

Publisher

ASEE

License

Journal

Volume

Issue

PubMed ID

DOI

ISSN

EISSN