使用可传输表空间进行平台迁移：Oracle 数据库.pdf

jieguo

34页

0次

2024-11-13

10墨值下载

Platform Migration Using

Transportable Tablespaces:

Oracle Database 11g Release 1

Oracle Maximum Availability Architecture White Paper

February 2009

Maximum

vailability

rchitecture

Oracle Best Practices For High Availability

Maximum Availability Architecture

Platform Migration Using Transportable Tablespaces

Oracle Database 11g Release 1

Introduction ....................................................................................................... 2

Platform Migration with Cross-Platform Transportable Tablespaces....... 3

When to Use the XTTS Method ................................................................ 3

Guidelines for Using the XTTS Method................................................... 4

Relationship of XTTS to Data Pump and Recovery Manager............... 5

Overview of the XTTS Migration Process ............................................... 5

Best Practices for the XTTS Method ........................................................ 6

Performing a Platform Migration with Transportable Tablespaces ........ 10

Phase 1: Initial Setup .................................................................................. 10

Phase 2: Prepare the Source and Target Databases............................... 13

Phase 3: Perform the Transport ............................................................... 18

Phase 4: Verify and Backup the New Target Database......................... 23

Conclusion........................................................................................................ 24

Appendix .......................................................................................................... 25

References ........................................................................................................ 32

Platform Migration Using Transportable Tablespaces: Oracle Database 11g Release 1 Page 1

Maximum Availability Architecture

Platform Migration Using Transportable Tablespaces

Oracle Database 11g Release 1

INTRODUCTION

Efficient and reliable methods of performing database maintenance—such as by

migrating a database to a new platform—have existed for many Oracle software

versions. However, as maintenance windows continue to shrink and database sizes

continue to grow, the importance placed on the time required to migrate a database

to a more reliable or cost-effective platform has grown considerably.

Platform migration is the process of moving a database from one operating

system platform to a different operating system platform. The supported way to

accomplish this in prior releases of the Oracle database was to export the data from

the database on the old platform, create a new database on the new platform, and

import the data into the new database. This process can take a number of days for

a very large database. Oracle Database provides two additional methods of

migrating a database to a new platform. Oracle Database 10g Release 2 introduced

Transportable Database (TDB), which reduces the amount of time and effort

required to migrate a database between platforms that share the same endian

format (byte ordering). Oracle Database 10g Release 1 introduced cross-platform

transportable tablespaces (XTTS), which allows datafiles to be moved between

platforms of different endian format.

XTTS is an enhancement to the transportable tablespaces (TTS) feature introduced

in Oracle8i. TTS was originally released as a method to move a subset of one

database into another, such as plugging parts of an OLTP database into a data

warehouse on the same platform. With the cross-platform enhancement, XTTS

can plug datafiles into a database on a different platform, including those that are

using a different endian format. XTTS may reduce platform migration time by

moving all user tablespaces from a source database to an empty target database

running on a platform that uses a different endian format. With the XTTS feature,

tablespace datafiles are plugged into the empty target database by copying the

datafiles to the target database, converting them to the target system endian format,

and then importing the object metadata into the target database.

This white paper explains how to use the cross-platform transportable tablespaces

feature in Oracle Database 11g Release 1 to migrate a database to a new platform

that is using an endian format that is different from the source database platform.

Platform Migration Using Transportable Tablespaces: Oracle Database 11g Release 1 Page 2

of 34

10墨值下载

xtts

相关文档

评论