YTread Logo
YTread Logo

Oracle DBA - Dataguard Realtime

Jul 09, 2022
hi, in this video i am trying to test something that is very important for data god set i.e how to reduce send, redo content send and archive log send that happens in data god set is what I'm trying to test in this video and the most important concept for us to understand here with this video is what are the background processes involved in sending the radio content from the primary to the standby, similar to the sending an archive log file from the primary to the standby whenever there is a delay or gap in the archive log between the primary and the standby and also along with this I will also try to test if the archive logs are sent from primary or not is what I'm going to test in this video to demonstrate that I have enabled monitoring of my network from my main server database if you can see on this screen in my putty session that it is already started a network monitor on my main server if you want to let you know what these naming conventions are or L is the host name of the main db server and il standby is the name of my standby db server, so as you can see the arrow markings like this it means the packets being transferred from the main to the standby is what this arrow marking says so if you see the amount of data being transferred every second because this it will keep updating every two seconds and you will see the contents basically being transferred from your main to your standby and vice versa if you want to see the contents being sent from both of your main standbys That's why you can see an arrow mark like this in reverse order .
oracle dba   dataguard realtime
You'll see that the content or the amount of data being streamed from the primary, sorry, standby, to the primary is what you can see in the second row, basically it won't be on anymore. one byte or one kilobyte at most, that's why you can see that there will always be less than one kilobyte from standby to primary because most of the redo contents are the contents that get transferred from primary to standby, it's for that the traffic will always flow from primary to standby that's why you can see here that the content of the traffic is always in kilobytes so this is my primary database server where the file log sequence number currently it's 146 and this is my standby database and the current file log sequence generated and applied is 146 so let me just test if my two databases are in sync or not.
oracle dba   dataguard realtime

More Interesting Facts About,

oracle dba dataguard realtime...

There are many other methods to check but I'll just do a log file change and check if they're in sync if a 47 is applied here that means it's in sync so I'll do a very simple test like this to check if both databases they are in sync or not and they are in sync right now so first of all when the databases are in sync that means the redo contents are sent from your main db server to the standby db server to identify what is the background process that is doing this let me test now but before that I heard many DBS say that the Rideau content of the primary is actually sent to standby by the background process log writer plane or LNS background process or any other background process, but I'll get back to you shortly or you'll know. the answer what is the background process that actually sends the redo contents from the primary to the standby as long as the primary and the standby are in sync in the first place so let me show you before that in my network redo transport or any packet transferring from primary to standby let me identify the port number my primary is the standby on and what is the primary port number then this is the port number which is used over tcp/ip protocol to transfer the content from your primary database server to the standby database server now what we do is identify who is using this particular protein number so i'll just use so i'll just use LS of: first this 9 double 3 8 now you c and understand a background process with PID named two four nine one running as


user is using this protocol port number olo tcp/ip nine double three eight now let's identify what is the background process that does this job so the PID of it is two four nine one now this answers your question so what is the background process of your database that sends the radio content from your main database server to the standby database server?
oracle dba   dataguard realtime
The Oracle docs say that the job of the NSA background process responsibility is to send the content of the radio from the primary database server to the backup server every time it configures an asynchronous mode of configuration protection. of data, so I've tested it literally from network monitoring, which is the bagging process. is it responsible for sending the content from parent to standby or this will also help you understand now what is the background process that does this job. It's not a log writer, it's not an LNS, it's an SI. Now, let's also try to test if there is a gap in the redo log from the primary to the backup, which is the background process that will push the content from the primary to the backup. is the next thing i'm going to try now let me generate a space in the file log to generate a space in the file log i will actually be diffing the second destination of the file log so the state of the second destination of the log From file I will make it as defer to enable, so the current state of the second node is enabled.
oracle dba   dataguard realtime
Let me make it different. Altering the whole of the system is equal to differing. Once I defer the second node or the second state, the second destination state of the file record. i will keep doing this so i have to get too many spaces in the file log from node 1 to node 2 sorry primary to standby now if you check the current file log sequence number of the primary is 184 now just the last check last The file log sequence number received in standby is only 148, which means that there are about 36 file log gaps from primary to standby, so all of these log resolutions File logging breaches should be done automatically by your data protection settings as soon as you make the second file logging target state to enable, but what are we trying to test which background process will be responsible for resolving? this gap from primary to standby is what we're going to test but along with that let me show you something interesting again part as soon as we've set the second destination as deferred, you can see that there is no network traffic between your main database and the standby database, there is no other database server with the name oal -standby that is not in your network traffic, so you can understand one more thing: if you just make the second file log destination defer your recovery process, even though it's ru If it's in standby mode, it doesn't make any difference to your network protection. data, it's a post, so you can say that if you make the second destination of the file log lazy, the whole data protection setup stops, that's the next test you'll get automatically. from this network monitoring and you can see on the screen now let me enable this second file log destination but first I'll have another session open to identify what is the background process responsible for sending my file log from my database main side data to standby db id for that let me generate another session let me open another session on my main db side so have my third session on my main db side ready with command LS just to give the port number whatever port number you were using on the network because here's a concept as soon as the file logs are fully sent from your main server to standby again the port number will be occupied by your NSA backgro and process, so I have kept this third session ready for us to see quickly after enabling this redo log archive log second destination after to enable it we need to quickly see what is the background process sending or doing something activity of sending the contents from parent to standby that is the reason I have kept this ready now let me do or set the value of the parameter to enable on my primary database site the second file log destination.
I mean now I'm running this command but as soon as I'm running this command just keep an eye on this particular network traffic stream that's here as soon as I start this but along with that I also need to identify what is the background process that sends content from its main and on standby. quickly so I'm just hitting return here and real smart here so 9 6 2 4 Jessie 9 6 2 4 and 9 6 2 5 too sorry it's gone so I gave the wrong 34 instead of 24 that was the reason it was n I can't get the background process it still shows NSA because it completed sending all 34 file records in a fraction of a second so I need to be a bit quick again to catch the process I get I refer to the port number and verify what it is. the background process using that port number again so let me do it for you now if you see that in standby mode all file logs are sent so it was very fast in a fraction of a second all logs are sent file logs but I can't I couldn't identify due to the wrong number I've given which background process has done this but I'll try it now again to show that again I'm creating a file log gap between primary and standby by deferring the second target and i'll enable it again and redo this now I've generated too much gap and now it's 250 or the main sequence number in your support a main database and here it is 186 almost 50 over 60 about 60 file records should be transferred from your main to standby so now let me again let's enable the parameter value and it should be pretty quick to grab the port number from here and then check what's the detail from here so let me be ready with that port number yes I'm ready with that and as soon as you enable here I have to capture the port number that you are using at the moment and I have to capture at least the OS level process ID that's using my port number so let me be quick there before that let me enable this and then capture it 9 6 7 2 is the 1 and 7 3 is the 1 and 7 7 is correct I have a process ID now 7 7 who was doing it so let us see what is the bad process doing this?
We have now identified which background process was actually sending the file logs from the primary to the standby and if you see correctly redo logs are always sent from the primary to the standby this is always the one that is also the third one that i wanted to prove from this video that archive logs are always pushed from your main side to standby, which means that the archive process on the main database side will actually push the log file from redo sorry push archive log files from your primary side to standby this is the third test i have i can get from this exercise so what we have demonstrated in this video first thing ?
Wherever your main database and your standby database are in sync, the background process called NSA is doing the redo transport and every time there is a file record. breach of your main database, understand by database that the resolution of the breach is done automatically by your arc process on your main database server thanks for listening to this video see you again with interesting concepts like this again yes you have any queries you can reach me on the various communication methods you have on the screen you can text or whatsapp me call me on number or email me at I will also be happy to serve you when I am free thank you once again have a nice day bye

If you have any copyright issue, please Contact