oracle10g ASM transport_tablespace
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
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle10g asm---第三回---asmOracleASM
- oracle10g ASM+RAC安裝OracleASM
- 在Oracle10g 新增ASM磁碟組OracleASM
- Oracle10g使用ASM注意事項OracleASM
- Oracle10g RAC ASM磁碟組[zt]OracleASM
- Oracle10g RAC ASM 環境日常管理OracleASM
- 建立 Oracle10g ASM 資料庫(1)OracleASM資料庫
- oracle10g中的asm的配置(轉)OracleASM
- oracle10G新特性之ASM的應用OracleASM
- 在Oracle10g RAC下新增ASM磁碟組OracleASM
- 搭建 VM + RHLE5 + Oracle10g Rac + ASMOracleASM
- [zt] Oracle10g ASM Auto IO Rebalance新特性及ASM體系結構OracleASM
- How to create user for oracle10g/11g asm instanceOracleASM
- 用vmware體驗Oracle10g的ASM資料庫OracleASM資料庫
- redhat5 x86_64 + oracle10g RAC + ASMRedhatOracleASM
- Migrating Oracle10g Database to Automatic Storage management (ASM)OracleDatabaseASM
- oracle10g 使用pl/sql developer連線asm例項OracleSQLDeveloperASM
- Oracle10g New Feature -- 9. ASM (Automatic Storage Management)OracleASM
- 在centos5.4安裝oracle10g asm相關問題CentOSOracleASM
- Oracle10g RAC (ASM) 資料庫及服務開啟關閉OracleASM資料庫
- OracleDataBase單例項使用ASM案例(4)–AIX系統Oracle10g應用OracleDatabase單例ASMAI
- Step By Step Instructions on Migrating Oracle10g Database to Automatic Storage management (ASM)StructOracleDatabaseASM
- asm files,asm directories,asm templatesASM
- Oracle10g RAC或者ASM的一個注意點,再重點強調一下OracleASM
- 在solaris10單例項配置oracle10g asm執行css不啟動處理單例OracleASMCSS
- 【ASM】如何建立ASM磁碟ASM
- ASM之建立ASM磁碟ASM
- 【ASM學習】ASM 管理ASM
- 【ASM學習】ASM文件ASM
- solaris10上oracle10g之asm_asmcmd和rman歸檔日誌資料不同學習OracleASM
- ASM之建立ASM例項及ASM資料庫ASM資料庫
- expdp匯出、transport_tablespace遇見ORA-04063、ORA-06508: PL/SQL:SQL
- 【ASM】ASM基礎知識ASM
- ASM之建立ASM例項ASM
- ASM之ASM相關概念ASM
- ASMASM
- 利用TRANSPORT_TABLESPACE特性把9i的表空間遷移到10g測試!
- 利用TRANSPORT_TABLESPACE特性在同一db下不同使用者之間遷移資料!