Perform Cross-Platform Database Transport to different Endian Platform with RMAN Backup Sets

In this tutorial you can see how to you 12c new feature to move the tablespace from one platform to the different platform using RMAN and DataPump Backup Sets 

CREATE TABLESPACE mytbs01 DATAFILE '/home/oracle/app/oradata/PRODDB/mytbs01.dbf' SIZE 30M;

CREATE TABLE mytable01

TABLESPACE mytbs01

AS

   SELECT * FROM dba_objects;

ALTER TABLESPACE mytbs01 READ ONLY;

BACKUP TO platform 'Linux x86 64-bit' format '/tmp/mytbs01_backup.bkp' datapump format '/tmp/mytbs01_datapump_export.bkp' TABLESPACE mytbs01;

ALTER TABLESPACE mytbs01 READ WRITE;

SELECT platform_name FROM v$database;

RESTORE FOREIGN TABLESPACE mytbs01 format '/u01/app/oracle/oradata/prod/mytbs01.dbf' FROM backupset '/tmp/mytbs01_backup.bkp' DUMP FILE FROM backupset '/tmp/mytbs01_datapump_export.bkp';

ALTER TABLESPACE mytbs01 READ WRITE;

SELECT COUNT (1) FROM mytable01;

SELECT name FROM v$tablespace;

Student Reviews

average rating
0
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%

leave comment

Sign in

Sign in

sign in or sign up

add to watchlist
  • 352 views
  • Duration : 00:04:50