How to Add Diskgroup in ASM |
In this episode of daily DBA, I pick up 6 important #DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!
00:00 Intro
01:50 If we perform a switchover operation in real time. How will we have to manage the connection string for end users? since after switchover standby will act as a primary database. Do we have to modify connection string for all the user at client side? or is there any other thing which is need to be done?
07:45 How to add the disk group in ASM and how to tell the steps in interview ?
10:29 How can I reduce the gap between primary and standby Database?
17:27 What are all the monitoring tools used by DBAs now and before?
21:14 Is there any query to get list of tables that should be reorganized? I have a problem in free space in the FS and I need to reduce the datafiles size?
22:12 We have 2 node RAC setup and when I try to connect via connection string, I get "connection lost" error. When I try to connect again, the connection succeeds. What could be the issue?
Bonus Question
24:58 What is the meaning of “migration” in “Oracle (database) migration”?
Website: https://www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis
Watch video How to Add Diskgroup in ASM | online without registration, duration hours minute second in high quality. This video was added by user DBA Genesis 07 January 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15,124 once and liked it 315 people.