Oracle 12c DBA SCHEDULE

Share via:

Oracle 12c DBA SCHEDULE 

Prerequisite for Oracle DBA  Training.

The candidate should have knowledge on Basic SQL  & Basic Unix.

Sno Batch : 19th Jan 2019 Timings: 08.00-11.00 AM Faculty : Ajay
Week – 1
1 Oracle 12c Architecture-1
2 Oracle 12c Architecture-2
3 Oracle 12c Architecture-3
4 Startup & Shutdown Modes / DB-Creation, TS-Mgmt
Week – 2
5 SP File & OMF, Storage (Dictionary & Locally Managed)
6 Undo Mgmt, FB-Query, FB-Table and FB-Version Query
7 User / Role / Profile Mgmt / Schema Mgmt
8 Intro to Networking with Oracle 12c
DB Links & Materialized Views (with MV-Logs)
Week -3
9 Redo-Log & Control File Mgmt,TTS for a single partition
10 Logical Bkups – Reg & Incr Exports
11 Data Pump (expdp & impdp)
12 Bkup/Rec-1 – Cold-1, Bkup / Rec-2 – Cold-2
Week -4
13 Bkup/Rec-3 – Hot Backup
14 Bkup/Rec-4 – RMAN-1 – Theory
15 Bkup/Rec-5 – RMAN-2 – Scenarios
Week -5
16 12c Multitenant Architecture
17 Top-N Query, Recover Table using RMAN, TEMP Undo, Online stats
18 PDB Cloing Methods
19 Move active DBF, Redaction Policy, Invisible Columns, DDL Tracking
20 Oracle 12c Installations
Week -6
21 Availability-1 Data-Guard / DB-Cloning
22 Availability – 2 Active / Snapshot Standby
23 Availability – 2 Logminer
Week -7
24 PT-9 ASM (Auto Storage Management)
PT-10 ASM Demo
25 PT-1 DB-Tuning, PT-2 Appl Tuning
26 PT-3 Memory Tuning
Week -8
27 PT-4 NetworkTuning
PT-5 AOS / AWR / ADDM / ASH / ASMM / ASSM / PTSM
28 PT-6 Flashback DB / Flashback Data Archive
29 PT-7 Partitioning / Special Indexes
30 PT-8 Resumable, Row-Chaining / Row-Migration
Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
Loading...

One thought on “Oracle 12c DBA SCHEDULE

Add Comment