oracle12c 单实例迁移到rac环境,并切换ogg到rac
迁移需求
源端:linux6.5+oracle12c单实例
目标端:linux6.5+oracle12c rac
源端数据库迁移至rac环境,并配置切换ogg环境到目标rac上(原ogg为目标端)。
目标端先安装好grid和db zyfx库
Srvctl stop database -d zyfx
Su – grid
asmcmd删除zyfx库的控制文件,数据文件,日志文件,保留密码文件和参数文件。
1.源库备份:
[[email protected] zyfx]# cat zyfx.sh
su - oracle -c "export ORACLE_SID=zyfx
rman log /bak/rman/zyfx/rman-`date +%Y%m%d-%H%M`.log <<EOF
connect target /;
run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
crosscheck archivelog all;
delete noprompt expired archivelog all;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
backup as compressed backupset database format '/bak/rman/zyfx/full_%n_%T_%t_%s_%p.bak';
sql 'alter system archive log current';
backup archivelog all format '/bak/rman/zyfx/arch_%d_%T_%s_%p.bak';
backup current controlfile format '/bak/rman/zyfx/ctl_%d_%T_%s_%p.bak';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
exit;
EOF"
[[email protected] zyfx]# pwd
/bak/rman/zyfx
nohup ./zyfx.sh > ./zyfx.out &
查看备份进度:
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" FROM V$SESSION_LONGOPS WHERE OPNAME LIKE 'RMAN%' AND OPNAME NOT LIKE '%aggregate%' AND TOTALWORK != 0 AND SOFAR <> TOTALWORK;
4小时45分钟
2.目标库恢复控制文件
startup nomount;
rman target /
restore controlfile from '/bak/rman/zyfx/ctl_ZYFX_20190417_28_1.bak';
alter database mount;
2分钟
3.目标库恢复数据库
确定文件路径:
set pagesize 200 linesize 200
select 'set newname for datafile ' || a.FILE# || ' to "' || a.NAME || '";'
from v$datafile a
union all
select 'set newname for tempfile ' || a.FILE# || ' to "' || a.NAME || '";'
from v$tempfile a
union all
SELECT 'SQL "ALTER DATABASE RENAME FILE ''''' || a.MEMBER || ''''' to ''''' ||
a.MEMBER || ''''' ";'
FROM v$logfile a;
set pagesize 200 linesize 200
select 'set newname for datafile ' || a.FILE# || ' to "+DATADG";'
from v$datafile a
union all
select 'set newname for tempfile ' || a.FILE# || ' to "+DATADG";'
from v$tempfile a
union all
SELECT 'SQL "ALTER DATABASE RENAME FILE ''''' || a.MEMBER || ''''' to ''''+DATADG'''' ";'
FROM v$logfile a;
select 'alter database rename file '''|| member || ''' to'''|| replace(member,'源库路径','目标库路径') || ''';' from v$logfile;
su - oracle -c "export ORACLE_SID=zyfx1
rman log /bak/rman/zyfx/rman-restore-`date +%Y%m%d-%H%M`.log <<EOF
connect target /;
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
set newname for datafile 1 to '+DATADG';
set newname for datafile 2 to '+DATADG';
set newname for datafile 3 to '+DATADG';
set newname for datafile 4 to '+DATADG';
set newname for datafile 5 to '+DATADG';
set newname for datafile 7 to '+DATADG';
set newname for datafile 8 to '+DATADG';
set newname for datafile 9 to '+DATADG';
set newname for datafile 10 to '+DATADG';
set newname for datafile 11 to '+DATADG';
set newname for datafile 12 to '+DATADG';
set newname for datafile 13 to '+DATADG';
set newname for datafile 14 to '+DATADG';
set newname for datafile 15 to '+DATADG';
set newname for datafile 16 to '+DATADG';
set newname for datafile 17 to '+DATADG';
set newname for datafile 18 to '+DATADG';
set newname for datafile 19 to '+DATADG';
set newname for datafile 20 to '+DATADG';
set newname for datafile 21 to '+DATADG';
set newname for datafile 22 to '+DATADG';
set newname for datafile 23 to '+DATADG';
set newname for datafile 24 to '+DATADG';
set newname for datafile 25 to '+DATADG';
set newname for datafile 26 to '+DATADG';
set newname for datafile 27 to '+DATADG';
set newname for datafile 28 to '+DATADG';
set newname for datafile 29 to '+DATADG';
set newname for datafile 30 to '+DATADG';
set newname for datafile 31 to '+DATADG';
set newname for datafile 32 to '+DATADG';
set newname for datafile 33 to '+DATADG';
set newname for datafile 34 to '+DATADG';
set newname for datafile 35 to '+DATADG';
set newname for datafile 36 to '+DATADG';
set newname for datafile 37 to '+DATADG';
set newname for datafile 38 to '+DATADG';
set newname for datafile 39 to '+DATADG';
set newname for datafile 40 to '+DATADG';
set newname for datafile 41 to '+DATADG';
set newname for datafile 42 to '+DATADG';
set newname for datafile 43 to '+DATADG';
set newname for datafile 44 to '+DATADG';
set newname for datafile 45 to '+DATADG';
set newname for datafile 46 to '+DATADG';
set newname for datafile 47 to '+DATADG';
set newname for datafile 48 to '+DATADG';
set newname for datafile 49 to '+DATADG';
set newname for datafile 50 to '+DATADG';
set newname for datafile 51 to '+DATADG';
set newname for datafile 52 to '+DATADG';
set newname for datafile 53 to '+DATADG';
set newname for datafile 54 to '+DATADG';
set newname for datafile 55 to '+DATADG';
set newname for datafile 56 to '+DATADG';
set newname for datafile 57 to '+DATADG';
set newname for datafile 58 to '+DATADG';
set newname for datafile 59 to '+DATADG';
set newname for datafile 60 to '+DATADG';
set newname for datafile 61 to '+DATADG';
set newname for datafile 62 to '+DATADG';
set newname for datafile 63 to '+DATADG';
set newname for datafile 64 to '+DATADG';
set newname for datafile 65 to '+DATADG';
set newname for datafile 66 to '+DATADG';
set newname for datafile 67 to '+DATADG';
set newname for datafile 68 to '+DATADG';
set newname for datafile 69 to '+DATADG';
set newname for datafile 70 to '+DATADG';
set newname for datafile 71 to '+DATADG';
set newname for datafile 72 to '+DATADG';
set newname for datafile 73 to '+DATADG';
set newname for datafile 74 to '+DATADG';
set newname for datafile 75 to '+DATADG';
set newname for datafile 76 to '+DATADG';
set newname for datafile 77 to '+DATADG';
set newname for datafile 78 to '+DATADG';
set newname for datafile 79 to '+DATADG';
set newname for datafile 80 to '+DATADG';
set newname for datafile 81 to '+DATADG';
set newname for datafile 82 to '+DATADG';
set newname for datafile 83 to '+DATADG';
set newname for datafile 84 to '+DATADG';
set newname for datafile 85 to '+DATADG';
set newname for datafile 86 to '+DATADG';
set newname for datafile 87 to '+DATADG';
set newname for tempfile 1 to '+DATADG';
restore database;
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
exit;
EOF"
nohup ./zyfx_restore.sh > ./zyfx_restore.out &
查看恢复进度:
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" FROM V$SESSION_LONGOPS WHERE OPNAME LIKE 'RMAN%' AND OPNAME NOT LIKE '%aggregate%' AND TOTALWORK != 0 AND SOFAR <> TOTALWORK;
@ /bak/rman/zyfx/redo.sql
ALTER DATABASE RENAME FILE '/oracle/app/oracle/oradata/zyfx/redo01.log' to '+DATADG/ zyfx/online/redo01.log';
ALTER DATABASE RENAME FILE '/oracle/app/oracle/oradata/zyfx/redo02.log' to '+DATADG/ zyfx/online/redo02.log';
ALTER DATABASE RENAME FILE '/oracle/app/oracle/oradata/zyfx/redo03.log' to '+DATADG/ zyfx/online/redo03.log';
ALTER DATABASE RENAME FILE '/oracle/app/oracle/oradata/zyfx/redo04.log' to '+DATADG/ zyfx/online/redo04.log';
ALTER DATABASE RENAME FILE '/oracle/app/oracle/oradata/zyfx/redo05.log' to '+DATADG/ zyfx/online/redo05.log';
ALTER DATABASE RENAME FILE '/oracle/app/oracle/oradata/zyfx/redo06.log' to '+DATADG/ zyfx/online/redo06.log';
4.目标应用数据库
RUN
{
--set until sequence 27434;
recover database;
}
5.停止原ogg和数据库
162/166上停止推送t180
180上检查lag不变后info r_ossdb1,info r_fw停止复制进程,停止数据库。
GGSCI (archive.cloudera.com) 1>
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING R_FW 00:00:00 00:00:09
REPLICAT RUNNING R_OSSDB1 00:00:00 00:00:09
GGSCI (archive.cloudera.com) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING R_FW 00:00:00 00:00:05
REPLICAT RUNNING R_OSSDB1 00:00:00 00:00:05
GGSCI (archive.cloudera.com) 3> info r_fw
REPLICAT R_FW Last Started 2019-04-11 09:51 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Process ID 27738
Log Read Checkpoint File /data/ogg/dirdat/fw000003
2019-04-17 14:22:55.001342 RBA 62207738
GGSCI (archive.cloudera.com) 4> info r_ossdb1
REPLICAT R_OSSDB1 Last Started 2019-04-11 09:51 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Process ID 27751
Log Read Checkpoint File /data/ogg/dirdat/zy000190
2019-04-17 14:23:25.001115 RBA 87571007
GGSCI (archive.cloudera.com) 5> info r_ossdb1
REPLICAT R_OSSDB1 Last Started 2019-04-11 09:51 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Process ID 27751
Log Read Checkpoint File /data/ogg/dirdat/zy000190
2019-04-17 14:23:25.001115 RBA 87571007
GGSCI (archive.cloudera.com) 6> info r_fw
REPLICAT R_FW Last Started 2019-04-11 09:51 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Process ID 27738
Log Read Checkpoint File /data/ogg/dirdat/fw000003
2019-04-17 14:22:55.001342 RBA 62207738
GGSCI (archive.cloudera.com) 7> info r_fw
REPLICAT R_FW Last Started 2019-04-11 09:51 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Process ID 27738
Log Read Checkpoint File /data/ogg/dirdat/fw000003
2019-04-17 14:22:55.001342 RBA 62207738
GGSCI (archive.cloudera.com) 8> info r_ossdb1
REPLICAT R_OSSDB1 Last Started 2019-04-11 09:51 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Process ID 27751
Log Read Checkpoint File /data/ogg/dirdat/zy000190
2019-04-17 14:23:25.001115 RBA 87571007
GGSCI (archive.cloudera.com) 9> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING R_FW 00:00:00 00:00:08
REPLICAT RUNNING R_OSSDB1 00:00:00 00:00:07
GGSCI (archive.cloudera.com) 10> stop r_fw
Sending STOP request to REPLICAT R_FW ...
Request processed.
GGSCI (archive.cloudera.com) 11> stop r_ossdb1
Sending STOP request to REPLICAT R_OSSDB1 ...
Request processed.
GGSCI (archive.cloudera.com) 12> info r_fw
REPLICAT R_FW Last Started 2019-04-11 09:51 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
Log Read Checkpoint File /data/ogg/dirdat/fw000003
2019-04-17 14:22:55.001342 RBA 62207738
GGSCI (archive.cloudera.com) 13> info r_ossdb1
REPLICAT R_OSSDB1 Last Started 2019-04-11 09:51 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint File /data/ogg/dirdat/zy000190
2019-04-17 14:23:25.001115 RBA 87571007
6.目标追加日志恢复
cp /oracle/app/oracle/oradata/zyfx/redo03.log /bak/rman/zyfx/
RECOVER DATABASE USING BACKUP CONTROLFILE until cancel;
--Alter database open read only可检验数据
7. 目标尝试完整打开
alter database open resetlogs;
[[email protected] zyfx]# su - oracle
[[email protected] ~]$ sqlplus /nolog
SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 17 14:39:18 2019
Copyright (c) 1982, 2016, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> set line 132
SQL> set wrap off
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 5 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 5 thread 1: '+DATADG/zyfx/online/redo05.log'
SQL> ALTER DATABASE CLEAR LOGFILE GROUP 5;
Database altered.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [ksvworkmsgalloc: bad reaper], [0x0801C0003], [], [], [], [], [], [], [], [], [], []
SQL> select * from v$Logfile;
rows will be truncated
rows will be truncated
GROUP# STATUS TYPE MEMBER
---------- ------- ------- ---------------------------------------------------------------------------------------------------------
2 ONLINE +DATADG/zyfx/online/redo02.log
1 ONLINE +DATADG/zyfx/online/redo01.log
3 ONLINE +DATADG/zyfx/online/redo03.log
4 ONLINE +DATADG/zyfx/online/redo04.log
5 ONLINE +DATADG/zyfx/online/redo05.log
6 ONLINE +DATADG/zyfx/online/redo06.log
6 rows selected.
SQL> ALTER DATABASE CLEAR LOGFILE GROUP 6;
Database altered.
SQL> set line 132
SQL> select * from v$Log;
truncating (as requested) before column NEXT_CHANGE#
rows will be truncated
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- -----------
1 1 0 1073741824 512 1 YES CLEARING 1.5741E+13 2019-04-17 10:06:07 2019-04-17
2 1 0 1073741824 512 1 YES CLEARING 1.5741E+13 2019-04-17 09:00:45 2019-04-17
6 1 0 1073741824 512 1 YES UNUSED 1.5741E+13 2019-04-17 08:38:29 2019-04-17
4 1 0 1073741824 512 1 YES CLEARING 1.5741E+13 2019-04-17 10:04:05 2019-04-17
5 1 27724 1073741824 512 1 YES CURRENT 1.5741E+13 2019-04-17 10:06:07
3 1 0 1073741824 512 1 YES CLEARING 1.5741E+13 2019-04-17 09:31:34 2019-04-17
6 rows selected.
SQL> ALTER DATABASE CLEAR LOGFILE GROUP 1;
Database altered.
SQL> ALTER DATABASE CLEAR LOGFILE GROUP 2;
Database altered.
SQL> ALTER DATABASE CLEAR LOGFILE GROUP 3;
Database altered.
SQL> select * from v$Log;
truncating (as requested) before column NEXT_CHANGE#
rows will be truncated
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- -----------
1 1 0 1073741824 512 1 YES UNUSED 1.5741E+13 2019-04-17 10:06:07 2019-04-17
2 1 0 1073741824 512 1 YES UNUSED 1.5741E+13 2019-04-17 09:00:45 2019-04-17
6 1 0 1073741824 512 1 YES UNUSED 1.5741E+13 2019-04-17 08:38:29 2019-04-17
4 1 0 1073741824 512 1 YES CLEARING 1.5741E+13 2019-04-17 10:04:05 2019-04-17
5 1 27724 1073741824 512 1 YES CURRENT 1.5741E+13 2019-04-17 10:06:07
3 1 0 1073741824 512 1 YES UNUSED 1.5741E+13 2019-04-17 09:31:34 2019-04-17
6 rows selected.
SQL> ALTER DATABASE CLEAR LOGFILE GROUP 4;
Database altered.
SQL> select * from v$Log;
truncating (as requested) before column NEXT_CHANGE#
rows will be truncated
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- -----------
1 1 0 1073741824 512 1 YES UNUSED 1.5741E+13 2019-04-17 10:06:07 2019-04-17
2 1 0 1073741824 512 1 YES UNUSED 1.5741E+13 2019-04-17 09:00:45 2019-04-17
6 1 0 1073741824 512 1 YES UNUSED 1.5741E+13 2019-04-17 08:38:29 2019-04-17
4 1 0 1073741824 512 1 YES UNUSED 1.5741E+13 2019-04-17 10:04:05 2019-04-17
5 1 27724 1073741824 512 1 YES CURRENT 1.5741E+13 2019-04-17 10:06:07
3 1 0 1073741824 512 1 YES UNUSED 1.5741E+13 2019-04-17 09:31:34 2019-04-17
6 rows selected.
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> alter database open resetlogs;
Database altered.
SQL>
8. 目标添加temp
select * from dba_temp_files;
两节点的rac建议偶数个临时文件,比如2个
alter database tempfile '+DATADG/ZYFX/TEMPFILE/temp.268.1005835335' resize 10240M;
ALTER TABLESPACE TEMP ADD TEMPFILE '+DATADG' size 10240M autoextend on;
9. 目标添加undo
SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
USERS
SYSAUX
UNDOTBS1
IMFAST
OGG
TEMP
7 rows selected.
SQL> create undo tablespace undotbs2 datafile '+DATADG' size 20480M autoextend on;
SQL> alter system set undo_tablespace='undotbs1' scope=spfile sid='zyfx1';
SQL> alter system set undo_tablespace='undotbs2' scope=spfile sid='zyfx2';
SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
USERS
SYSAUX
UNDOTBS1
IMFAST
OGG
TEMP
UNDOTBS2
10. 目标添加redo
alter database add logfile thread 2 group 7 '+DATADG';
alter database add logfile thread 2 group 8 '+DATADG';
alter database add logfile thread 2 group 9 '+DATADG';
alter database add logfile thread 2 group 10 '+DATADG';
alter database add logfile thread 2 group 11'+DATADG';
alter database add logfile thread 2 group 12 '+DATADG';
SQL> select thread#,instance,status,enabled from v$thread;
THREAD# INSTANCE STATUS ENABLED
---------- -------------------------------------------------------------------------------- ------ --------
1 zyfx1 OPEN PUBLIC
2 UNNAMED_INSTANCE_2 CLOSED DISABLED
SQL> alter database enable thread 2 ;
Database altered.
SQL> select thread#,instance,status,enabled from v$thread;
THREAD# INSTANCE STATUS ENABLED
---------- -------------------------------------------------------------------------------- ------ --------
1 zyfx1 OPEN PUBLIC
2 UNNAMED_INSTANCE_2 CLOSED PRIVATE
11. 目标执行rac视图
@$ORACLE_HOME/rdbms/admin/catclust.sql
5分钟
12. 目标重启数据库及更新数据字典
注意打补丁需要将alter system set job_queue_processes=0 scope=both sid='*';
srvctl stop database -d zyfx
srvctl start database -d zyfx
更新数据字典:5分钟
[[email protected] ~]# su - oracle
[[email protected] ~]$ cd /oracle/app/oracle/product/12.2.0/db_1/OPatch
[[email protected] OPatch]$ ./datapatch –verbose
select patch_id,action,status from dba_registry_sqlpatch;
还原修改job:
alter system set job_queue_processes=2000 scope=both sid='*';
ogg启用:
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION=TRUE SCOPE=BOTH sid='*';
提示:reboot重启主机需要10-15分钟
13. 目标定时删除归档
[[email protected] ~]$ crontab -l
0 12 * * * /home/oracle/clear_archivelog.sh
[[email protected] ~]$ cat clear_archivelog.sh
#!/bin/sh
source ~/.bash_profile
export ORACLE_SID=zyfx2
/oracle/app/oracle/product/12.2.0/db_1/bin/rman target / >> /home/oracle/clear_archive20190412.log << EOF
crosscheck archivelog all;
delete noprompt expired archivelog all;
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE - 15';
exit
EOF
14.ogg配置修改推送IP指向
源端需要先记录推送进程的rba和seqno(info t180),然后修改推送进程配置以及删除推送进程重新配置。
目标端注意12c的GLOBALS配置,重启mgr后重新配置复制进程,然后从seqno和rba的0
GGSCI (racd1) 2> view param ./GLOBALS
GGSCHEMA oggadm
TRAIL_SEQLEN_6D
CHECKPOINTTABLE oggadm.CHECKTABLE
如果不小心先删掉源端的推送进程,并且忘记了rba,seqno,那么需要查看原目标端info r_fw的seqno和rba位置,通过logdump打开定位位置scanfortime 2019-04-17 14:23:24,对比新目标端的队列文件的位置,修改复制进程的rba和seqno。源端推送进程的位置rba和seqno需要保证抽取的时间点在复制之前。
166上配置:
修改推送ip指向
GGSCI (racj1) 2> edit param t180
EXTRACT T180
SETENV (NLS_LANG ="AMERICAN_AMERICA.ZHS16GBK")
USERID OGGADM, PASSWORD OGGADM
RMTHOST 10.12.248.131, MGRPORT 7809, COMPRESS
RMTTRAIL /data/ogg/dirdat/fw
PASSTHRU
TABLE FWBZ.T_TROUBLE_ALARMINFO;
stop t180
start t180
info t180
GGSCI (racj1) 29> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING GDCQ 00:00:03 00:00:01
EXTRACT ABENDED T180 00:00:00 01:16:43
EXTRACT RUNNING T245 00:00:00 00:00:07
EXTRACT RUNNING T247 00:00:00 00:00:01
GGSCI (racj1) 30> info t180
EXTRACT T180 Last Started 2019-04-17 15:39 Status ABENDED
Checkpoint Lag 00:00:00 (updated 01:16:47 ago)
Log Read Checkpoint File ./dirdat/gd004542
2019-04-17 14:23:00.000000 RBA 75635504
GGSCI (racj1) 31> delete t180
Deleted EXTRACT T180.
GGSCI (racj1) 32> add extract t180, exttrailsource ./dirdat/gd
EXTRACT added.
GGSCI (racj1) 33> add rmttrail /ogg/12c/dirdat/fw, extract t180, megabytes 100
RMTTRAIL added.
GGSCI (racj1) 34> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING GDCQ 00:00:03 00:00:03
EXTRACT STOPPED T180 00:00:00 00:00:03
EXTRACT RUNNING T245 00:00:00 00:00:00
EXTRACT RUNNING T247 00:00:00 00:00:04
GGSCI (racj1) 35> info t180
EXTRACT T180 Initialized 2019-04-17 15:42 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
Log Read Checkpoint File ./dirdat/gd000000
First Record RBA 0
GGSCI (racj1) 36> alter extract t180,thread 2,extseqno 4542,extrba 75635504
EXTRACT altered.
GGSCI (racj1) 37> info t180
EXTRACT T180 Initialized 2019-04-17 15:43 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint File ./dirdat/gd004542
First Record RBA 75635504
GGSCI (racj1) 38> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING GDCQ 00:00:02 00:00:01
EXTRACT STOPPED T180 00:00:00 00:00:07
EXTRACT RUNNING T245 00:00:00 00:00:09
EXTRACT RUNNING T247 00:00:00 00:00:03
GGSCI (racj1) 39> start t180
Sending START request to MANAGER ...
EXTRACT T180 starting
GGSCI (racj1) 40> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING GDCQ 00:00:02 00:00:06
EXTRACT RUNNING T180 00:00:00 00:00:13
EXTRACT RUNNING T245 00:00:00 00:00:04
EXTRACT RUNNING T247 00:00:00 00:00:08
GGSCI (racj1) 41> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING GDCQ 00:00:02 00:00:09
EXTRACT RUNNING T180 00:00:00 00:00:00
EXTRACT RUNNING T245 00:00:00 00:00:07
EXTRACT RUNNING T247 00:00:00 00:00:01
GGSCI (racj1) 42> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING GDCQ 00:00:03 00:00:01
EXTRACT RUNNING T180 00:00:00 00:00:01
EXTRACT RUNNING T245 00:00:00 00:00:09
EXTRACT RUNNING T247 00:00:00 00:00:03
GGSCI (racj1) 43>
162上配置:
GGSCI (raci1) 2> edit param t180
EXTRACT T180
SETENV (NLS_LANG ="AMERICAN_AMERICA.ZHS16GBK")
USERID OGGADM, PASSWORD OGGADM
RMTHOST 10.12.248.131, MGRPORT 7809, COMPRESS
RMTTRAIL /data/ogg/dirdat/zy
PASSTHRU
TABLE GISTAR.AREA;
TABLE GISTAR.BREAKPOINT;
TABLE GISTAR.BUILDING;
TABLE GISTAR.DE_ATM_CIRCUIT;
TABLE GISTAR.DE_ATM_CIRCUIT_ROUTE;
TABLE GISTAR.DE_CHANNEL;
TABLE GISTAR.DE_CHANNEL_ROUTE;
stop t180
start t180
info t180
132上配置:
检查/ogg/12c/dirdat生成的文件gd和zy开头
dblogin userid oggadm, password oggadm
stop r_fw
delete r_fw
add replicat r_fw, exttrail /ogg/12c/dirdat/fw, checkpointtable oggadm.CHECKTABLE
alter r_fw extseqno 0,extrba 0
delete r_ossdb1
add replicat r_zy, exttrail /ogg/12c/dirdat/zy, checkpointtable oggadm.CHECKTABLE
alter r_zy extseqno 0,extrba 12598565
180 |
132 |