Basic ElementsRecent user feedback was deployed inRacnode1of theOGGThe crawl process has stopped running for several days, hoping to troubleshoot the cause, let it return to normal. Problem Analysis
Step One: View the logthroughInfo Allcommand to view the status of the current fetch process, as below, the status isabended, then our simplest way is to look atOGGthe error log information for the file namedGgserr.log,let's look at the relevant error message in the error log, as follows:
reported hereOGG-01028error, you can see the prompt is not clear, can't find/u01/app/oracle/archive2/2_32522_828663513.dbfArchive The logs because we're hereRacenvironment, usingNfsthe way that put2mount the archive directory of the number node to1number Node's/u01/app/oracle/archive2/directory, so the path should be2the archive log for the number node. we looked at the directory really didn't because it wasRacnode, we are1node to see the log file in the1This is because the user has been doing a server restart in the last few days becauseVipthe jumps that led to the original should have been archived in2log of the node, archived in the1node, so we just need to copy the log to2number node. resolution Process
Step One: Copy the log
we put in1node, all of which should have been archived to2log of the node, all copied back to2node, withScpcommand remote copy, as follows:[[email protected] archive]$ scp2_32* 192.168.30.3:/u01/app/oracle/archive2_32522_828663513.dbf 100% 10mb 10.0mb/s & nbsp; 00:01 & nbsp & nbsp; 2_32523_828663513.dbf 100% 1024 1.0kb/s 00:00 & nbsp & nbsp; & nbsp; & nbsp; 2_32540_828663513.dbf 100% 51mb 25.4MB/s and nbsp; 00:02 Once the copy is finished, try to start the catch process again and start normally
key points of knowledgeThe drift of the RAC Archive log: In a RAC environment, when a node shuts down unexpectedly, the business on its node is rolled back, resulting in an archived log, but the node is inaccessible, so the archive log generated by the fallback is built on the other node, which is the common archive log drift.
OGG crawl process stopped due to archived log drift (OGG-01028)
