Oracle Advanced Database Administration for Experts

سرفصل های دوره

Mastering High Availability, Performance Tuning, and Advanced Recovery Techniques

1. Oracle Physical Storage Structures

1. Oracle Database Important Files

2. Identify Database Files

3. Storage Best Practices

2. Oracle Logical Storage Structures

1. Different Logical Structures

2. Inside Oracle Data Block

3. Extents in Oracle

4. Segments in Oracle

5. Tablespace in Oracle

3. Oracle Database Instance

1. What is Oracle Instance

2. Oracle Instance Duration

3. DB Startup & Shutdown

4. Oracle Instance Recovery

4. Database Tables and Tables Cluster

1. Database Schema and Objects

2. Tables in Database

3. Introduction to Table Cluster

4. Creating Tables Cluster

5. Tables Cluster Inside Database

5. Tables and Index Partitioning

1. Partitioning Overview

2. Partition Strategy

3. Range Partitioning

4. Create Table Partitions

5. Create Index Partitions

6. Advanced Database Management

1. Manual DB Creation

2. Tablespace Best Practicies

3. Find Tablespace Utilization

4. Tablespace Utilization

5. Tablespace Administration

7. Database Operating Best Practicies

1. Database Alerts

2. Special Implementation

3. Managing Environment

4. DB Troubleshooting Flow

8. Advance Database Networking

1. Introduction to Oracle Listener

2. Installing Oracle Client

3. Oracle Naming Methods

4. Troubleshoot DB Networking

9. Oracle Recovery Manager

1. Introduction to RMAN

2. RMAN Channels and Parallelism

10. Performing RMAN Backups

1. RMAN Backup Types

2. Taking RMAN Backups

3. RMAN Backups Best Practicies

11. RMAN Recovery Catalog

1. Introduction to Recovery Catalog

2. Recovery Catalog Configuration

12. Introduction to RMAN Recovery

1. RMAN Recovery Mechanism

2. RMAN Recovery Types

13. DB Recovery via RMAN DB FULL Backup

1. Recovery Scenarios

2. All Data Files Recovery

3. Control & Data Files Recovery

4. Recover Entire Database

5. Database Point-In-Time Recovery

14. DB Recovery Via RMAN Incremental Backup

1. Back to Basics

2. Incremental Recovery Overview

3. Recovery After Loss of All Datafiles

4. Database PITR

5. Recover Single Datafile

6. RMAN Recovery Best Practicies

15. RMAN Scripting

1. RMAN Command File Scripting

2. RMAN Catalog Scripting

3. Scheduling RMAN Backups

16. Advanced Database Cloning

1. DB Cloning Via DBCA

2. Introduction to DB Cloning

3. RMAN Restore Recover Cloning

4. Rename DB Post Cloning

5. RMAN Active DB Duplicate

6. Cloning Best Practicies

17. Introduction to Oracle High Availability

1. What is High Availability

2. Data Guard components

3. Types of standby databases

4. Data Guard Important Terms

5. Data Guard Recommendations

18. Physical Standby Configuration

1. Introduction to Physical Standby

2. Why Physical Standby

3. Physical Standby Overview

4. Primary DB Changes

5. Primary & Stb Parameters

6. Clone Primary to Standby

7. Starting Log Apply Service on Stb

19. How to troubleshoot Data Guard

1. Troubleshoot Data Guard

2. How to verify your Data Guard Setup

3. Data Guard Startup Sequence

4. Active Data Guard from Physical Standby

5. Convert Physical Stb to Active Data Guard

20. Oracle Flashback

1. Why Oracle Flashback

2. Oracle Flashback Types

3. Flashback Table to SCN

4. Flashback Table Drop

5. Flashback Database

21. Introduction to Oracle Upgrades

1. Oracle upgrade overview

2. Oracle real time upgrade process

22. Oracle 11201 to 11204 Upgrade

1. 11201 to 11204 upgrade steps

2. 11201 to 11204 prepare for upgrade

3. 11201 to 11204 Pre-Upgrade

4. 11201 to 11204 Database Upgrade

5. 11201 to 11204 Post-Upgrade

23. Oracle 11204 to 12101 Upgrade

1. 11204 to 12101 prepare for upgrade

2. 11204 to 12101 Pre-Upgrade

3. 11204 to 12101 Database Upgrade

4. 11204 to 12101 Post-Upgrade

“Creating Twitch Clone – Practical MERN Stack Course 2023” به سبد خرید شما اضافه شد. مشاهده سبد خرید

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy