ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ogg停止业务重新初始化目标数据库流程

ogg停止业务重新初始化目标数据库流程

原创 Linux操作系统 作者:db_wjw 时间:2012-07-07 14:39:43 0 删除 编辑
有时候如果数据差异太大,可能需要重新同步整个数据库,可以参考下列流程

源端:
run {
backup as compressed backupset database include current controlfile format '/ywdata/full_rman/fulllisbackup_%U';
}
查询一个scn号:
select current_scn from v$database;
select dbms_flashback.get_system_change_number from dual;
887839592
将备份集拷贝到目标端


目标端:
停止应用程序
shutdown immediate;
start nomount;
restore controlfile from '/ywarch/full_rman/fulllisbackup_senffv7v_1_1'
alter database mount;
catalog backuppiece  '/ywarch/full_rman/fulllisbackup_sdnffs25_1_1'
restore database;
拷贝归档日志
recover database until scn 887839592;
alter database open resetlogs;

创建临时表空间
create temporary tablespace test tempfile '/ywdata/lis/test01.dbf' size 200m;
alter database default temporary tablespace test;
drop tablespace temp including contents and datafiles;
create temporary tablespace temp tempfile '/ywdata/lis/temp01.dbf' size 2g reuse;
alter database default temporary tablespace temp;
drop tablespace test including contents and datafiles;
select file_name from dba_temp_files;


目标端goldengate:
dblogin userid goldengate password goldengate
delete replicat replis
edit params ./GLOBALS
添加参数,一般就是CHECKPOINTTABLE goldengate.ggchkpt
exit
dblogin userid goldengate password goldengate
add checkpointtable
add replicat replis,EXTTRAIL ./dirdat/rt CHECKPOINTTABLE goldengate.ggchkpt
edit params replis
参数根据需要做修改
alter replicat replis extseqno 89, extrba 0
start replis aftercsn 887839592

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26194851/viewspace-734858/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-08-21

  • 博文量
    96
  • 访问量
    506462