Fixing Corrupted Undo Tablespace | #dailyDBA 33

DBA Genesis Audio Experience

Mar 12, 2020•13 min•Ep. 33

--:--

Listen in podcast apps:

Apple Podcasts

Spotify

Download

Listen to this episode in Metacast mobile app

Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

Episode description

#dbaChallenge: Which cases sql plan hash value will change?

Questions Picked-up For This Episode:

============================

If RMNA backups are residing on different DISK GROUPS then can we restore the rman backup? If yes then is there any specific change is needed in restore syntax?

How to fix when undo tablespace get corrupted?

Is optimizer smart enough to choose between index scan and table scan?

What is the difference between using table_name and schema.table_name in a query?

cdump location is growing faster and filling up entire /data mount point. What to do?

Bonus Question: Must have tools for Oracle DBAs.

#dailyDBA #dbaGenesis

Your comments encourage us to produce quality content, please take a second and say ‘Hi’ in the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;)

Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration

Link to all DBA courses: https://dbagenesis.com/courses

Link to real-time projects: https://dbagenesis.com/p/projects

Link to support articles: https://support.dbagenesis.com

DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!!

DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course.

Facebook: https://www.facebook.com/dbagenesis/

Instagram: https://www.instagram.com/dbagenesis/

Twitter: https://twitter.com/DbaGenesis

Website: https://dbagenesis.com/

Start your DBA Journey Today !!

Become an exclusive DBA Genesis member:

https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join

For the best experience, listen in Metacast app for iOS or Android