朋友问题

问题分析

主库

SQL> select * from v$version;

BANNER

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

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

SQL> conn testuser/system

Connected.

SQL> select count(*) from tab;

COUNT(*)

----------

2

SQL> select tname from tab;

TNAME

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

T_NEWDG

T_TESTUSER

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

导出主库testuser用户t_newdg表

[oracle@langfang ~]$ exp userid=testuser/system file=exp_t_newdg.dmp tables=t_newdg

Export: Release 11.2.0.4.0 - Production on Fri Apr 10 22:22:29 2015

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...

. . exporting table T_NEWDG 1 rows exported

Export terminated successfully without warnings.

删除主库上述导出的表

[oracle@langfang ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 10 22:24:27 2015

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> drop table testuser.t_newdg purge;

Table dropped.

SQL> alter system switch logfile;

System altered.

确认主库已删表已同步至备库

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> select count(*) from testuser.t_newdg;

select count(*) from testuser.t_newdg

*

ERROR at line 1:

ORA-00942: table or view does not exist

在主库导入上述已导出的DMP文件

[oracle@langfang ~]$ imp userid=testuser/system file=exp_t_newdg.dmp tables=t_newdg

Import: Release 11.2.0.4.0 - Production on Fri Apr 10 22:28:23 2015

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V11.02.00 via conventional path

import done in ZHS16GBK character set and AL16UTF16 NCHAR character set

. importing TESTUSER's objects into TESTUSER

. . importing table "T_NEWDG" 1 rows imported

Import terminated successfully without warnings.

[oracle@langfang ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 10 22:28:40 2015

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from testuser.t_newdg;

COUNT(*)

----------

1

SQL> alter system switch logfile;

System altered.

确认主库变更同步至备库

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> select count(*) from testuser.t_newdg;

COUNT(*)

----------

1

测试结论

如果在主库导入exp导出的DMP文件，会自动同步至备库

个人简介

8年oracle从业经验，具备丰富的oracle技能，目前在国内北京某专业oracle服务公司从事高级技术顾问。

服务过的客户：

中国电信

中国移动

中国联通

中国电通

国家电网

四川达州商业银行

湖南老百姓大药房

山西省公安厅

中国邮政

北京302医院

河北廊坊新奥集团公司


项目经验:

中国电信3G项目AAA系统数据库部署及优化

中国联通CRM数据库性能优化

中国移动10086电商平台数据库部署及优化

湖南老百姓大药房ERR数据库sql优化项目

四川达州商业银行TCBS核心业务系统数据库模型设计和RAC部署及优化

四川达州商业银行TCBS核心业务系统后端批处理存储过程功能模块编写及优化

北京高铁信号监控系统RAC数据库部署及优化

河南宇通客车数据库性能优化

中国电信电商平台核心采购模块表模型设计及优化

中国邮政储蓄系统数据库性能优化及sql优化

北京302医院数据库迁移实施

河北廊坊新奥data guard部署及优化

山西公安厅身份证审计数据库系统故障评估

国家电网上海灾备项目4 node rac+adg
贵州移动crm及客服数据库性能优化项目


联系方式：

  手机：18201115468

qq : 305076427

qq微博: wisdomone1

新浪微博：wisdomone9

qq群：275813900

itpub博客名称：wisdomone1 http://blog.itpub.net/9240380/

ITPub博客

oracle 11.2.0.4 data guard--在主库导入exp产生的dmp文件，会同步到备库吗

个人简介

最新文章