Home » Server Options » Replication » Problem using goldengate to extract data from ASM - 10G (10.2.0.4, Linux)
Problem using goldengate to extract data from ASM - 10G [message #494759] Thu, 17 February 2011 00:03 Go to next message
guyj
Messages: 31
Registered: September 2005
Member
Hi All,

We are getting following error when we are trying to extract data from ASM.

GGS ERROR 500 Oracle GoldenGate Capture for Oracle, ext_1.prm: Getting attributes for ASM file +DATA/testgg/onlinelog/group_1.257.742844671, SQL <BEGIN dbms_diskgroup.getfileattr('+DATA/testgg/onlinelog/group_1.257.742844671', :filetype, :filesize, :lblksize); END;>: (6550) ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_DISKGROUP.GETFILEATTR' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignoredNot able to establish initial position for begin time 2011-02-16 16:42:05.

Please tell us how to overcome this. Database version is 10.2.0.4.

Thanks.
Re: Problem using goldengate to extract data from ASM - 10G [message #512349 is a reply to message #494759] Sun, 19 June 2011 10:34 Go to previous message
ravinalakonda
Messages: 1
Registered: June 2011
Location: United States
Junior Member
HI,

I have got the same issue recently. Could you please let me know, how you solved it.
ASAP


2011-06-19 02:08:07 ERROR OGG-01028 Preparing statement getting attributes for ASM file +ARCH_orcl9/orcl9/archivelog/2011_06_16/thread_1_seq_1226.440.75
3963691, SQL <BEGIN dbms_diskgroup.getfileattr('+ARCH_orcl9/orcl9/archivelog/2011_06_16/thread_1_seq_1226.440.753963691', :filetype, :filesize, :lblksize);
END;>:

[Updated on: Sun, 19 June 2011 11:01]

Report message to a moderator

Previous Topic: backup_problem_with_replication
Next Topic: Can we use Materialize views in Streams (merged)
Goto Forum:
  


Current Time: Sun Oct 25 12:05:41 CDT 2020