Troubleshooting GoldenGate Extract When Reading Redo Logs on ASM, ERROR OGG-00446 Getting attributes for ASM file, ORA-15173: entry 'oramcbta' does not exist in directory (Doc ID 1315404.1)
APPLIES TO:
Oracle GoldenGate - Version 10.4.0.0 and laterInformation in this document applies to any platform.
***Checked for relevance on 06-April-2014***
PURPOSE
When redo/archived logs are on ASM, Oracle GoldenGate (OGG) extract may read them in two ways:
1. in 10.2.0.5 or up in Oracle 10g, or 11.2.0.2 in Oracle 11g, OGG version 11.1 and up extract may read the redo/archived logs from rdbms instance directly using the parameter "TRANLOGOPTIONS DBLOGREADER"
2. for other version combinations, the extract must login to the ASM instance to read the redo/archived logs on ASM.
This note describes for the setup 2., how to troubleshoot the error ORA-15173
i.e..,
2011-04-18 00:49:11 ERROR OGG-00446 Getting attributes for ASM file +REDO/oramcbta/onlinelog/group_3.268.748539783, SQL
ORA-15173: entry 'oramcbta' does not exist in directory '/'
TROUBLESHOOTING STEPS
1. make sure the RDBMS/ASM version and OGG build match each other
2. make sure the OGG extract is logging in to the right ASM instance
e.g. with parameter: TRANLOGOPTIONS ASMUSER sys@ASM, ASMPASSWORD XYZ
To test this, perform these actions:
(1) set the environment the same as the OGG environment
(2) test the login via sqlplus3. after confirming 2., restart OGG manager and restart extract
sqlplus sys@ASM as sysdba
select instance_name from v$instance;
4. if 3. fails, login to ASM instance as described in step 2. and run the following pl/sql
fileType varchar2(4000);
fileName varchar2(4000);
fileSz number;
blkSz number;
hdl number;
plkSz number;
data_buf raw(4096);
begin
fileName := '+REDO/oramcbta/onlinelog/group_3.268.748539783'; --- filename may need to be replaced
dbms_diskgroup.getfileattr(fileName,fileType,fileSz, blkSz);
dbms_diskgroup.open(fileName,'r',fileType,blkSz, hdl,plkSz, fileSz);
dbms_drs.sleep(5); -- sleep for 5 seconds
dbms_diskgroup.close(hdl);
end;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26175573/viewspace-1336876/ ，如需转载，请注明出处，否则将追究法律责任。
