I've just inherited management of an oracle 10g database server with a single database running on a windows server and my database experience has been managing MySQL servers and databases on a centos servers, i've come to the conclusion that i need to extend database skills to oracle.
Now i already started composing a list of what of i need to do and i've been looking for online learning materials like udemy and oracle docs what path would other oracle dba's suggest i take to expand my dba skills to oracle.
Currently on my task list i have
- Installing Oracle VSS writer or any oracle add ons
- Tablespace management - increasing size, monitoring tablespace usage, adding additional dbf files
- User management
- Full run down on RMAN as i need to be able to connect to a target, do full hot backups to a local destination, perform a restore of the database to a dummy server as part of disaster preparedness and recovery plan and i urgently need to safely remove obsolete files from the archive log as it keeps growing and running out of physical disk space will soon be an issue.
- How, why and when to use the scheduler