Why Standby Redo Logs is Required in Oracle Data Guard?
This article will help one understand why a standby redo log is required in an oracle data guard and what will happen if we don’t use a standby redo log in an oracle data guard. Our discussion will give you a clear idea of how to redo the transfer from the oracle Primary database to the standby database as well as it will assist you in troubleshooting real-time log apply as well as the log transfer issues.
a) Now we are going to briefly describe how to redo transport work when Standby Redo Log doesn’t use in the oracle data guard database.
Step 1: A transaction writes the redo record into the buffer log in the System Global Area (SGA)
Step 2: The Log Writer Process (LGWR) writes the undo record from Buffer Log to the Online Redo Log
Step 3: When the Online Redo Log fills up or manually issue log switch command Online Redo Log switch to the next log sequence, and the Archive Process (ARC0) will copy the online redo log to the Archive Redo Log.
Step 4: As standby database exists, another archive process (ARC1) will read the complete Archive log and transfer the redo over the network to the Remote File Server (RFS) process, RFS process is running in Standby Database Instance.
Step 5: The RFS process sends the redo stream to the local archive process (ARCn)
Step 6: The Archive process (ARCn) will write the redo into the Archived Redo Log location on the standby server
Step 7: Once the archive redo log is completed, the Management Recovery Process (MRP0) sends the redo to the standby database instance for applying the transaction.
b) Here, we would like to explain briefly another scenario if we use standby redo log in oracle data guard database.
Post a Comment
3 Comments
Thank you for sharing useful information with us. please keep sharing like this. And if you are searching a unique and Top University in India, Colleges discovery platform, which connects students or working professionals with Universities/colleges, at the same time offering information about colleges, courses, entrance exam details, admission notifications, scholarships, and all related topics. Please visit below links:
ReplyDeleteBCA Career & Future Opportunities
Top MBA Colleges in India
Top 10 BBA Colleges in India
Advantages of Pursuing BBA
Career Opportunities and Jobs after BBA
25% OFF on Oracle Apps R12 Financials Self Paced Course along with 11 Additional Add On Courses (321 Session Videos of 120 Hours Recordings). Our Top Trending Course with 1700 Enrolled Udemy Students
ReplyDeletePlease Check https://www.oracleappstechnical.com for details
Sitting at roulette tables for long 토토사이트 periods does take its toll on a checkbook, so it might be sensible to discover a desk with a low minimum wager. Additionally, most tables have a most wager designation, so make sure this number is large enough for the amount you want to begin with to be equitable in {the long term|the long run}. The Roulette wheel consists of numbers 1 via 36, alternately colored purple and black, plus 0 and 00, which are colored green, for a complete of 38 possible profitable numbers.
ReplyDelete