Oracle BI

Oracle BI, ASM, Data Guard Training

Table of Contents

• Overview ……………………………………………………………………………………………………………………………………. 3
• About DBA University, Inc. ……………………………………………………………………………………………………………. 3
• Srini Ramineni – Faculty and Founder, DBA University …………………………………………………………………….. 4
• Pricing and Registration ……………………………………………………………………………………………………………….. 5
• Eligibility …………………………………………………………………………………………………………………………………….. 6
• REMOTE LAB Access …………………………………………………………………………………………………………………….. 6
• Course Topics ……………………………………………………………………………………………………………………………… 6
• Oracle 12c Automatic Storage Management (ASM) – Install and setup ………………………………………….. 7
• Introduction and benefits of Oracle ASM. ……………………………………………………………………………….. 7
• Oracle ASM 12c software installation and configuration (Grid Infrastructure) …………………………….. 7
• Partitioning Disks in LINUX using the fdisk utility ……………………………………………………………………… 7
• What is device persistency and how Oracle ASMLib Utility can be used for device persistency. …….. 7
• pracle 12c ASMCA (ASM Configuration Assistant). …………………………………………………………………… 7
• ASM Parameter file, ASM Instance and working with DISKGROUPS. …………………………………………… 7
• Querying ASM Information using v$ views. ……………………………………………………………………………… 7
• Creating Database Files using ASM. ………………………………………………………………………………………… 7
• Oracle Automatic Storage Management (ASM) – Mirroring Disks ………………………………………………….. 7
• Understanding ASM Disk Redundancy (Mirroring). …………………………………………………………………… 7
• Learn about the three levels of ASM redundancy. ……………………………………………………………………. 7
• How Oracle manages ASM Disk failures. …………………………………………………………………………………. 7
• How to replace a failed ASM disk with a new disk. …………………………………………………………………… 7
• ASM Disk Rebalancing operations. …………………………………………………………………………………………. 7
• pracle 12c Real Application Clusters (RAC) …………………………………………………………………………………. 7
• Components of an Oracle RAC environment. …………………………………………………………………………… 8
• Understand the various storage, network and hardware requirements in Oracle RAC ………………….. 8

Overview

Database Administrators (DBAs) are responsible for the design,implementation, support and maintenance of computerizeddatabases in today’s organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers.

All the above tasks are performed with the help of a Database Management System (DBMS) and the leading and most widely used DBMS across the world today are the Oracle, Microsoft SQL Server, MySQL database etc.

DBAs play an important and responsible role in every company’s Information Technology (IT) department. DBAs are also very well paid and the average annual salary is more than $100,000 in the USA.

Furthermore, it is projected that the demand for DBAs will grow at the rate of 30% per year until 2023. www.cnn.com also published an article recently that Database Administrators are in the TOP TWENTY in-demand jobs for the next decade.

Oracle 12c Data Guard

• Introduction to Oracle 12c Data Guard and its various protection modes.
• How to enable an Oracle database to belong to a Data Guard configuration.
• Understand the initialization parameter requirements of Primary and Standby databases.
• Create a physical standby database using Primary database’s full RMAN backup.
• How to configure a Primary database to become a future standby database.

Managing a Data Guard Environment

• Understand Oracle data dictionary views for monitoring Log Shipping and Log Apply.
• Introduction to Oracle Data Guard broker (DGMGRL) utility
• Advantages of DGMGRL over the traditional sqlplus utility.
• How to create a Data Guard Broker configuration.
• How to perform a switchover operation using Data Guard Broker.

Unique Teaching Methodology

We use a DIGITAL WHITE BOARD for teaching our online courses. Teaching with a DIGITAL WHITE BOARD gives our students a traditional classroom like experience. The faculty writes and draws by free hand on the DIGITAL WHITE BOARD and all our students can see it in real time in the online classroom.