Oracle DBA
Amazon Web Services (AWS) is a comprehensive, evolving cloud computing platform provided by Amazon. It provides a mix of infrastructure as a service (IaaS), platform as a service (PaaS), and packaged software as a service (SaaS) offerings. Amazon Web Services (AWS) is a secure cloud services platform, offering to
Our Course Content
Introduction to Oracle DBA 12c / 11G
- Oracle Database 12c New and Enhanced Features
- Objectives
- Challenges
- Oracle Database in 11g Release
- High Performance Systems
Basics of Multi Container DB
- New Multitenant Architecture: Benefits
- Other Benefits of Multitenant Architecture
- Multitenant Container Database
- Separating SYSTEM and User Data
- Naming the Containers
- Provisioning a Pluggable Database
- Basics of Multitenant Container Database and Pluggable Databases
- Interacting Within Multitenant Container Database
- Exploring CDB Architecture and Structures
Creating a Multi Container DB
- Steps to Create a Multitenant Container Database
- Creating a Multitenant Container Database Using SQL*Plus
- Exploring CDB and PDB Structures
- Create New PDB from PDB$SEED
- With FILE_NAME_CONVERT
- Without FILE_NAME_CONVERT
- Cloning PDB within the Same CDB
- Plugging a Non-CDB into a CDB
- Dropping a PDB (optional)
- Plug Unplugged PDB in to CDB
Managing Multi Container DB
- Starting Up a CDB Instance
- Mounting a CDB
- Opening a CDB
- Opening a PDB
- Closing a PDB
- Shutting Down a CDB Instance
- Creating after Startup Trigger to Open All PDBs
- Changing PDB Mode
- Changing PDB Mode with SQL Developer
- Instance Parameter Changes and its Impact on PDBs
Managing Table Sapce and Users in CDB and PDSs
- Creating Permanent Tablespaces in a CDB
- Assigning Default Tablespaces
- Creating Local Temporary Tablespaces
- Assigning Default Temporary Tablespaces
- Users, Roles, and Privileges
- Local Users, Roles, and Privileges
- Creating a Local User
- Common Users
- Creating a Common User
- Common and Local Schemas / Users
- Common and Local Privileges
- Granting and Revoking Privileges
- Creating Common and Local Roles
- Granting Common or Local Privileges / Roles to Roles
- Granting Common and Local Roles to Users
- Granting and Revoking Roles
- Creating Shared and Non-Shared Objects
Backup, Recovery, Flashback CDB and PDBs
- Whole CDB Backup
- User-Managed Hot CDB Backup
- Partial CDB Backup
- Whole PDB Backup
- Partial PDB Backup
- SQL PDB Hot Backup (optional)
- SQL Control File Backup (optional)
- Media Failure: CDB or PDB Temp File Recovery
- Media Failure: PDB Temp File Recovery
- Media Failure: Control File Loss
- Media Failure: Redo Log File Loss
- Media Failure: Root SYSTEM or UNDO Data File
- Media Failure: Root SYSAUX Data File
- Media Failure: PDB SYSTEM Data File
- Media Failure: PDB Non-SYSTEM Data File
- Media Failure: PITR
Heat Map , Automatic Data Optimization
Auditing
Oracle Data Guard
Standby Databases
Far Sync Instances
Oracle Data Guard Services
Configuration of Far sync Instance
Supported protection modes for Far sync instances
Configuring Redo Transport services
Cascading redo transport destinations
Cascading Physical standby database
Cascading multiple Physical standby’s
Apply services
Data guardUpgrade using SQL apply
Oracle Datagurad Scenario’s
Downgrading database in Data guard Configuration
Creating standby using rman