Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Oracle 11g Advanced DBA
Before you start
Download Course Material
Oracle Physical Storage Structures
Oracle Database Important Files (19:39)
How to Identify Your Database Files (4:36)
Physical Storage Best Practicies (12:13)
Oracle Logical Storage Structures
Different Logical Structures (6:15)
Inside Oracle Data Block (19:52)
Extents in Oracle (4:47)
Segments in Oracle (12:25)
Tablespace in Oracle (4:05)
Oracle Database Instance
What is Oracle Instance (6:31)
Oracle Instance Duration (9:20)
Database Startup and Shutdown Modes (12:58)
How Oracle Instance Recovery Works (20:57)
Database Tables and Tables Cluster
Database Schema and Objects (14:30)
Tables in Database (10:13)
Introduction to Table Cluster (14:22)
Creating Tables Cluster (12:47)
How Tables Cluster Look Inside Database (2:58)
Tables and Index Partitioning
Tables and Index Partition Overview (11:29)
Partition Strategy (9:10)
Range Partitioning (6:16)
Lab Activity - Creating Table Partitions (14:55)
Lab Activity - Creating Index Partitions (22:49)
Advanced Database Management
Manual DB Creation (22:12)
Tablespace Best Practicies (5:57)
Lab Activity - Tablespace Utilization (11:15)
Tablespace Utilization Reports (17:34)
Lab Activity - Tablespace Administration (26:10)
Database Operating Best Practicies
Database Alerts (7:35)
Special Implementation (6:51)
Managing Environment (6:26)
DB Troubleshooting Flow (10:14)
Advance Database Networking
Introduction to Oracle Listener (16:19)
Installing Oracle Client on Windows (9:45)
Oracle Connection Naming Methods (12:02)
Troubleshooting DB Networking (11:34)
Oracle Recovery Manager
Introduction to RMAN (59:06)
RMAN Channels and Parallelism (40:10)
Performing RMAN Backups
RMAN Backup Types (37:40)
Taking RMAN Backups (83:39)
RMAN Backups Best Practicies (7:26)
RMAN Recovery Catalog
Introduction to Recovery Catalog (20:43)
Recovery Catalog Configuration (34:36)
Introduction to RMAN Recovery
RMAN Recovery Mechanism (3:38)
RMAN Recovery Types (4:43)
DB Recovery via RMAN DB FULL Backup
Recovery Scenarios (5:43)
Loss of All Data Files Recovery (22:54)
Loss of All Control Files and Data Files Recovery (26:07)
Loss of Entire Database Recovery (32:01)
Database Point-In-Time Recovery (12:47)
DB Recovery Via RMAN Incremental Backup
Back to Basics (15:43)
Introduction to RMAN Incremental Recovery (3:24)
Database Recovery After Loss of All Data Files (15:11)
Database Point-In-Time Recovery Via Incremental Backup (13:32)
Single Datafile Recovery Using RMAN (18:58)
RMAN Recovery Best Practicies (6:47)
RMAN Scripting
RMAN Command File Scripting (50:49)
RMAN Catalog Scripting (24:15)
Scheduling RMAN Backups (2:26)
Advanced Database Cloning
DB Cloning Via DBCA (25:59)
Introduction to DB cloning via RMAN (19:54)
DB cloning via RMAN Restore Recover Method (35:21)
Rename DB Post Cloning (14:02)
Active Database Cloning via RMAN Duplicate Method (14:10)
Cloning Best Practicies (15:50)
Introduction to Oracle High Availability
What is High Availability (24:47)
Data Guard components (10:27)
Types of standby databases (27:48)
Data Guard Important Terms (11:15)
Data Guard Recommendations (7:18)
Physical Standby Configuration
Introduction to Physical Standby (2:34)
Why Physical Standby (2:17)
Physical Standby Configuration Overview (2:01)
Production server changes for Data Guard (39:53)
Parameter changes for production and standby server (35:02)
Clone production and create physical standby (11:51)
Starting Log Apply Service on Standby (8:51)
How to troubleshoot Data Guard
How to troubleshoot Data Guard (3:03)
How to verify your Data Guard Setup (4:44)
Shutdown and startup servers in Data Guard configuration (5:10)
Active Data Guard from Physical Standby (3:57)
Convert Physical Standby to Active Data Guard (2:49)
Oracle Flashback
Why Oracle Flashback (18:58)
Oracle Flashback and Types of Flashback (9:58)
Flashback Table to SCN (14:18)
Flashback Table Drop (9:24)
Flashback Database (13:25)
Introduction to Oracle Upgrades
Oracle upgrade overview (11:25)
Oracle real time upgrade process (17:42)
Oracle 11201 to 11204 Upgrade
Oracle 11201 to 11204 upgrade steps (11:44)
11201 to 11204 prepare for upgrade (11:56)
11201 to 11204 Pre-Upgrade Phase (25:53)
11201 to 11204 Database Upgrade Phase (11:32)
11201 to 11204 Post-Upgrade Phase (17:28)
Oracle 11204 to 12101 Upgrade
11204 to 12101 prepare for upgrade (6:12)
11204 to 12101 Pre-Upgrade Phase (20:57)
11204 to 12101 Database Upgrade Phase (7:58)
11204 to 12101 Post-Upgrade Phase (11:02)
Summary
Interview Questions
Troubleshooting DB Networking
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock