ERROR: No checkpoint table specified for ADD REPLICAT – Oracle GoldenGate

Posted 4 CommentsPosted in 11gR2, ASM, GoldenGate, HA, Oracle

This is just a quick note for myself to remember and reference for in case someone comes across this error while setting up Oracle GoldenGate. While configuring the online synchronization replication, a default checkpoint table is created.The table’s name is mentioned in file named GLOBALS. GGSCI (anand-lab) 29> EDIT PARAMS ./GLOBALS GGSCHEMA GG_OWNER CHECKPOINTTABLE GG_OWNER.CKPTAB […]

Duplicating a controlfile into ASM when original controlfile is stored on ASM – 11gR2

Posted Leave a commentPosted in 11gR2, ASM, Oracle

Here i will be duplicating the controlfile into ASM when the original controlfile is stored in ASM itself on 11.2.0.1.0 version and the database is up with spfile. Two diskgroups are mounted +DATA and +DATA02.The original controlfile exists in +DATA which we will be duplicating in +DATA02. [[email protected] ~]$ sqlplus / as sysdba SQL*Plus: Release […]

Moving Datafile using ASMCMD "cp" command – 11gR2

Posted 2 CommentsPosted in 11gR2, ASM, Oracle

Few months back i wrote “Moving datafile from one diskgroup to another in ASM – 10.2.0.4” where i used RMAN and DBMS_FILE_TRANSFER methods to move the datafile between the diskgroups. From 11gR1, Oracle introduced “cp” command in asmcmd utility. cp Command Purpose Enables you to copy files between ASM disk groups on local instances to […]