dategurd oracle_Oracle DataGuard对跨平台数据迁移的支持

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

在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，进行数据传输和同步：

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

在SPARC平台创建备库；

通过10463解决ORA-600[kcc_upgrade_1]控制文件的错误，挂载备库；

开始正常的Redo Apply；

执行切换并重建控制文件；

当然要注意，以上的步骤只支持在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)

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)

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

参考链接：

题图引自 Mike Dietrich 的博客。

By eygle on 2015-08-27 11:37 |

Comments (0) |

Backup&Recovery | 3177 |