Oracle GoldenGate monitoring tool: ggserr. log error logs cannot be ignored

After the Oracle manufacturer recently installed the monitoring plug-in for OEM 12C in the primary database in the production environment, an exception occurred to the Oracle GoldenGate instance that has been synchronized to more than a dozen external databases, frantically Go To The ggserr in the GoldenGate root directory. the following error log is entered:

22:33:26 WARNING OGG-01930 Oracle GoldenGate Capture for Oracle, pcqstqz1.prm: Datastore error in 'dirbdb': BDB0060 PANIC: fatal region error detected; run recovery.
22:33:26 WARNING OGG-01930 Oracle GoldenGate Capture for Oracle, pzj_cx9.prm: Datastore error in 'dirbdb': BDB0060 PANIC: fatal region error detected; run recovery.
22:33:26 WARNING OGG-01930 Oracle GoldenGate Capture for Oracle, pzj_cx9.prm: Datastore error in 'dirbdb': BDB0060 PANIC: fatal region error detected; run recovery.
22:33:26 WARNING OGG-01930 Oracle GoldenGate Capture for Oracle, pzj_cx9.prm: Datastore error in 'dirbdb': BDB0060 PANIC: fatal region error detected; run recovery.
22:33:26 WARNING OGG-01930 Oracle GoldenGate Capture for Oracle, pcqstqz1.prm: Datastore error in 'dirbdb': BDB0060 PANIC: fatal region error detected; run recovery.

For those of me who have been in touch with GoldenGate in the real sense, they are scared. The 500G/goldengate VG will be attacked in less than a few days.
1-200 GB ggserr. log logs support almost. This file finally began to enter my field of view.

Ggserr. log is very important for GoldenGate monitoring, but we seldom pay attention to it. Oracle engineers will check this when they come.
You can use the Oracle GoldenGate error log to view many important information, such:
History of GGSCI commands
Stop and start the Oracle GoldGate Process
Processed information
Error
Some useful INFO and WARNING information

Because the ggserr. log error log displays events in the order of occurrence, it is a good choice when locating the cause of the error.
Tool. For example, you want to locate the problem:
Time point at which a process is stopped
A process cannot communicate with TCP/IP or establish a database connection.
A process cannot open a file

There are many ways to view the ggserr. log error log:
1. Use standard shell commands to view ggserr. log in the Oracle GoldenGate root directory
2. Use the Oracle GoldenGate ctor monitoring tool to view
3. view ggsevt in GGSCI

The syntax of the view ggsevt command is view ggsevt.

Many times, the error log of ggserr. log is very large. If you use tail-f ggserr. log, you will feel
How frequently the logs are played, just as I hit more than 200 GB in recent days, waiting for Oracle to solve the problem ....
In fact, we can use shell commands to filter ggserr. log logs. For example, only the error message is displayed:

More ggserr. log | grep ERROR

With the use of Oracle GoldenGate in a single day, error logs will continue to grow. We need to regularly archive and back up and clean up the logs,

Just like alert log in Oracle Database.

The following describes how to clean GoldenGate ggserr. log:

Cat/dev/null> ggserr. log

Or

> Ggserr. log

Do not delete the file. Make sure to back up the file before cleaning it.

Note: On Unix systems, After logs are cleared, the Collector process may stop reporting log information. To start reporting log information again,

Restart the Collector process after cleaning (restart the mgr process ).

Reprinted please indicate the author's source and original link: http://blog.csdn.net/xiangsir/article/details/8640241