oracle10g ASM transport_tablespace

xsb發表於2008-03-06

Solution1:
source:windows2003 32bit,oracle10g 10.2.0.2
target:IBM aix 64bit,oracle10g 10.2.0.3,RAC,ASM

Solution2:
source:HP UX 64bit,oracle10g 10.2.0.3,RAC,ASM
target:IBM aix 64bit,oracle10g 10.2.0.3,RAC,ASM

[@more@]

Solution1:
source:windows2003 32bit,oracle10g 10.2.0.2
GRANT DBA TO xsb IDENTIFIED BY xsb;

CREATE TABLESPACE xsbtest_ts DATAFILE 'D:ORACLEPRODUCT10.2.0ORADATACSLSCxsbtest_ts01.DBF' SIZE 5m;
SELECT * FROM v$datafile;
CREATE TABLE xsb.t1 TABLESPACE xsbtest_ts AS SELECT * FROM dba_users;
SELECT * FROM xsb.t1;
ALTER TABLESPACE xsbtest_ts READ ONLY;
SELECT *FROM v$transportable_platform ORDER BY platform_id;
--conn sys
AS SYSDBA
--BEGIN dbms_tts.transport_set_check('xsbtest_ts', TRUE,TRUE);END;
--SELECT * FROM TRANSPORT_SET_VIOLATIONS;

exp 'sys AS SYSDBA' FILE=1.dmp tablespaces=xsbtest_ts transport_tablespace=y

ftp target
bin
put D:ORACLEPRODUCT10.2.0ORADATACSLSCxsbtest_ts01.DBF
bye

ALTER TABLESPACE xsbtest_ts READ WRITE;

target:IBM aix 64bit,oracle10g 10.2.0.3,RAC,ASM
GRANT DBA TO xsb IDENTIFIED BY xsb ;
--DROP TABLESPACE xsbtest_ts INCLUDING CONTENTS and datafiles ;

rman target /
CONVERT DATAFILE '/home/oracle/XSBTEST_TS01.DBF' FROM PLATFORM 'Microsoft Windows IA (32-bit)'
format '+DATA/aeg2t/datafile/xsbtest_ts.dbf' ;
EXIT

imp 'sys as sysdba ' file=1.dmp tablespaces=xsbtest_ts transport_tablespace=y datafiles='+DATA/aeg2t/datafile/xsbtest_ts.dbf'

SELECT * FROM xsb.t1;

Solution2:
source:HP UX 64bit,oracle10g 10.2.0.3,RAC,ASM
GRANT DBA TO xsb IDENTIFIED BY xsb;
CREATE TABLESPACE xsbtest_ts2 DATAFILE SIZE 5m;
SELECT * FROM dba_data_files;
CREATE TABLE xsb.t1 TABLESPACE xsbtest_ts2 AS SELECT * FROM dba_users;
SELECT * FROM xsb.t1;
ALTER TABLESPACE xsbtest_ts2 READ ONLY;
SELECT * FROM dba_tablespaces;
SELECT *FROM v$transportable_platform ORDER BY platform_id;
--conn sys
AS SYSDBA
--BEGIN dbms_tts.transport_set_check('xsbtest_ts2', TRUE,TRUE);END;
--SELECT * FROM TRANSPORT_SET_VIOLATIONS;
show parameter comp

exp 'SYS AS SYSDBA ' FILE=1.dmp tablespaces=xsbtest_ts2 transport_tablespace=y

rman target /
copy DATAFILE ## TO '/home/oracle/xsbtest_ts2.dbf' ;
or
CONVERT TABLESPACE xsbtest_ts2 TO platform 'AIX-Based Systems (64-bit)' format '/home/oracle/xsbtest_ts2.dbf';
EXIT

ALTER TABLESPACE xsbtest_ts2 READ WRITE;

--DROP TABLESPACE xsbtest_ts2 INCLUDING CONTENTS and datafiles ;
--drop user xsb cascade;

ls -lt|more

ftp target
bin
put /home/oracle/xsbtest_ts2.dbf
put /home/oracle/1.dmp
bye

target:IBM aix 64bit,oracle10g 10.2.0.3,RAC,ASM
GRANT DBA TO xsb IDENTIFIED BY xsb ;
--DROP TABLESPACE xsbtest_ts2 INCLUDING CONTENTS and datafiles ;

rman target /
CONVERT DATAFILE '/home/oracle/xsbtest_ts2.dbf' format '+DATA/aeg2t/datafile/xsbtest_ts2.dbf' ;
EXIT

show parameter comp

imp 'sys as sysdba ' file=1.dmp tablespaces=xsbtest_ts2 transport_tablespace=y datafiles='+DATA/aeg2t/datafile/xsbtest_ts2.dbf'

SELECT * FROM xsb.t1;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12402/viewspace-1000494/,如需轉載,請註明出處,否則將追究法律責任。

相關文章