eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 2015 ACOUG中国之旅-济南站活动成功举行 | Blog首页 | 行成于思:从Oracle到MySQL的抉择及DBA »

Oracle DataGuard对跨平台数据迁移的支持
modb.pro

Aix2Spar.jpg

在Oracle数据库之中,实现跨平台迁移一直是一项较为复杂的任务。Oracle的DataGuard技术一直在进步,不仅仅作为容灾,在数据迁移中也承担了重要的使命。

自10g开始,Oracle的DG开始有限度的支持跨平台的DataGuard环境搭建,从而简化数据迁移的过程,现在从AIX迁移至Solaris Sparc平台已经发布了成功的实施过程。

以下介绍内容参考了MOS的两篇文档,文档分别为:

  • Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration (Doc ID 413484.1)

  • One Time Migration Steps from IBM AIX Power to Solaris SPARC using Data Guard (Doc ID 1982638.1)

在文档一中给出了跨平台支持的矩阵列表,下图来自文档截图,我们可以看到IBM AIX可以向Solaris SPARC平台搭建DG,进行数据传输和同步:

PlatformSupport.png

在文档1982638.1中给出了详细的步骤,共七个环节,实际上是以下四件事,最主要的是解决一个ORA-600的BUG错误:

  1. 在SPARC平台创建备库;

  2. 通过10463解决ORA-600[kcc_upgrade_1]控制文件的错误,挂载备库;

  3. 开始正常的Redo Apply;

  4. 执行切换并重建控制文件;

当然要注意,以上的步骤只支持在Oracle 11g中进行,10g不在支持的产品序列中了。

我将文档1982638.1中的详细内容引用在这里供大家参考:

Step 1. Create a SPARC standby from the AIX primary using the steps outlined for creation of a standby in Data Guard Concepts and Administration.

(a) Do not use RMAN DUPLICATE process. Instead, use manual backup/restore method to populate the standby.
(b) It is ok to use RMAN for the manual backup/restore; however, in this case, make sure event 10463 is NOT set.
The following note can be use for guidance:

Note 469493.1 Step By Step Guide To Create Physical Standby Database Using RMAN Backup and Restore


Step 2. Mount the SPARC standby using the standby control file created on AIX primary in Step 1. Before mounting the standby database, set event 10463 level 3 in the init.ora at the SPARC standby. This setting prevents the assert ORA-600[kcc_upgrade_1] and allows the standby to be MOUNTED successfully.

For spfile:
alter system set event='10463 trace name context forever, level 3' scope=spfile sid='*'

For init.ora:
event='10463 trace name context forever, level 3'

Step 3. Remove event 10463 setting after successfully mounting the standby, shut it down, remove event 10463 setting from the standby's init.ora file, and re-mount the standby database.


Step 4. Resume normal Data Guard redo shipping & apply from AIX -> SPARC Enable DG redo shipping from AIX primary to SPARC standby, and start real time redo apply at SPARC standby as described in Data Guard Concepts and Administration.

You cannot use any flashback or RMAN related operations on the SPARC standby.

Step 5. Perform switchover and open the new SPARC production Use Data Guard Switchover Role transition procedure to convert SPARC standby into a Production database using the steps described in Section Switchovers in Data Guard Concepts and Administration

Do not allow users or applications to connect to the new primary yet.

Step 6. Recreate a new controlfile for the new production database and open production with new controlfile:

To recreate a new primary control file, use the following procedure:
a) On the open production, connect as SYSDBA, and issue "alter database backup controlfile to trace;"
b) In the trace file for this session you will see two sets of DDLs to create a new backup control file. Use the set of DDLs that create the control file with the NORESETLOGS option (Set # 1)
c) Shutdown the production database

SQL> shutdown;

d) Run the commands in the trace file starting with 'startup NOMOUNT', 'CREATE CONTROLFILE REUSE .. NORESETLOGS ..', 'RECOVER DATABASE', etc..

Step 7. Production on SPARC is now ready At the end of execution of all the commands in Set #1, the production database can be opened for users & applications.

Note: It is possible that when opening the new Primary you may encounter ORA-07445 errors or other errors indicating that some PL/SQL packages are invalid. If this occurs refer to Support Note: 414043.1 to recompile them.

IMPORTANT: Once this process is complete, the OLD PRIMARY is no longer usable and part of the Data Guard setup. If failback is required to the OLD PRIMARY, it can be mounted and activated. All data from the CURRENT PRIMARY since switchover will need to be exported and then imported to the OLD PRIMARY.

现在Aix to Sparc平台,可以试试这个方案了。

以下附录是截止 2015-08-27 跨平台支持DataGuard的列表矩阵和注意事项:

PLATFORM_ID PLATFORM_NAME
Release name
PLATFORM_IDs supported within the same Data Guard configuration when using
Data Guard Redo Apply (Physical Standby)
2 Solaris[tm] OE (64-bit)
Solaris Operating System (SPARC) (64-bit)
2
6 - See Support Note: 1982638.1 and Note: 414043.1
3 HP-UX (64-bit)
HP-UX PA-RISC
3
4 - Oracle 10g onward, see Support Note: 395982.1 and Note:414043.1
4 HP-UX IA (64-bit)
HP-UX Itanium
4
3 - Oracle 10g onward, see Support Notes Note: 395982.1 and Note:414043.1
5 HP Tru64 UNIX
HP Tru64 UNIX
5
6 IBM AIX on POWER Systems (64-bit) 2 - See Support Note: 1982638.1 and Note: 414043.1
6
7 Microsoft Windows (32-bit)
Microsoft Windows (x86)
7
8, 12  - Oracle 10g onward, see Support Note: 414043.1
10 - Oracle 11g onward, requires Patch 13104881
11, 13 - Oracle 11g onward, see Support Note: 414043.1, also requires Patch 13104881
8 Microsoft Windows IA (64-bit)
Microsoft Windows (64-bit Itanium)
7 - Oracle 10g onward, see Support Note: 414043.1
8
12 - Oracle 10g onward
11, 13 - Oracle 11g onward, requires Patch 13104881
9 IBM zSeries Based Linux
z/Linux
9
18 (64-bit zSeries only)
10 Linux (32-bit)
Linux x86
7 - Oracle 11g onward, requires Patch 13104881
10
11, 13 - Oracle 10g onward, see Support Note: 414043.1
11 Linux IA (64-bit)
Linux Itanium
10 - Oracle 10g onward, see Support Note: 414043.1
11
13 - Oracle 10g onward
7 - Oracle 11g onward, see Support Note: 414043.1, also requires Patch 13104881
8, 12 - Oracle 11g onward, requires Patch 13104881
12 Microsoft Windows 64-bit for AMD
Microsoft Windows (x86-64)
7 - Oracle 10g onward, see Support Note Note: 414043.1
8 - Oracle 10g onward
12
11, 13 - Oracle 11g onward, requires Patch 13104881
13 Linux 64-bit for AMD
Linux x86-64
7 - Oracle 11g onward, see Support Note: 414043.1, also requires Patch 13104881
10 - Oracle 10g onward, see Support Note Note: 414043.1
11 - Oracle 10g onward
8, 12 - Oracle 11g onward, requires Patch 13104881
13
20 - Oracle 11g onward
15 HP Open VMS
HP OpenVMS Alpha
HP IA OpenVMS
OpenVMS Itanium
15
16 Apple Mac OS
Mac OS X Server
16
17 Solaris Operating System (x86)
Solaris Operating System (x86)
17
20 - Oracle 10g onward, see Support Note: 414043.1
18 IBM Power Based Linux
Linux on Power
9 (64-bit zSeries only)
18
20 Solaris Operating System (AMD64)
Solaris Operating System (x86-64)
13 - Oracle 11g onward
17 - Oracle 10g onward, see Support Note: 414043.1
20

参考链接:

https://blogs.oracle.com/UPGRADE/entry/migration_ibm_aix_sparc_solaris

题图引自 Mike Dietrich 的博客。


历史上的今天...
    >> 2018-08-27文章:
    >> 2013-08-27文章:
    >> 2010-08-27文章:
           西藏记行 - 圣湖纳木措
    >> 2008-08-27文章:
    >> 2007-08-27文章:
    >> 2005-08-27文章:
           升级MT到3.2正式版

By eygle on 2015-08-27 11:37 | Comments (0) | Backup&Recovery | 3177 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com