hp-ux利用rman將資料庫跨平臺遷移到aix平臺上
這次因為要遷移的資料庫大小並不大但也不是隻有幾十G所以選擇使用rman將生產資料庫從hp-ux遷移到aix上,資料庫是10.2.0.4
1.操作環境
1.1 源生產環境
資料庫名 CAIWU
例項名 CAIWU
DBID 338270341
資料庫 HP-UX 10.2.0.4.0 - 64bit Production
資料檔案目錄 /cwjc_data/CAIWU
文字初始化引數檔案:/oracle/product/10.2.0/dbs/init/initCAIWU.ora
1.2 目標生產環境
資料庫名 CAIWU
例項名 CAIWU
DBID 338270341
資料庫 HP-UX 10.2.0.4.0 - 64bit Production
資料檔案目錄 /yl_oradata/CAIWU
文字初始化引數檔案:/oracle/product/10.2.0/db_1/dbs/init/initCAIWU.ora
2 備份
2.1 備份注意事項
1. 遷移庫只能在同位元組順序平臺之間(即ENDIAN_FORMAT相同)且得是ORACLE所支援的平臺,可以在V$TRANSPORTABLE_PLATFORM中檢視。
2. 傳輸前需要將源庫置為只讀。
3. 生成的2個指令碼檔案要仔細根據需要修改。
2.2 源庫操作
2.2.1 將庫只讀,並檢查是否支援遷移
一.將庫只讀,並檢查是否支援遷移
[rx6600-2:oracle:/cwjc_data]$sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 29 22:34:24 2014 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> shutdown immediate Database closed. Database dismounted. SQL> startup mount ORACLE instance started. Total System Global Area 3439329280 bytes Fixed Size 2060008 bytes Variable Size 2348810520 bytes Database Buffers 1073741824 bytes Redo Buffers 14716928 bytes Database mounted. SQL> alter database open read only; Database altered.
2.2.2 檢查支援遷移平臺
SQL> select * from v$transportable_platform; PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT ----------- -------------------------------------- -------------- 1 Solaris[tm] OE (32-bit) Big 2 Solaris[tm] OE (64-bit) Big 7 Microsoft Windows IA (32-bit) Little 10 Linux IA (32-bit) Little 6 AIX-Based Systems (64-bit) Big 3 HP-UX (64-bit) Big 5 HP Tru64 UNIX Little 4 HP-UX IA (64-bit) Big 11 Linux IA (64-bit) Little 15 HP Open VMS Little 8 Microsoft Windows IA (64-bit) Little 9 IBM zSeries Based Linux Big 13 Linux x86 64-bit Little 16 Apple Mac OS Big 12 Microsoft Windows x86 64-bit Little 17 Solaris Operating System (x86) Little 18 IBM Power Based Linux Big 20 Solaris Operating System (x86-64) Little 19 HP IA Open VMS Little 19 rows selected.
2.2.3 利用dbms_tdb 包檢查資料庫
二.利用dbms_tdb 包檢查資料庫能否被傳輸以及列出外部表和DIRECTORY 等無法傳輸的物件資訊,
分別在hp-ux平臺資料庫透過SQLPLUS執行以下兩個儲存過程
SQL> set serveroutput on SQL> declare 2 db_ready boolean; 3 begin 4 /* db_ready is ignored, but with SERVEROUTPUT set to ON any 5 * conditions preventing transport will be output to console */ 6 db_ready := dbms_tdb.check_db('AIX-Based Systems (64-bit)', 7 dbms_tdb.skip_none); 8 end; 9 / PL/SQL procedure successfully completed. SQL> declare 2 external boolean; 3 begin 4 /* value of external is ignored, but with SERVEROUTPUT set to ON 5 * dbms_tdb.check_external displays report of external objects 6 * on console */ 7 external := dbms_tdb.check_external; 8 end; 9 / The following directories exist in the database: SYS.DUMP_CAIWU, SYS.DATA_PUMP_DIR, SYS.WORK_DIR, SYS.ADMIN_DIR, SYS.ORACLE_OCM_CONFIG_DIR PL/SQL procedure successfully completed.
2.2.4 RMAN ConvertDB
連線target database 檢視資料庫開啟模式
[rx6600-2:oracle:/home/oracle]$sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 29 22:46:30 2014 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select open_mode from v$database; OPEN_MODE ---------- READ ONLY
利用RMAN轉換資料庫
RMAN> convert database new database 'CAIWU' 2> transport script '/cwjc_data/CAIWURMAN/caiwu.sql' 3> to platform 'AIX-Based Systems (64-bit)' 4> db_file_name_convert '/cwjc_data/CAIWU/','/cwjc_data/CAIWURMAN/'; Starting convert at 29-SEP-14 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=539 devtype=DISK Directory SYS.DUMP_CAIWU found in the database Directory SYS.DATA_PUMP_DIR found in the database Directory SYS.WORK_DIR found in the database Directory SYS.ADMIN_DIR found in the database Directory SYS.ORACLE_OCM_CONFIG_DIR found in the database User SYS with SYSDBA and SYSOPER privilege found in password file channel ORA_DISK_1: starting datafile conversion input datafile fno=00005 name=/cwjc_data/CAIWU/zwdata01.dbf converted datafile=/cwjc_data/CAIWURMAN/zwdata01.dbf channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:06:25 channel ORA_DISK_1: starting datafile conversion input datafile fno=00006 name=/cwjc_data/CAIWU/zwdata02.dbf converted datafile=/cwjc_data/CAIWURMAN/zwdata02.dbf channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:06:25 channel ORA_DISK_1: starting datafile conversion input datafile fno=00001 name=/cwjc_data/CAIWU/system01.dbf converted datafile=/cwjc_data/CAIWURMAN/system01.dbf channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:03:25 channel ORA_DISK_1: starting datafile conversion input datafile fno=00002 name=/cwjc_data/CAIWU/undotbs01.dbf converted datafile=/cwjc_data/CAIWURMAN/undotbs01.dbf channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:01:45 channel ORA_DISK_1: starting datafile conversion input datafile fno=00003 name=/cwjc_data/CAIWU/sysaux01.dbf converted datafile=/cwjc_data/CAIWURMAN/sysaux01.dbf channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:01:45 channel ORA_DISK_1: starting datafile conversion input datafile fno=00004 name=/cwjc_data/CAIWU/users01.dbf converted datafile=/cwjc_data/CAIWURMAN/users01.dbf channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:55 Run SQL script /cwjc_data/CAIWURMAN/caiwu.sql on the target platform to create database Edit init.ora file /oracle/product/10.2.0/dbs/init_00pjoiqb_1_0.ora. This PFILE will be used to create the database on the target platform To recompile all PL/SQL modules, run utlirp.sql and utlrp.sql on the target platform To change the internal database identifier, use DBNEWID Utility Finished backup at 29-SEP-14
將轉換後的檔案傳輸到目標主機上
[rx6600-2:oracle:/cwjc_data/CAIWURMAN]$ls -lrt total 53002438 -rw-r----- 1 oracle dba 8589942784 Sep 29 22:57 zwdata01.dbf -rw-r----- 1 oracle dba 8589942784 Sep 29 23:03 zwdata02.dbf -rw-r----- 1 oracle dba 4588576768 Sep 29 23:07 system01.dbf -rw-r----- 1 oracle dba 2147491840 Sep 29 23:08 undotbs01.dbf -rw-r----- 1 oracle dba 2147491840 Sep 29 23:10 sysaux01.dbf -rw-r----- 1 oracle dba 1073750016 Sep 29 23:11 users01.dbf -rw-r--r-- 1 oracle dba 2704 Sep 29 23:11 caiwu.sql ftp> get zwdata01.dbf 200 PORT command successful. 150 Opening BINARY mode data connection for zwdata01.dbf (8589942784 bytes). 226 Transfer complete. 8589942784 bytes received in 197.5 seconds (4.248e+04 Kbytes/s) local: zwdata01.dbf remote: zwdata01.dbf ftp> get zwdata02.dbf 200 PORT command successful. 150 Opening BINARY mode data connection for zwdata02.dbf (8589942784 bytes). 226 Transfer complete. 8589942784 bytes received in 202.7 seconds (4.138e+04 Kbytes/s) local: zwdata02.dbf remote: zwdata02.dbf ftp> get system01.dbf 200 PORT command successful. 150 Opening BINARY mode data connection for system01.dbf (4588576768 bytes). 226 Transfer complete. 4588576768 bytes received in 111.3 seconds (4.027e+04 Kbytes/s) local: system01.dbf remote: system01.dbf ftp> get undotbs01.dbf 200 PORT command successful. 150 Opening BINARY mode data connection for undotbs01.dbf (2147491840 bytes). 226 Transfer complete. 2147491840 bytes received in 52.55 seconds (3.99e+04 Kbytes/s) local: undotbs01.dbf remote: undotbs01.dbf ftp> get sysaux01.dbf 200 PORT command successful. 150 Opening BINARY mode data connection for sysaux01.dbf (2147491840 bytes). 226 Transfer complete. 2147491840 bytes received in 51.29 seconds (4.089e+04 Kbytes/s) local: sysaux01.dbf remote: sysaux01.dbf ftp> get users01.dbf 200 PORT command successful. 150 Opening BINARY mode data connection for users01.dbf (1073750016 bytes). 226 Transfer complete. 1073750016 bytes received in 26.01 seconds (4.032e+04 Kbytes/s) local: users01.dbf remote: users01.dbf ftp> get caiwu.sql 200 PORT command successful. 150 Opening BINARY mode data connection for caiwu.sql (2704 bytes). 226 Transfer complete. 2704 bytes received in 9e-05 seconds (2.934e+04 Kbytes/s) local: caiwu.sql remote: caiwu.sql ftp> get init_00pjoiqb_1_0.ora 200 PORT command successful. 150 Opening BINARY mode data connection for init_00pjoiqb_1_0.ora (1556 bytes). 226 Transfer complete. 1556 bytes received in 8.7e-05 seconds (1.747e+04 Kbytes/s) local: init_00pjoiqb_1_0.ora remote: init_00pjoiqb_1_0.ora [IBMP740-2:oracle:/yl_oradata/CAIWU]$ls -lrt total 53002408 -rw-r--r-- 1 oracle dba 8589942784 Sep 29 23:02 zwdata01.dbf -rw-r--r-- 1 oracle dba 8589942784 Sep 29 23:06 zwdata02.dbf -rw-r--r-- 1 oracle dba 4588576768 Sep 29 23:08 system01.dbf -rw-r--r-- 1 oracle dba 2147491840 Sep 29 23:09 undotbs01.dbf -rw-r--r-- 1 oracle dba 2147491840 Sep 29 23:11 sysaux01.dbf -rw-r--r-- 1 oracle dba 1073750016 Sep 29 23:11 users01.dbf -rw-r--r-- 1 oracle dba 2704 Sep 29 23:12 caiwu.sql -rw-r--r-- 1 oracle dba 1556 Sep 29 23:12 init_00pjoiqb_1_0.ora
將init_00pjoiqb_1_0.ora引數檔案複製到$ORACLE_HOME/dbs目錄下
[IBMP740-2:oracle:/yl_oradata/CAIWU]$ cp init_00pjoiqb_1_0.ora $ORACLE_HOME/dbs
2.2.5 在目標生產機器上修改pfile引數檔案並將引數檔案init_00pjoiqb_1_0.ora重新命名為initCAIWU.ora
IBMP740-2:oracle:/oracle/product/10.2.0/db_1/dbs]$mv init_00pjoiqb_1_0.ora initCAIWU.ora
修改前引數檔案內容如下:
[IBMP740-2:oracle:/oracle/product/10.2.0/db_1/dbs]$vi initCAIWU.ora "initCAIWU.ora" 68 lines, 1556 characters __shared_pool_size = 2164260864 __large_pool_size = 16777216 __java_pool_size = 16777216 __streams_pool_size = 150994944 __db_cache_size = 1073741824 # Please change the values of the following parameters: control_files ="/yl_oradata/CAIWU/control01.ctl","/yl_oradata/CAIWU/control02.ctl","/yl_oradata/CAIWU/control03.ctl" db_recovery_file_dest = "/oracle/flash_recovery_area" db_recovery_file_dest_size= 2147483648 background_dump_dest = "/oracle/admin/CAIWU/bdump" user_dump_dest = "/oracle/admin/CAIWU/udump" core_dump_dest = "/oracle/admin/CAIWU/cdump" audit_file_dest = "/oracle/admin/CAIWU/adump" db_name = "CAIWU" # Please review the values of the following parameters: remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=CAIWUXDB)" # The values of the following parameters are from source database: processes = 500 sessions = 555 sga_target = 3439329280 db_block_size = 8192 compatible = "10.2.0.3.0" # log_archive_dest_1 = "LOCATION=/yl_oradata/arch/CAIWU/" log_archive_format = "%t_%s_%r.dbf" db_file_multiblock_read_count= 16 undo_management = "AUTO" undo_tablespace = "UNDOTBS1" job_queue_processes = 10 open_cursors = 300 pga_aggregate_target = 858783744
修改後引數檔案內容如下:
[IBMP740-2:oracle:/oracle/product/10.2.0/db_1/dbs]$cat initCAIWU.ora # Please change the values of the following parameters: control_files ="/yl_oradata/CAIWU/control01.ctl","/yl_oradata/CAIWU/control02.ctl","/yl_oradata/CAIWU/control03.ctl" db_recovery_file_dest = "/oracle/flash_recovery_area" db_recovery_file_dest_size= 2147483648 background_dump_dest = "/oracle/admin/CAIWU/bdump" user_dump_dest = "/oracle/admin/CAIWU/udump" core_dump_dest = "/oracle/admin/CAIWU/cdump" audit_file_dest = "/oracle/admin/CAIWU/adump" db_name = "CAIWU" # Please review the values of the following parameters: remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=CAIWUXDB)" # The values of the following parameters are from source database: processes = 500 sessions = 555 sga_target = 3439329280 db_block_size = 8192 compatible = "10.2.0.3.0" # log_archive_dest_1 = "LOCATION=/yl_oradata/arch/CAIWU/" log_archive_format = "%t_%s_%r.dbf" db_file_multiblock_read_count= 16 undo_management = "AUTO" undo_tablespace = "UNDOTBS1" job_queue_processes = 10 open_cursors = 300 pga_aggregate_target = 858783744
2.2.6 修改重建控制檔案的指令碼caiwu.sql
修改後的caiwu.sql內容如下:
[IBMP740-2:oracle:/yl_oradata/CAIWU]$cat caiwu.sql -- The following commands will create a new control file and use it -- to open the database. -- Data used by Recovery Manager will be lost. -- The contents of online logs will be lost and all backups will -- be invalidated. Use this only if online logs are damaged. -- After mounting the created controlfile, the following SQL -- statement will place the database in the appropriate -- protection mode: -- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE STARTUP NOMOUNT PFILE='/oracle/product/10.2.0/db_1/dbs/initCAIWU.ora' CREATE CONTROLFILE REUSE SET DATABASE "CAIWU" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 '/yl_oradata/CAIWU/redo01.log' SIZE 512M, GROUP 2 '/yl_oradata/CAIWU/redo02.log' SIZE 512M, GROUP 3 '/yl_oradata/CAIWU/redo03.log' SIZE 512M DATAFILE '/yl_oradata/CAIWU/system01.dbf', '/yl_oradata/CAIWU/undotbs01.dbf', '/yl_oradata/CAIWU/sysaux01.dbf', '/yl_oradata/CAIWU/users01.dbf', '/yl_oradata/CAIWU/zwdata01.dbf', '/yl_oradata/CAIWU/zwdata02.dbf' CHARACTER SET ZHS16GBK ; -- Database can now be opened zeroing the online logs. ALTER DATABASE OPEN RESETLOGS; -- Commands to add tempfiles to temporary tablespaces. -- Online tempfiles have complete space information. -- Other tempfiles may require adjustment. ALTER TABLESPACE TEMP ADD TEMPFILE '/yl_oradata/CAIWU/temp01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M; -- End of tempfile additions. -- set echo off prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ prompt * Your database has been created successfully! prompt * There are many things to think about for the new database. Here prompt * is a checklist to help you stay on track: prompt * 1. You may want to redefine the location of the directory objects. prompt * 2. You may want to change the internal database identifier (DBID) prompt * or the global database name for this database. Use the prompt * NEWDBID Utility (nid). prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ SHUTDOWN IMMEDIATE STARTUP UPGRADE PFILE='/oracle/product/10.2.0/db_1/dbs/initCAIWU.ora' @$ORACLE_HOME/rdbms/admin/utlirp.sql SHUTDOWN IMMEDIATE STARTUP PFILE='/oracle/product/10.2.0/db_1/dbs/initCAIWU.ora' -- The following step will recompile all PL/SQL modules. -- It may take serveral hours to complete. @$ORACLE_HOME/rdbms/admin/utlrp.sql set feedback 6;
2.3 轉換資料庫
2.3.1 建立例項CAIWU執行轉換指令碼
SQL> STARTUP NOMOUNT PFILE='/oracle/product/10.2.0/db_1/dbs/initCAIWU.ora' ORACLE instance started. Total System Global Area 3439329280 bytes Fixed Size 2087840 bytes Variable Size 671089760 bytes Database Buffers 2717908992 bytes Redo Buffers 48242688 bytes SQL> CREATE CONTROLFILE REUSE SET DATABASE "CAIWU" RESETLOGS ARCHIVELOG 2 MAXLOGFILES 16 3 MAXLOGMEMBERS 3 4 MAXDATAFILES 100 5 MAXINSTANCES 8 6 MAXLOGHISTORY 292 7 LOGFILE 8 GROUP 1 '/yl_oradata/CAIWU/redo01.log' SIZE 512M, 9 GROUP 2 '/yl_oradata/CAIWU/redo02.log' SIZE 512M, 10 GROUP 3 '/yl_oradata/CAIWU/redo03.log' SIZE 512M 11 DATAFILE 12 '/yl_oradata/CAIWU/system01.dbf', 13 '/yl_oradata/CAIWU/undotbs01.dbf', 14 '/yl_oradata/CAIWU/sysaux01.dbf', 15 '/yl_oradata/CAIWU/users01.dbf', 16 '/yl_oradata/CAIWU/zwdata01.dbf', 17 '/yl_oradata/CAIWU/zwdata02.dbf' 18 CHARACTER SET ZHS16GBK 19 ; Control file created. SQL> ALTER DATABASE OPEN RESETLOGS; Database altered. SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/yl_oradata/CAIWU/temp01.dbf' 2 SIZE 2048M AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M; Tablespace altered. SQL> SHUTDOWN IMMEDIATE Database closed. Database dismounted. ORACLE instance shut down. STARTUP UPGRADE PFILE='/oracle/product/10.2.0/db_1/dbs/initCAIWU.ora' SQL>@$ORACLE_HOME/rdbms/admin/utlirp.sql ..... SQL> SQL> Rem Continue even if there are SQL errors SQL> WHENEVER SQLERROR CONTINUE; SQL> SQL> Rem =========================================================================== SQL> Rem END utlip.sql SQL> Rem =========================================================================== SQL> SQL> DOC DOC>####################################################################### DOC>####################################################################### DOC> utlirp.sql completed successfully. All PL/SQL objects in the DOC> database have been invalidated. DOC> DOC> Shut down and restart the database in normal mode and run utlrp.sql to DOC> recompile invalid objects. DOC>####################################################################### DOC>####################################################################### DOC># SQL> SHUTDOWN IMMEDIATE Database closed. Database dismounted. ORACLE instance shut down SQL> STARTUP PFILE='/oracle/product/10.2.0/db_1/dbs/initCAIWU.ora' ORACLE instance started. Total System Global Area 3439329280 bytes Fixed Size 2087840 bytes Variable Size 671089760 bytes Database Buffers 2717908992 bytes Redo Buffers 48242688 bytes Database mounted. Database opened. SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql ..... SQL> SQL> SQL> Rem ===================================================================== SQL> Rem Run component validation procedure SQL> Rem ===================================================================== SQL> SQL> SET serveroutput on SQL> EXECUTE dbms_registry_sys.validate_components; PL/SQL procedure successfully completed. SQL> SET serveroutput off SQL> SQL> SQL> Rem =========================================================================== SQL> Rem END utlrp.sql SQL> Rem =========================================================================== SQL>
2.3.2 用system使用者和密碼進行登入來驗證
SQL> conn system/ufgov Connected.
可以登入
2.3.3 表空間驗證,查詢遷移後的表空間及檔案
SQL> select tablespace_name,file_id from dba_data_files; TABLESPACE_NAME FILE_ID ------------------------------ ---------- ZWDATA 6 ZWDATA 5 USERS 4 SYSAUX 3 UNDOTBS1 2 SYSTEM 1 6 rows selected.
2.3.4 對資料庫進行DML操作驗證
SQL> create table test (i int); Table created. SQL> insert into test values (1); 1 row created. SQL> select * from test; I ---------- 1 SQL> delete from test; 1 row deleted. SQL> drop table test; Table dropped.
2.3.5 切換日誌測試
SQL> alter system switch logfile; System altered.
小結
1. 確保源庫與目標資料庫的字符集一致
2. 要確保源庫與目標資料庫的位元組編碼相同
3. 資料庫遷移後要把無效的資料庫物件重新編譯,確保正確執行utlrp.sql,utlirp.sql
4. 資料庫遷移後,確保應用系統使用者可以正確連線,登陸有效
5. 監聽要重新配置,檢查臨時表空間的屬主與可用性
6. 遷移完成後要立即進行一次全備份
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26015009/viewspace-1291546/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 利用RMAN跨平臺遷移資料庫資料庫
- rman將linux平臺資料庫遷移到window平臺資料庫Linux資料庫
- 使用RMAN完成跨平臺資料遷移
- rman進行跨平臺資料遷移
- RMAN同位元組序跨平臺跨版本遷移資料庫資料庫
- 利用RMAN Convert database特性進行跨平臺遷移資料Database
- RMAN同位元組序跨平臺跨版本遷移資料庫(一)資料庫
- RMAN同位元組序跨平臺跨版本遷移資料庫(二)資料庫
- 跨平臺遷移oracle資料庫指南Oracle資料庫
- 應用RMAN Transportable Database進行資料庫跨平臺遷移Database資料庫
- 利用Oracle Data Guard完成跨平臺的資料庫遷移案例Oracle資料庫
- 大型資料庫跨平臺遷移總結資料庫
- 利用rman來實現linux平臺資料庫複製到windows平臺資料庫Linux資料庫Windows
- 資料庫中跨平臺遷移方法介紹資料庫
- rman 跨平臺支援
- windows平臺下Oracle10.2 RMAN資料庫遷移至Linux平臺下WindowsOracle資料庫Linux
- 利用可傳輸表空間跨平臺遷移 -RMAN CONVERT
- RMAN跨平臺傳輸資料庫和表空間資料庫
- 利用RMAN將資料庫從檔案系統遷移到ASM資料庫ASM
- 利用rman將本地資料檔案遷移到asmASM
- RMAN跨平臺可傳輸表空間和資料庫資料庫
- zt 跨平臺 跨版本 大規模資料遷移
- rman 資料庫從一臺機器遷移到另外的一臺機器資料庫
- ORACLE 跨平臺遷移方法Oracle
- 使用rman將資料庫遷移到ASM例項資料庫ASM
- RMAN備份恢復典型案例——跨平臺遷移pdb
- 跨平臺資料庫 Realm 整合實踐資料庫
- 資料庫平臺資料庫
- 利用CONVERT實現跨平臺表空間遷移
- 利用RMAN將資料庫從檔案系統遷移到ASM(單例項)資料庫ASM單例
- 跨 OS 平臺遷移 Oracle DBOracle
- 跨平臺遷移支援檢視
- 使用rman copy將資料庫遷移到ASM例項資料庫ASM
- 用傳輸表空間跨平臺遷移資料
- 一個跨平臺資料遷移的方案優化優化
- 將SAP 後臺資料庫從DB2 遷移到ORACLE資料庫DB2Oracle
- AIX 資料庫遷移到z/linuxAI資料庫Linux
- 【資料遷移】XTTS跨平臺傳輸表空間v3(2.RMAN增量)TTS