CONVERT DATABASE命令-数据库迁移(from linux to windows) - 副本.docVIP

CONVERT DATABASE命令（一） SQL SELECT * FROM V$TRANSPORTABLE_PLATFORM; PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT----------- -------------------------------------------------- --------------1 Solaris[tm] OE (32-bit) Big2 Solaris[tm] OE (64-bit) Big7 Microsoft Windows IA (32-bit) Little10 Linux IA (32-bit) Little6 AIX-Based Systems (64-bit) Big3 HP-UX (64-bit) Big5 HP Tru64 UNIX Little4 HP-UX IA (64-bit) Big11 Linux IA (64-bit) Little15 HP Open VMS Little8 Microsoft Windows IA (64-bit) Little9 IBM zSeries Based Linux Big13 Linux 64-bit for AMD Little16 Apple Mac OS Big12 Microsoft Windows 64-bit for AMD Little17 Solaris Operating System (x86) Little18 IBM Power Based Linux Big 已选择17行。 2,下面可以执行CONVERT DATABASE命令了，这个命令要求源数据库和目标数据库的编码字符序一致。 SELECT tp.endian_format FROM v$transportable_platform tp, v$database d WHERE tp.platform_name = d.platform_name; 3,且要求执行CONVERT DATABASE的源数据库处于只读状态： SQL shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL startup open read onlyORACLE 例程已经启动。RMAN convert database new database tranexam skip offline transport script /home/new/trans_script.sql to platform Microsoft Windows IA (32-bit) format /home/new/%U_%T_%n_%N.dbf; … 5,利用DBMS_FILE_TRANSFER包或ftp，完成数据文件和初始化参数文件的传输工作。 6,而且利用CONVERT DATABASE命令还得到了在目标数据库上加载打开数据库的脚本：/home/new/trans_script.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=/home/new/init_00lv5fo4_1_0EXAMTRAN_DUMMY_TBS_0_0_0.dbf.ora CREATE CONTROLFILE REUSE SET DATABASE EXAMTRAN RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 10