If standby db loses or deleted its password file it will impact the shipping of archived to standby from prod . Solution is to copy the password file from prod to standby.
@umeshdhote1917
4 жыл бұрын
Ya ,Junaid you are right...I also faced same problem 👍
@mahendrashiromani6062
3 жыл бұрын
When password file deleted , RFC will stop
@good123g
2 жыл бұрын
ship will stop
@ravinbharathmaharaj9269
4 жыл бұрын
Regarding the password file in dataguard. It is not only required during the duplication process but the 'fal_server' parameter requires it to connect to the primary db. FYI : When MRP finds that an archive log is missing during media recovery, it sends the fal_client information to the server identified by fal_server and requests fal_server to resend the file again.
@samaraviteja
4 жыл бұрын
Most Awaited topic SQL profile 👍🏻
@kuchbhikaho2121
3 жыл бұрын
I am so addicted to all of your videos, specially in my mind I am happy with some of the concepts are so correct and same as you are explaining and at the same time few of the areas I am correcting as you are giving more and correct clarity. Thanks Arun for so calm, composed, confident in explaining all these DBA related areas.
@abdultaheriqbal1117
4 жыл бұрын
very good explanation about SQL Profile .... Thanks Sir
@swapnilkathar9001
4 жыл бұрын
Yes we have seen that there is gap in log shipping due to the password file corruption on standby database.
@venkatwgl856
4 жыл бұрын
Heartly thanks for Kindle books.. it's asome....
@vidmayur
4 жыл бұрын
Thanks Arun for picking the bonus appreciated
@asifsoft7861
4 жыл бұрын
Yes, we create bcp the way you explained using rman clone i.e connecting to source db rman and auxiliary instance and yes if password file is lost or not same on both the sides , bcp will be out of sync.
@ashaganesan4090
3 жыл бұрын
Arun bro.. I have cleared a technical interview today one and only because of you.. by learning from your videos.. I am so grateful to you..
@dbagenesis
3 жыл бұрын
Keep it up Asha, I love when our DBA community grows.. Congratulations! 🎉
@ashaganesan4090
3 жыл бұрын
@@dbagenesis Thank you very much 😊
@bharathkumar-ds8cd
4 жыл бұрын
Nice explanation arun
@nishanthajay
4 жыл бұрын
Hi Arun, We have seen password corruption in standby causing problem in log shipping from primary. Dest basically gets errors out stating Oracle not available (if done defer/enable)
@Nirala1969
4 жыл бұрын
Exactly Junaid Jamal...I face this issue...my syncing process stops...I need to copy the password file from Production to Standby..it started syncing.
@saisruthi9609
4 жыл бұрын
Thanks arun
@matheenahamed2692
4 жыл бұрын
ORA-02019: connection description for remote database not found in Oracle. What could be the issue?
@dbagenesis
4 жыл бұрын
Check tns entries.
@SANDATA764
4 жыл бұрын
Thank you.
@9890691169
4 жыл бұрын
Hello Arun, Can you pls tell what is a base line?
@mohitjain2192
2 жыл бұрын
Shipping of archivelogs won't happen and sync will be impacted in case password file is not there.
@Praveen7792
4 жыл бұрын
@Arun - You told deleting password file wont impact sync But what if the SYS password on primary is changed and we don't change it on standby ? - Will it impact sync ?
@dbagenesis
4 жыл бұрын
I was confirming it with other experienced DBA as I was not sure about it. Its mandatory to have it, simple.
@chakradharsasanapuri7328
4 жыл бұрын
If we change sys password at primary n not copy, it breaks replication break
@himanigrover2581
3 жыл бұрын
It regarding the sql profile. When the user will change the sql and add another condition in where clause, it will change the sql_id of that sql and the sql profile earlier created on a different sql if will simply not work. Isn’t it?
@chetan19891
3 жыл бұрын
the scenario related to RMAN catalog upgrade .. I researched on it but didn't find the solution. Could you please provide correct scenario.. some error code will help to narrow down the research.. most common solutions I got was to run upgrade catalog and make sure that version of RMAN client and catalog schema is compatible.
@mayureshshinde7059
3 жыл бұрын
U were just blabbering on the sql profile part rather than coming straight to answer. And you didn't even answer it correctly. I could see 2-3 pauses on that part maybe u were googling the answer.
@dbagenesis
3 жыл бұрын
yahoo not google 😂
@techlearner2447
2 жыл бұрын
You are right Mayuresh.... I think if there is change in WHERE clause then the SQL stmt is also changed and it will be treated as a new query by Oracle engine, then there is no point to follow the old SQL query profile. Secondly its the most common scenario, if you change the password file in Standby DB log file shipping stops and Primary will not be in sync with Standby. Third if someone ask query is running slow, don't point towards application team without analyzing anything. Here person wants to know what all should be analyzed to find root cause. Sorry to say Arun.. Your technical round is not cleared.
@Zaid_Alam
Жыл бұрын
@@techlearner2447 technical round not clear 😂😂😂
@Mrpro119
4 жыл бұрын
Nice presentation ......
@saisruthi9609
4 жыл бұрын
Please explain partitions
@scooby990
3 жыл бұрын
Is there a licensing limit to the number of pdb's for a cdb or number of cdb's?
@viralmody6316
3 жыл бұрын
Is it possible to force an old execution plan for an SQL to be used by the optimizer incase the old plan performed better than current execution plan ?
@intakhabalam8252
2 жыл бұрын
Yes...use SQL profile
@RameshKumar-dy2ez
4 жыл бұрын
Hi Arun, I have a question ,can we run tunning advisor in standby db ,,, as we have few jobs running on standby db as well..
@dbagenesis
4 жыл бұрын
Yes, you can run it. This is called as remote sql tuning. Read about it .. You will have to use database_link_to parameter
@pradeepvijayaraghavan7323
3 жыл бұрын
Hi , i have seen your video and feel like you are too aggressive about your words (especially i felt when you said others that they dont know 100%). Always pointing others that they do not know anything. Nobody in this world knows everything including me. You dont know anything what I know and vice versa. so the choice of words is important brother when you are teaching something.
@himanshugarg4846
4 жыл бұрын
Hi arun What do u mean by additional statistics inside the SQL Profiles what are that statistics.?
@dbagenesis
4 жыл бұрын
Why not you research same and respond to this comment?
@himanshugarg4846
4 жыл бұрын
@@dbagenesis I have already check but did not get any specific answer.
Пікірлер: 46