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
Смотрите видео How to Add Diskgroup in ASM | онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь DBA Genesis 07 Январь 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 15,124 раз и оно понравилось 315 людям.