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

在线重新同步数据库流程：（重点是启动抽取进程时间要在恢复的SCN之前）
1、备份源系统：
rman target /
run {
backup as compressed backupset database include current controlfile format '/ywdata/full_rman/fulllisbackup_%U';
}

2、传输备份数据文件
scp

3、还原目标数据库
Export ORACLE_SID=lis
Rman target /
shutdown immediate;startup 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;

4、停止所有进程并删除抽取进程、data pump进程
stop 进程
dblogin userid goldengate password goldengate
delete 进程

5、重新配置抽取进程：
add extract extlis, tranlog, begin now
add exttrail ./dirdat/et extract extlis, megabytes 100
view params extlis

6、重新配置data pump进程：
add extract dpelis, exttrailsource ./dirdat/et
add rmttrail ./dirdat/rt, extract dpelis
view params dpelis

7、启动抽取进程和data pump进程：
start 进程

8、查询源端数据库SCN号：
select dbms_flashback.get_system_change_number from dual;
892706679

9、在源库切换日志并拷贝相关归档日志到目标数据库归档目录：
alter system switch logfile;

10、还原目标数据库至指定SCN号并打开数据库
recover database until scn 892706679;
alter database open resetlogs;

11、重新创建临时表空间
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;

12、停止并删除复制进程：
dblogin userid goldengate password goldengate
delete 进程


13、配置目标端复制进程：
dblogin userid goldengate password goldengate
edit params ./GLOBALS
添加参数，一般就是CHECKPOINTTABLE goldengate.ggchkpt
exit
dblogin userid goldengate password goldengate
add checkpointtable
add replicat replis,EXTTRAIL ./dirdat/rt CHECKPOINTTABLE goldengate.ggchkpt
view params replis

14、启动目标端复制进程：
start replis aftercsn 892706679

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

转载于:http://blog.itpub.net/26194851/viewspace-738618/