Crash Recovery in Oracle RAC - DBArch Video 16

[@anilreddy7080]

Excellent session which flushes out our confusions on crash recovery .

[@bhupendrasatpathy]

Amazing Mr. Ramkumar Swaminathan. You explain difficult concepts in very simple language. Take a bow :)

[@uzzalbasak2517]

Excellent explanation Sir.

[@Sarbatriks]

You are excellent! Everyone hates the background music, but I liked it actually ! :D

[@jegdeeshcse]

Perfect sir.. got much more clarity..do more videos

[@Squeez210]

Thank you Mr. Swaminathan

[@suryakantamaharana2482]

Thank you so much sir,, your way of teaching z very precise and more clarity . waiting for more videos from you..........

[@RamkumarSwaminathan]

Thanks Suryakanta... Yes... Will be uploading more videos... Stay subscribed... Enjoy the learning...

[@ursypc]

Thank you for the wonderful videos. Could you explain briefly how the crash recovery works in case of RAC Onenode(Active-Passive) setup?

[@nikitadachawar6477]

Nice Video clearing the concept. Avoid background music as its disturbing too.

[@RamkumarSwaminathan]

+Nikita Dachawar thanks for the feedback... Shall take care in future videos... I suppose the bg music is Lloyd on this video... More on RAC will come up soon

[@nikitadachawar6477]

Thanks for understanding... Have you created any video's for Performance tuning?

[@RamkumarSwaminathan]

+Nikita Dachawar yes Oracle Database Performance: kzbin.info/aero/PL3Hc8S1SG2AQBne3XvISEIn3x0NqUBND_

[@GauravSingh-bp8nw]

Because in three tier architecture, when we create instance (compute instance OCI) that is use for the application.

[@kasturibalaji9177]

Its very nice explaination amazing many thanks.

[@RamkumarSwaminathan]

Thanks ... Enjoy learning

[@GauravSingh-bp8nw]

Hi Sir The INSTANCE which have SGA and background...is that the same instance which is in three tier architecture?

[@sribalaje]

Hi Sir, Your videos are ultimate. When checkpoint occurs, I know dbwr will write the dirty buffer to datafile.. so will archive process also writes from redo to archivelog at the same time? Please clarify

[@girishkumar-ic8pp]

please explain in details .how the survive instance will get information about instance is crashed .how did survive instance get which block need to recover.what would be 1st step to in recovery to redo or undo.

[@RamkumarSwaminathan]

Yeah, I shall put another video for that

[@iammiky]

Two things: 1) In which video are you talking about Redo log Threads? 2) Does instances communicate with each other? How instance 1 knows that instance 2 have lock on row/object XXX (because XXX is modified in instance 2 and at the same time another user wants to do changes on the same object on instance 1) ?

[@RamkumarSwaminathan]

Row level locks are maintained in the row header... instances can share blocks with each other using cache fusion.. I shall explain in more detail in another video soon

[@DeepakMehraVlog]

Thanks but you have not mentioned about GRD here. GRD play an important role while crash recovery in RAC

[@RamkumarSwaminathan]

Yes that's right, this is about the base components, GRD (GCS and GES) will be explained in later videos

[@AJ-gb4tw]

Which process or which background process is responsible?

[@RamkumarSwaminathan]

SMON process is responsible for Instance Recovery...

[@santoshjaiswal9717]

Sir here Threads means Groups?

[@Shunrai4]

Hello Santo, I am a bit late with the response but for people asking this question in the future as well, threads are typically used in Oracle Real Application Clusters (RAC) environments, where each instance has its own set of redo logs. A thread can have multiple redo log groups associated with it. So, a thread is the collection of redo logs used by one instance in a multi-instance (RAC) environment.

[@princecharming3536]

wow, nice graphics

[@RamkumarSwaminathan]

Thanks... Enjoy learning...

[@Nikhil20m]

Thanks much!

[@muhammadnagah3564]

thank you

[@rkoul94]

Please dont add extra music as it avoids concentration

[@RamkumarSwaminathan]

Thanks, noted.. taken care in current videos...

[@SaurabhRelia]

Respects

[@tiffocherubin9685]

background music no needed. very very anoying

[@RamkumarSwaminathan]

POint noted...am taking care of this in new videos... Thanks for your feedback...