Oracle Dataguard Database Asynchronous Processing Memo

I haven't got up yet, the damn phone is ringing. A nervous message:dataguard database Master never synchronized, quickly climbed up to work.

first step, check the alarm log Log.xml . Keep your eyes wide open and look for the abnormal output, and then filter it with grep -type tools. It seems that the situation is still good ah, if there is an error category, the problem is very big.

Next, check the serial numbers on both sides of the main preparation, and find that the archived serial numbers are identical.

650) this.width=650; "title=" dataguard01.jpg "src=" http://s1.51cto.com/wyfs02/M02/84/61/ Wkiol1epgthblouuaactewraqio175.jpg-wh_500x0-wm_3-wmp_4-s_2857888825.jpg "alt=" Wkiol1epgthblouuaactewraqio175.jpg-wh_50 "/>

as a result, the archived logs continue to be transferred, and no archived data has been lost. To ensure that in case the standby is executed again sql> Select name,sequence#,applied fromv$archived_log order by sequence#; The output is truncated as follows:

650) this.width=650; "title=" dataguard02.jpg "src=" http://s5.51cto.com/wyfs02/M02/84/61/ Wkiom1epgxmgbu59aabvuzt5k-0738.jpg-wh_500x0-wm_3-wmp_4-s_1939112925.jpg "alt=" Wkiom1epgxmgbu59aabvuzt5k-0738.jpg-wh_50 "/>

Check the directory to see if these archive logs are there, lucky, really. ! Also check the main library, the serial number is also in keeping with the library pair. Now you can be sure that standby did not apply the log, go back to see the process MRP is not running,PS aux|grep MRP , Hey, no! Well, let's do it. The specific instructions are:

sql> alterdatabase Recover managed standby database using current logfile disconnect;

When execution is complete, we can compare and understand what happened.

650) this.width=650; "title=" dataguard03.jpg "src=" http://s4.51cto.com/wyfs02/M02/84/61/ Wkiom1epgipixn4haahtfpuqjag843.jpg-wh_500x0-wm_3-wmp_4-s_1631931786.jpg "alt=" Wkiom1epgipixn4haahtfpuqjag843.jpg-wh_50 "/>

Next, open the alarm log to see the changes in the archive application. Contact other people at the same time to check whether the data is increasing gradually.

This article is from the "Sery" blog, make sure to keep this source http://sery.blog.51cto.com/10037/1828066

Oracle Dataguard Database Asynchronous Processing Memo