1.删除备库的表数据
2.主库导出exp
查看scn
select dbms_flashback.get_system_change_number from dual;
---------------------
1206679
exp userid=system/oracle file=/u01/app/scott02.dmp tables=scott.DEPT,scott.EMP,scott.BONUS,scott.SALGRADE FLASHBACK_SCN=1206679 CONSTRAINTS=N GRANTS=N TRIGGERS=N LOG=/u01/app/scott02.log
3.dmp文件拷贝到目的库
[oracle@host01 app]$ scp scott02.dmp oracle@192.168.56.102:/u01/app/
4.imp导入
imp system/oracle file=/u01/app/scott02.dmp LOG=/u01/app/scott02.log tables=DEPT,EMP,BONUS,SALGRADE commit=y ignore=y buffer=52428800 fromuser=scott;
5.启动主库的extract进程
GGSCI (host01) 7> start EXTRACT EORA_1
GGSCI (host01) 8> start EXTRACT PORA_1
6.启动从库的复制进程
start replicat RORA_1,aftercsn 1206679
-- The End --
阅读(2678) | 评论(0) | 转发(0) |
