extract and replace files什么系统
发布网友
发布时间：2022-05-06 16:30
共2个回答
懂视网
时间：2022-05-06 20:52
在源端，我们需要在 EXTRACT进程中设置ENCRYPTTRAIL 参数，例如： RMTHOST 192.168.1.168, MGRPORT 7809, ENCRYPT BLOWFISH, KEYNAME encryptkey1 ENCRYPTTRAIL RMTTRAIL /opt/ogg/dirdat/la 在目标端需要在replicat进程中加入DECRYPTTRAIL参数，例如： DECR
在源端，我们需要在 EXTRACT进程中设置ENCRYPTTRAIL 参数，例如：
RMTHOST 192.168.1.168, MGRPORT 7809, ENCRYPT BLOWFISH, KEYNAME encryptkey1
ENCRYPTTRAIL RMTTRAIL /opt/ogg/dirdat/la
在目标端需要在replicat进程中加入DECRYPTTRAIL参数，例如：
DECRYPTTRAIL
注意encryptkey1是自定义生成的加密文件
热心网友
时间：2022-05-06 18:00
添加临时表空间文件即可。
alter tablespace temp01 add tempfile '/u01/app/oracle/oradata/temp01.dbf' size 100m reuse;
2、ERROR OGG-00730 No minimum supplemental logging is enabled. This may cause extract process to handle key update incorrectly if key column is not in first row piece.
需要同步的表或数据库未启用supplemental logging
alter database add supplemental log data;
alter database add supplemental log data(primary key,unique,foreign key) columns;
3、ERROR OGG-01044 The trail '/u01/app/ogg/dirdat/dg' is not assigned to extract 'DGRAC'. Assign the trail to the extract with the command "ADD EXTTRAIL/RMTTRAIL /u01/app/ogg/dirdat/dg, EXTRACT DGRAC".
trail文件未指定extract进程
add exttrail /u01/app/ogg/dirdat/dg, EXTRACT DGRAC
4、OGG-00199 Table scott.SQLLDR does not exist in target database.
目标库不存在同步的表，配置DDL或者在目标库建立相同的表。
5、ERROR OGG-00664 OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
数据库或监听未启动，或者无法连接到指定的数据库。
6、ERROR OGG-00037 DEFSFILE file /u01/app/ogg/dirdef/emp.def already exists.
表结构定义文件已存在，删除后再创建。
7、ERROR OGG-01031 There is a problem in network communication, a remote file problem, encryption ke
ys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "/u0
1/app/ogg/dirdat/rl000003" (error 11, Resource temporarily unavailable)).
源数据库与目标数据库的加密定义不一致，或目标端未定义。
8、WARNING OGG-01753 Cannot unregister EXTRACT PUMP1 from database because no database login was provided. You can manually unregister this roup later with the UNREGISTER EXTRACT command with LOGRETENTION. Issue DBLOGIN first.Deleted EXTRACT PUMP1.
由于未登录到数据库，无法删除。
9、ERROR OGG-00919 Error in COLMAP clause.
源数据库与目标数据库表字段名不一致时，需要使用COLMAP指明同步的列，列名使用""括起来。
