11g+逻辑standby+滚动升级.pdf
免费下载
Maximum
Availability
Architecture
Oracle Best Practices for High Availability
Database Rolling Upgrade Using
Transient Logical Standby:
Oracle Data Guard 11g
Oracle Maximum Availability Architecture White Paper
May 2012
Maximum Availability Architecture
MAA - Database Rolling Upgrade Using Transient Logical Standby: Oracle Data Guard 11g Page 1
Database Rolling Upgrade Using Transient Logical Standby:
Oracle Data Guard 11g
Executive Summary ........................................................................................... 2
Overview: Rolling Database Upgrade with Transient Logical Standby ..... 3
General Restrictions .......................................................................................... 5
Rolling Upgrades Using a Transient Logical Standby .................................. 6
Confirm Data Type Support ........................................................................ 6
Conventions ................................................................................................... 8
Preparation Steps ........................................................................................... 8
Conversion to Logical Standby Steps .......................................................12
Create an Archived Redo Log Repository ...............................................13
Perform Patch Apply or Upgrade Steps ..................................................13
Create an Archived Redo Log Repository ...............................................15
Switchover ....................................................................................................15
Retransformation Into a Physical Standby Database .............................15
Switchback steps ..........................................................................................17
Cleanup steps ...............................................................................................18
Multiple Standby Database Considerations .................................................19
Fallback Best Practices ....................................................................................22
Backups .........................................................................................................24
Flashback Database .....................................................................................24
Downgrade ...................................................................................................25
Transient Logical Standby Fallback Considerations...............................25
Appendix A- Cloning the ORACLE_HOME to Apply a Patch set ........26
Appendix B- Using EDS with a Transient Logical Standby ......................27
Preparing EDS .............................................................................................27
Configuring EDS Logging Table Triggers ...............................................28
Removing EDS ............................................................................................28
References .........................................................................................................29
Change Record .................................................................................................30
Maximum Availability Architecture
MAA - Database Rolling Upgrade Using Transient Logical Standby: Oracle Data Guard 11g Page 2
Database Rolling Upgrade with Transient Logical Standby:
Oracle Data Guard 11g
EXECUTIVE SUMMARY
Oracle Maximum Availability Architecture (MAA) [1] is Oracle's best practices blueprint for
implementing Oracle high-availability technologies. This MAA white paper provides best
practices for utilizing a physical standby database to perform a rolling upgrade with minimal
downtime using the new Data Guard 11g feature, Transient Logical Standby.
Rolling upgrades eliminates downtime associated with the conventional database upgrade,
including PL/SQL recompilation. Additionally, once the standby database has been
upgraded, it can be used to evaluate performance and stability of the new release before
there is any impact to production. The only database downtime required by the entire
upgrade process is the time it takes to perform a Data Guard switchover (seconds).
A rolling upgrade using Transient Logical Standby:
1. Temporarily converts an existing physical standby to a logical standby database.
2. Executes a rolling upgrade.
3. Returns the standby back to its original status as a physical standby database once
the upgrade is complete.
This process allows physical standby users to obtain the same benefits of using logical
standby for rolling database upgrades, without requiring a second set of storage and
maintenance for an extra logical standby database. Transient Logical Standby is supported
for upgrades beginning with Oracle Database 11g.
Since the initial publication of this paper the rolling upgrade using Transient Logical Standby
has been simplified even further with the creation of a Bourne shell script developed by
Oracle to automate database rolling upgrades to new Oracle patch sets or full database
releases beginning with Oracle Database 11g Release 1 and higher. This simplified process is
documented in the “Database Rolling Upgrades Made Easy” MAA best practice paper.
Rolling database upgrades are also supported with Oracle Database 10g Release 2 when
using the standard rolling upgrade procedure described in the white paper, “Rolling Database
Upgrades Using Data Guard SQL Apply ”. The standard rolling upgrade process is different
from Transient Logical Standby in that the upgrade process concludes with the standby
remaining a logical standby database.
Applications have reduced downtime
for a database upgrade by 96% using
SQL Apply rolling upgrade compared
to the conventional upgrade.
of 32
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
相关文档
评论