Oracle 11g Advanced DBA
Take your database administration skills to next level
Count
Detailed Concepts. Detailed Practice. The Next Level Administration.
Get closer to Oracle database functioning by administering critical database components. With RMAN, Data Guard, Flashback, Locks, Storage Structures, learn to play like real-time DBAs. Get ready to manage some of the most critical production databases out there!
What you will learn
Advance RMAN administration, scripting and cloning
Advance database networking for easy client connections
Advance table, index and table partitions administration
Advance database administration real-time best practices
Oracle Physical Storage Structures
19:39
Oracle Database Important Files
04:36
Identify Database Files
12:13
Storage Best Practices
Oracle Logical Storage Structures
06:15
Different Logical Structures
19:52
Inside Oracle Data Block
04:47
Extents in Oracle
12:25
Segments in Oracle
04:05
Tablespace in Oracle
Oracle Database Instance
06:31
What is Oracle Instance
09:20
Oracle Instance Duration
12:58
DB Startup & Shutdown
20:57
Oracle Instance Recovery
Database Tables and Tables Cluster
14:30
Database Schema and Objects
10:13
Tables in Database
14:22
Introduction to Table Cluster
12:47
Creating Tables Cluster
02:58
Tables Cluster Inside Database
Tables and Index Partitioning
11:29
Partitioning Overview
09:10
Partition Strategy
06:16
Range Partitioning
14:55
Create Table Partitions
22:49
Create Index Partitions
Advanced Database Management
22:12
Manual DB Creation
05:57
Tablespace Best Practicies
11:15
Find Tablespace Utilization
17:34
Tablespace Utilization
26:10
Tablespace Administration
Database Operating Best Practicies
07:35
Database Alerts
06:51
Special Implementation
06:26
Managing Environment
10:14
DB Troubleshooting Flow
Advance Database Networking
16:19
Introduction to Oracle Listener
09:45
Installing Oracle Client
12:02
Oracle Naming Methods
11:34
Troubleshoot DB Networking
Oracle Recovery Manager
59:06
Introduction to RMAN
40:10
RMAN Channels and Parallelism
Performing RMAN Backups
37:40
RMAN Backup Types
01:23:39
Taking RMAN Backups
07:26
RMAN Backups Best Practicies
RMAN Recovery Catalog
20:43
Introduction to Recovery Catalog
34:36
Recovery Catalog Configuration
Introduction to RMAN Recovery
03:38
RMAN Recovery Mechanism
04:43
RMAN Recovery Types
DB Recovery via RMAN DB FULL Backup
05:43
Recovery Scenarios
22:54
All Data Files Recovery
26:07
Control & Data Files Recovery
32:01
Recover Entire Database
12:47
Database Point-In-Time Recovery
DB Recovery Via RMAN Incremental Backup
15:43
Back to Basics
03:24
Incremental Recovery Overview
15:11
Recovery After Loss of All Datafiles
13:32
Database PITR
18:58
Recover Single Datafile
06:47
RMAN Recovery Best Practicies
RMAN Scripting
50:49
RMAN Command File Scripting
24:15
RMAN Catalog Scripting
02:26
Scheduling RMAN Backups
Advanced Database Cloning
25:59
DB Cloning Via DBCA
19:54
Introduction to DB Cloning
35:21
RMAN Restore Recover Cloning
14:02
Rename DB Post Cloning
14:10
RMAN Active DB Duplicate
15:50
Cloning Best Practicies
Introduction to Oracle High Availability
24:47
What is High Availability
10:27
Data Guard components
27:48
Types of standby databases
11:15
Data Guard Important Terms
07:18
Data Guard Recommendations
Physical Standby Configuration
02:34
Introduction to Physical Standby
02:17
Why Physical Standby
02:01
Physical Standby Overview
39:53
Primary DB Changes
35:02
Primary & Stb Parameters
11:51
Clone Primary to Standby
08:51
Starting Log Apply Service on Stb
How to troubleshoot Data Guard
03:03
Troubleshoot Data Guard
04:44
How to verify your Data Guard Setup
05:10
Data Guard Startup Sequence
03:57
Active Data Guard from Physical Standby
02:49
Physical Stb to Active Data Guard
Oracle Flashback
18:58
Why Oracle Flashback
09:58
Oracle Flashback Types
14:18
Flashback Table to SCN
09:24
Flashback Table Drop
13:25
Flashback Database
Introduction to Oracle Upgrades
11:25
Oracle upgrade overview
17:42
Oracle real time upgrade process
Oracle 11201 to 11204 Upgrade
11:44
11201 to 11204 upgrade steps
11:56
11201 to 11204 prepare for upgrade
25:53
11201 to 11204 Pre-Upgrade
11:32
11201 to 11204 Database Upgrade
17:28
11201 to 11204 Post-Upgrade
Oracle 11204 to 12101 Upgrade
06:12
11204 to 12101 prepare for upgrade
20:57
11204 to 12101 Pre-Upgrade
07:58
11204 to 12101 Database Upgrade
11:02
11204 to 12101 Post-Upgrade