The best part of playing poker is misreading the hand and won.
Well, today this applied to help troubleshoot a Goldengate issue.
Granted it might not be the root cause but it did solve the issue for the time being.
1. Goldengate version 10.4
2. mgr process started with uid vs username
$ id -a
uid=19208(ggsuser) gid=1601(dba) groups=1601(dba)
$ ps -ef|grep ./mgr
19208 18576 1 0 16:05 ? 00:00:00 ./mgr
3. dirdat is (more...)
I did not know this.
Is there a way to control Auto_Purge Frequency done by the MMON ? (Doc ID 1446242.1)
The automatic purge cycle is designed as follows.
(1) The first actual purge action will be 2 days after instance startup time
(2) The next automatic purge actions following this first purge is done once every 7 days
If you like to purge more often, then it will need to be done manually.
$ egrep -n '^Corrupt block relative dba| ^Reread of blocknum' alert.log| tail -50
124974:Corrupt block relative dba: 0x04c7d3be (file 12, block 312452)
124983:Reread of blocknum=312452, file=+DATA/db/datafile/db_data03.329.456465464. found valid data
124974|124983 are line number from alert.log
On reread found valid data, there is no need to proceed further since block has been validated to be . Typically, this occurs when there is a fractured block.
If you have doubts:
RMAN> backup validate check (more...)
My portfolio increased $10,000 today. Original investment is $1,000,000.
I made 50% on my investment today. Original investment is $200.
There is more to than meets the eye.
It has been quite a while since I have used Exception table and just a quick demo to share.
$ sqlplus demo/demo @exception_demo.sql
SQL*Plus: Release 22.214.171.124.0 Production on Tue Mar 7 16:36:33 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production
With the Partitioning and Real Application Testing options
ARROW1:(DEMO@HAWKA):PRIMARY> col OWNER for (more...)
This probably applies to other versions as well.
Don’t you love it when there’s a simple solution?
Oracle GoldenGate Command Interpreter for Oracle
Version 188.8.131.52.170221 OGGCORE_184.108.40.206.0OGGBP_PLATFORMS_170123.1033_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jan 23 2017 21:54:15
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.
GGSCI (test1) 1> create subdirs
Creating subdirectories (more...)
It looks like I have encountered BUG which applies to any platform but Oracle only has patch for Solaris Sparc.
Anyone working for Oracle able to assist here please?
ADD SCHEMATRANDATA Throws OGG-01780 Missing/Invalid argument(s) on ADD/INFO/DELETE SCHEMATRANDATA command. (Doc ID 2188988.1)
Oracle GoldenGate – Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Patch 24601324: Patch FOR MLR 24590215: Solaris Sparc: Oracle12c: OGG 18.104.22.168. (more...)
Creating Additional Data Dictionary Structures
catoctk.sql: Oracle Cryptographic Toolkit package
owminst.plb: Workspace Manager
Workspace Manager is installed by default in the seed database and in all databases created by the Database Configuration Assistant (DBCA).
However, in all other Oracle databases, such as those you create with a customized procedure, you must install Workspace Manager before you can use its features.
I know what you are thinking, “What’s the BIG deal?”. For the most part, (more...)
Please take a look at my notes below:
DataPump: Schema/DB Migration Notes