Redo Logs in an Oracle Database - DBArch Video 11

This video explains the concepts of Redo Log Groups and Files in an Oracle Database.
You will understand how Oracle Instance uses Redo Buffers and Logwriter to keep the redo in Redo Logs.
Our Upcoming Online Course Schedule is available in the url below
docs.google.com/spreadsheets/...
Reach us at [e-mail]

[@bantasingh1470]

Best Lectures ever on Oracle Architecture. Your videos are very helpful. Thanks for sharing for free on youtube.

[@vikram1780]

So far best lecture i never saw in tech industry

[@lovettembenga3670]

I want to say thank you Sir, but I don't know if I could ever thank you enough for the language you give to people including me especially. Am an Oracle student but whatever I don't understand in class your lecture quickly breaks it down for me to understand quicker than I thought. This is the best thing to give to the society and it's for free. Thank you so very much Sir, I am grateful for the language and your good heart, many God give you long life and bless you in abundance.

[@RamkumarSwaminathan]

Thanks.. Enjoy Learning

[@rohitdheemate5863]

Thankyou so much sir I had watch few other youtuber video but didn't understood it so well...
it was very easy for me to understand each and every concept.
Once again wholehearted thanks... 🙂🙏

[@kansanpark5767]

Thank you sir, it helped a lot to understand. Many Thanks from Korea

[@bhaskarmylavarapu8965]

you are the best Sir interms of concepts and the way you teach.

[@pavanb3198]

Hi Sir , Thank you for all your valuable time & energy for making the videos on the oracle Dba and sharing the knowlede.
Request:Please make a video on Multitenant Architecture in 12c .

[@kimkristoferhernandez4460]

big thanks here from the Philippines

[@bwjj8122]

thank you sir.... you cleared a lot of my doubts in oracle!

[@taherjaweed]

Such an amazing teacher. Thanks

[@knagaraju2267]

They way of explanation is very good sir. Thank you for sharing in CZcams.

[@user-by6sq8kg4e]

your voice is so clear sir //good understanding

[@jordanscarrott3749]

I like the intro music. Thank you for the video

[@avradeepdutta767]

Thank you Sir for the help. These videos are awesome and super-useful.

[@sribalaje]

Excellent 👍 I have a query . During alter database open resetlogs, what i understood is all redo logs gets flushed & assigned with new sequence no. But in many articles, i saw redologs gets written to archived logs.. can't understand why redo has to write it to archive logs when resetting logs for incomplete recovery. please clarify

[@franksmj4u]

You are a genius sir... Great

[@manzoor5554]

Excellent work ...done....

[@Saikiran-yj2mt]

sir, thanks for the video and the explanation is good. In the video you have mentioned for every database needs to maintain more than 2 redo log groups and for each group it should have minimum 2 redo log members for log switch purpose.
my doubt is how many redo log groups and redo log members are supported by the database?

[@DoYouDJ]

Thanks for uploading this, I currently have a system that pulls up a menu the main menu in GUI the next time you enter that menu it is completely different an old reverted menu. Obviously the issue is the first group keeps failing and switching to second group. Thinking that may be turning inactive due to misprogramming
on start as we had this happen when an archive was used to update our system and broke it.

[@jyotidevi3775]

Very nice session and informative

[@tirupatiy6735]

Nice Sir..Thank you

[@blugrainteam2470]

sir, we dont need background music, its distracts focus listening u. just an advice...

[@akhulsasikumar8275]

thank you sir for tis amazing class

[@pranavdeshmukh9987]

Thank you sir..

[@SunindraSeepana]

Thanks for well explanation sir

[@syedamunawarfatima6989]

Sir you have provided the satisfiable explanation.....

[@RamkumarSwaminathan]

Thanks... Enjoy learning

[@idunexist]

Great video! Thanks a lot!

[@RamkumarSwaminathan]

Thanks

[@kareemsharawi4778]

Thanks for a very clear explanation.

[@RamkumarSwaminathan]

Thanks.. Enjoy learning

[@good123g]

You are my Dronacharya

[@farheenmaheen]

excellent simple in less time we can review such important basics

[@RamkumarSwaminathan]

Thanks. Enjoy learning

[@techscience138]

Nice

[@mahmudurkhan5754]

great video sir

[@AD-pe8mo]

Great.....

[@elmoukhantaryassine9360]

what is the difference between commit && alter system checkpoint && alter system switch logfile on logfiles

[@nicholusnatweta2942]

every helpful thanks

[@bhaskarmylavarapu8965]

Hi Ramkumar Sir,are you still taking classes for Oracle Databse?please let me know how to contact you

[@GauravSingh-bp8nw]

Thank you sir

[@rajasekharbellapu1491]

youre awesome in explanation sir

[@RamkumarSwaminathan]

Thanks... Enjoy learning

[@BabitaSingh-rn4ol]

Awesome please make more videos

[@jamshedkhan8677]

great sir..salute to you

[@RamkumarSwaminathan]

Thanks... Enjoy Learning

[@StasClick]

Hi. Is that groups and members are persistent? Could members be on different machines? If it is only in memory, for me members looks like duplication of data that won't lead to optimization.

[@RamkumarSwaminathan]

Members are physical files for Redo log Groups. They are present on the same computer, just to take care of Fault Tolerance of Disk failures. Typically before Storage arrays were in vogue, each member was placed on a separate disk, so that even if you have a disk failure you can get back all data committed in your database.

[@muhammadal-abdulla4235]

thank you

[@hamednaser497]

thanks for your explanation

[@RamkumarSwaminathan]

Enjoy learning

[@mezbahalamgir7655]

nice presentation. However background music could have been in lower volume.

[@balwantc]

Excellent

[@RamkumarSwaminathan]

Thanks... Enjoy learning...

[@mohan26622]

Hi Sir, GREAT EXPLANATIONS - LEARNING THE CLEAR THINGS THROUGH YOUR VIDEOS - KEEP GOING SIR.
I need some clarifications,
1) You told that in the last video. when commit issued the lgwr responds and writes to redolog files. then how dbwr works?, automatically or it works for the same commit statement.
2)Keeping the database in archive log able to recover the database. In real-time, the database in which condition, archivelog or noarchivelog, if it is in noarchivelog then why they are using in noarchivelog - any reason to keep this in that state.
Thankyou.

[@RamkumarSwaminathan]

HI Mohan, Look into the playlist on Backup and recovery to know more about Archive Log and NOArchive log... If you have a need that you cannot afford to lose data... then Archivelog is your configuration...

[@RamkumarSwaminathan]

DBWR writes at its own frequency on conditions such as free buffers in buffer cache, checkpointing etc...

[@mohan26622]

Ramkumar Swaminathan thankyou for your response sir.

[@palanivelu.a]

How to clear the log buffer?

[@gangadhar0906]

nice explanation sir

[@RamkumarSwaminathan]

+Gangadhar Wanjari thanks

[@vrushalijwalesh1901]

Hi Sir, Could you please give exact reason why LGWR writes before DBWR? Thank you very much in advance.

[@prashantpujari466]

If log buffer is full to accommodate new blocks

[@amiyarout1944]

How can you say redo logs improve the performance as compared to DBWR, when it is a part of the transaction....what I meant is you cannot avoid writing to data files or avoid writing to redo files. Both activities are part of the transaction. You can say that writing redo entries to the redo files takes less time as compared to write the dirty buffers to the data files. Please clarify..

[@RamkumarSwaminathan]

When a commit occurs, only lgwr wires to redo logs... Dbwr did not necessarily write... A commit is complete after the redo is written...

[@kbayapureddy7932]

Sir tell your institution. I will join

[@guruyadav9220]

Excellent sir could you please explain sir how to add More group

[@RamkumarSwaminathan]

you use the alter database command to do the same..

[@SaurabhRelia]

respects

[@aasutossh]

What is up with the distracting background music in the video?
Otherwise good video.
Do not add music to these videos.

[@jimbasler9460]

I like his explanation but the constant music is DISTRACTING

[@SunindraSeepana]

Sir don't think bad please remove the Bg sir

[@knandi73]

Please remove the background music. I disturbs the concenration......