linux oracle 恢复到 windows,oracle从linux传输数据库到windows

用于检查外部表和Bfile

SQL>SET SERVEROUTPUT ON

DECLARE

external BOOLEAN;

BEGIN

external := DBMS_TDB.CHECK_EXTERNAL;

END;

/

If you call DBMS_TDB.CHECK_DB and no messages are displayed indicating conditions preventing transport

before the PL/SQL procedure successfully completed message, then your database is ready for transport.

如果没有信息返回(在PL/SQL procedure successfully completed.之前)。说明数据库已经准备好了跨平台迁移。

2、在源数据库上转换数据库

SQL> STARTUP MOUNT;

SQL> ALTER DATABASE OPEN READ ONLY;

SQL> select * from v$db_transportable_platform;

PLATFORM_ID PLATFORM_NAME                                                ENDIAN_FORMAT

----------- ------------------------------------------------------------ --------------

7 Microsoft Windows IA (32-bit)                                Little

10 Linux IA (32-bit)                                            Little

5 HP Tru64 UNIX                                                Little

11 Linux IA (64-bit)                                            Little

15 HP Open VMS                                                  Little

8 Microsoft Windows IA (64-bit)                                Little

13 Linux 64-bit for AMD                                         Little

12 Microsoft Windows 64-bit for AMD                             Little

17 Solaris Operating System (x86)                               Little

9 rows selected.

SQL> SET SERVEROUTPUT ON

SQL> DECLARE

db_ready BOOLEAN;

BEGIN

db_ready := DBMS_TDB.CHECK_DB('Microsoft Windows IA (32-bit)');

END;

/

PL/SQL procedure successfully completed.

SQL> SET SERVEROUTPUT ON

SQL> DECLARE

external BOOLEAN;

BEGIN

external := DBMS_TDB.CHECK_EXTERNAL;

END;

/

The following directories exist in the database:

SYS.DB_FILES_DIRECTORY, SYS.DATA_PUMP_DIR, SYS.WORK_DIR, SYS.ADMIN_DIR

PL/SQL procedure successfully completed.

3、备份源库，并copy所有的pfile、数据文件、scrīpt到目标库

rman >run {

CONVERT DATABASE NEW DATABASE 'sztech'

transport script '/home/oracle/oradata/transportscript'

to platform 'Microsoft Windows IA (32-bit)'

db_file_name_convert '/oracle/app/oracle/oradata/sztech1' '/home/oracle/oradata/';

}

copy /home/oracle/oradata/目录下的数据文件、scrīpt到目标库

channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01

Run SQL script /home/oracle/oradata/transportscript on the target platform to create database

Edit init.ora file /u01/app/oracle/product/11.2.0/db_1/dbs/init_00lh4ff9_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 25-JUN-10

创建基础环境

首先创建相关目录：

mkdir d:\oracle\product\11.2.0\admin\sztech\adump

mkdir d:\oracle\product\11.2.0\admin\sztech\bdump

mkdir d:\oracle\product\11.2.0\admin\sztech\cdump

mkdir d:\oracle\product\11.2.0\admin\sztech\dpdump

mkdir d:\oracle\product\11.2.0\admin\sztech\pfile

mkdir d:\oracle\product\11.2.0\admin\sztech\udump

创建Windows数据库服务：

d:\oracle\>oradim -new -sid sztech

实例已创建。

4、在目标库上恢复数据库、并升级数据库

在目标库上运行脚本transportscrīpt (需要根据需要修改该脚本文件，如controlfile的路径)

SQL>@transportscrīpt

该脚本包含步骤如下：

恢复pfile，修改pfile中相应的路径位置。启动数据库

STARTUP NOMOUNT PFILE='D:\oracle\product\11.2.0\db_1\database\initsztech.ora'

CREATE CONTROLFILE REUSE SET DATABASE "sztech" RESETLOGS  ARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 SIZE 50M,

GROUP 2 SIZE 50M,

GROUP 3 SIZE 50M

DATAFILE

'D:\oracle\product\11.2.0\oradata\sztech\system01.dbf',

'D:\oracle\product\11.2.0\oradata\sztech\undotbs01.dbf',

'D:\oracle\product\11.2.0\oradata\sztech\sysaux01.dbf',

'D:\oracle\product\11.2.0\oradata\sztech\users01.dbf',

'D:\oracle\product\11.2.0\oradata\sztech\example01.dbf',

'D:\oracle\product\11.2.0\oradata\sztech\tbsaddm.dbf',

'D:\oracle\product\11.2.0\oradata\sztech\tbsaddm2.dbf',

'D:\oracle\product\11.2.0\oradata\sztech\tsp_ts.dbf'

CHARACTER SET ZHS16GBK

;

alter database open resetlogs;   ---不需要升级就可以直接resetlog打开数据库

ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\oracle\product\11.2.0\oradata\sztech\temp01.dbf'

SIZE 26214400  AUTOEXTEND ON NEXT 5242880  MAXSIZE 104857600 ;

附:

D:\oracle\product\11.2.0\db_1\database\initsztech.ora 内容:

# Please change the values of the following parameters:

control_files            = "D:\oracle\product\11.2.0\oradata\sztech/control01_ctl"

db_recovery_file_dest    = "D:\oracle\product\11.2.0\flash_recovery_area"

db_recovery_file_dest_size= 4244635648

background_dump_dest     = "D:\oracle\product\11.2.0\admin\sztech\bdump"

user_dump_dest           = "D:\oracle\product\11.2.0\admin\sztech\udump"

core_dump_dest           = "D:\oracle\product\11.2.0\admin\sztech\cdump"

audit_file_dest          = "D:\oracle\product\11.2.0\admin\sztech\adump"

db_name                  = "sztech"

# Please review the values of the following parameters:

__shared_pool_size       = 104857600

__large_pool_size        = 4194304

__java_pool_size         = 4194304

__streams_pool_size      = 0

__db_cache_size          = 197132288

remote_login_passwordfile= "EXCLUSIVE"

db_domain                = ""

dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"