Shulou(Shulou.com)06/01 Report--

The following error occurred in oracle ogg

ERROR OGG-01172 Discard file (/ ogg/oggrm/11.2/dirdat/repa.dsc) exceeded max bytes (2000000000).

ERROR OGG-01668 PROCESS ABENDING.

You can see that the repa.dsc file has reached its maximum. The cause of the error is that the file is full, and in most cases it is an error in table synchronization, which can be seen in the OGG error log.

The solution is as follows:

The maximum value of the 1.repa.dsc file can be set in view params repa if the file is enlarged. The error still exists. When enlarged, the file will still be full. So rename the repa.dsc file directly to repa.dsc_bak. Then create a repa.dsc file.

two。 Find the table that caused the error in the ogg error, for example: sa_org.

Export this table on the main library

Exp user/pwd file=/dir/xxx.dmp tables=sa_org

Delete the table on the standby database and then pour it into the table exported by the main database

Drop table sa_org

Imp user/pwd file=/dir/xxx.dmp full=y

3. Restart the repa service. At this point, the general process will return to normal.

4. If you still enter ABENDING after startup, you can add HANDLECOLLISIONS to view params repa.

Parameter, which causes the repa process to continue to start despite the error. After the data synchronization is complete, turn this parameter off.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.