Microsoft Word - Cross_Platform_Migration_Test

Pre-Test Cross-Platform Migration Using RMA Backup and Transportable

Tablespaces

Downtime encountered: 0 seconds

Migration source host: poweredge

OS: RedHat LINUX AS 5

DB source: SID=orcl, 11.1.0.6, data stored in ASM diskgroup +DATA (previously

migrated from filesystem).

Tablespaces to be migrated to Windows: ITEMS, MARKET

RMAN repository: same host as source database, SID=test.

DB destination host: hp,

OS: Windows XP

DB destination: SID=orclhp, 11.1.0.6 data stored on file system in C:\apps\oracle\oradata

Note: this migration was performed from small endian to another small endian platform,

plus in 11g instead of 10g. As Figure 1 above shows both LINUX and Windows are

small endian platforms and simple file copy would do just fine, but the steps would be

identical in case of ALPHA to Integrity migration, as RMAN performs implicit

conversion. The point of this pre-test is to make sure we can avoid ANY downtime for

this transportable tablespaces migration, which we did. The rest will be done by RMAN

without explicit conversion of datafiles between platforms (a new feature available from

10gR2 and up).

2. This window shows that source database host poweredge is an 8CPU RedHat LINUX

server.

3. This window shows what platforms can be migrated to using transportable tablespaces.

4. This shows source database tablespaces. We will only transport ITEMS and

EXAMPLE. First we have to check that these tablespaces do not already exist in

destination platform. We do not transport UNDO, TEMP or SYSTEM tablespaces. We

also have to make sure all TTS pre-checks are done (self-containment, data types, etc.)

and source database users recreated in destination database.

Please note that this user ITEMS, for example, owns four tables SUPPLIERS,

CUSTOMERS, ITEM_MASTER and ITEM_SALE. We will later query the destination

database to make sure these tables have been transported successfully.

5. Backup source database and archivelogs by connecting to recovery catalog

6. Create transportdest and auxdest on source database

7. Run rman transport tablespaces script:

++++++++++++++++++++++++

[oracle@poweredge bin]$ rman

Recovery Manager: Release 11.1.0.6.0 - Production on Thu Feb 19

22:05:02 2009

RMAN> connect target sys/******@orcl

connected to target database: ORCL (DBID=1204707652)

RMAN> connect catalog rman/******@test

connected to recovery catalog database

RMAN> run {

2> transport tablespace items, market

3> tablespace destination '/u01/app/oracle/tts/transportdest'

4> auxiliary destination '/u01/app/oracle/tts/auxdest';

5> }

Creating automatic instance, with SID='accg'

initialization parameters used for automatic instance:

db_name=ORCL

compatible=11.1.0.0.0

db_block_size=8192

db_files=200

db_unique_name=tspitr_ORCL_accg

large_pool_size=1M

shared_pool_size=110M

processes=50

#No auxiliary parameter file used

db_create_file_dest=/u01/app/oracle/tts/auxdest

control_files=/u01/app/oracle/tts/auxdest/cntrl_tspitr_ORCL_accg.f

starting up automatic instance ORCL

Oracle instance started

Total System Global Area 205070336 bytes

Fixed Size 1298836 bytes

Variable Size 146804332 bytes

Database Buffers 50331648 bytes

Redo Buffers 6635520 bytes

Automatic instance created

contents of Memory Script:

{

# set the until clause

set until scn 3419451;

# restore the controlfile

restore clone controlfile;

# mount the controlfile

sql clone 'alter database mount clone database';

# archive current online log for tspitr to a resent until time

sql 'alter system archive log current';

# avoid unnecessary autobackups for structural changes during TSPITR

sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';

# resync catalog after controlfile restore

resync catalog;

}

executing Memory Script

executing command: SET until clause

Starting restore at 19-FEB-09

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=44 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: restoring control file

channel ORA_AUX_DISK_1: reading from backup piece

/u01/app/oracle/oradata/reco/ORCL/backupset/2009_02_19/o1_mf_ncsnf_TAG2

0090219T212726_4sw5db9b_.bkp

channel ORA_AUX_DISK_1: piece

handle=/u01/app/oracle/oradata/reco/ORCL/backupset/2009_02_19/o1_mf_ncs

nf_TAG20090219T212726_4sw5db9b_.bkp tag=TAG20090219T212726

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/u01/app/oracle/tts/auxdest/cntrl_tspitr_ORCL_accg.f

Finished restore at 19-FEB-09

sql statement: alter database mount clone database

sql statement: alter system archive log current

sql statement: begin dbms_backup_restore.AutoBackupFlag(FALSE); end;

starting full resync of recovery catalog

full resync complete

contents of Memory Script:

{

# generated tablespace point-in-time recovery script

# set the until clause

set until scn 3419451;

# set an omf destination filename for restore

set newname for clone datafile 1 to new;

# set an omf destination filename for restore

set newname for clone datafile 3 to new;

# set an omf destination filename for restore

set newname for clone datafile 2 to new;

# set an omf destination tempfile

set newname for clone tempfile 2 to new;

# set a destination filename for restore

set newname for datafile 7 to

"/u01/app/oracle/tts/transportdest/items.272.677546641";

# set a destination filename for restore

set newname for datafile 10 to

"/u01/app/oracle/tts/transportdest/market.dbf";

# rename all tempfiles

switch clone tempfile all;

# restore the tablespaces in the recovery set plus the auxiliary

tablespaces

restore clone datafile 1, 3, 2, 7, 10;

switch clone datafile all;