Oracle 11g: Administration II

Course Benefits

Structural elements in Oracle Database 11g’s architecture, including and Automatic Storage Management (ASM), and the steps for managing storage using disk groups
Steps for configuring all aspects of backup and recovery functionality in Oracle Database 11g using ARCHIVELOG mode, retention policies, a Flash Recovery Area, and an RMAN recovery catalog
Steps for preparing a database for backup and for performing various types of RMAN backups and monitoring them using reports and dynamic performance views
Steps for performing user-managed backups and recoveriesSteps for performing user-managed backups and recoveries
Ways to use RMAN to ensure that data is not lost in Oracle Database 11g by performing complete and incomplete recoveries as well as disaster recoveries, by cloning databases, and by restoring a tablespace to a particular point in time
Steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks and for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11g’s flashback features
Steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and for enabling and configuring automatic memory management and automatic shared memory management
Steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces
Ways to ensure that resources are being put to best use and database jobs are performed when they should be using the Database Resource Manager and the Scheduler
Steps for utilizing Oracle Database 11g’s globalization support features to ensure that information and data is displayed in a user’s native language and that territory and language-dependent conventions are adhered to