ORACLE11G在同一台linux服务器从实例1全库导入到实例2上(二)

2015-11-21 01:59:03 · 作者: · 浏览: 15

6,再去检查两个实例的编码

[oracle@pttest4 expdpimpdp]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri May 29 21:32:12 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME
---------
pt2

SQL> 

SQL> SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');
Warning: connection was lost and re-established
PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_CHARACTERSET                                                 ZHS16GBK
NLS_NCHAR_CHARACTERSET                                           AL16UTF16

SQL> 

导出实例上:

[oracle@pttest4 expdpimpdp]$ export ORACLE_SID=pt1;
[oracle@pttest4 expdpimpdp]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri May 29 21:32:50 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME
---------
pt1

SQL> SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');
PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_CHARACTERSET                                                 ZHS16GBK
NLS_NCHAR_CHARACTERSET                                           AL16UTF16

SQL> 

此时,两个实例上字符集一模一样了,保持一致。

7,重新导入impdp

[oracle@pttest4 admin]$ export ORACLE_SID=pt2;
[oracle@pttest4 admin]$ impdp \'sys/sysdevpd@pt2 as sysdba\' directory=dir_dump_t3 dumpfile=expdpfull_pd_20150529_02.dmp nologfile=y TABLE_EXISTS_ACTION=REPLACE

OK,一切正常,可以导入到实例2上面了。