Full Oracle Database High Availability Features
What you’ll learn
This Oracle course introduces all the Oracle Database High Availability features fundamental to manage Oracle Database and designing a backup and recovery.
You will become an expert in subjects like Oracle 12C Release 2, Oracle 12C R2 Backup and Recovery ( using RMAN), Oracle Data Guard
Backup and recovery concepts in Oracle
Setting up the laboratory environment
Creating and managing recovery catalog
Using flashback Technologies in Oracle
Managing RMAN backups
Setting Up Oracle Enterprise Linux
What is Real Application Cluster?
Install Grid Infrastructure, Database Software and Create database
Administer Database Instances and Cluster Databases
Learn about Oracle RAC One Node
To convert RAC database to RAC One Node and administer it
Design and Deployment Techniques
Data Guard Administration for Oracle 12C R2
Creating Virtual Machines
Basic Usage of Data Guard Broker Utility
Switchover and Failover Operations on Physical Standby Database via both SQLPlus and Data Guard Broker
Creating Far Sync Instance
Configuring Primary and Standby Databases for far sync Instance
Switchover & Failover Operations on Logical Standby Database via both SQLPlus and Data Guard Broker
Oracle Database is an enterprise database that can handle online transaction processing needs, as well as data warehousing and workloads for ERP
Oracle DB was designed to be a flexible way to handle large applications and massive amounts of structured data.
What is oracle SQL? SQL stands for Structured Query Language—the language developers use to interact with databases to create, read, update, and delete database
ANSI created the standard for SQL. Many database vendors, like Oracle, expand on this standard to create their version of the language.
Oracle SQL is compliant with ANSI SQL standards, with features designed specifically for the Oracle database management system.
What careers use Oracle SQL? Having Oracle SQL skills can add value to many careers.
The most obvious is being a database administrator in enterprises that use the Oracle database management system.
Database developers also use Oracle SQL all day long to create new databases and table structures.
Most applications require a database to function, so software engineers and web developers also use Oracle SQL frequently.
Requirements
12 GB memory
60 GB of free disk space
A computer with access to the internet
Basic Computer Knowledge with (Win7/8/10)
Desire to learn Oracle RAC
Desire to learn Oracle Guard
Desire to learn Oracle Database Administration
Your ambitious to become Oracle Database Administrator
Nothing else! It’s just you, your computer and your ambition to get started today
Description
Hey there,Welcome to my Full Oracle Database High Availability Features course.Oracle Database with Oracle 12C RAC, Oracle Data Guard, Oracle Backup and Oracle Data Recovery, and Oracle RMANIn this course, you will become an expert in subjects like Oracle 12C Release 2, Oracle 12C R2 Backup and Recovery ( using RMAN), Oracle Data Guard, and all High Availability features that you need to know about Oracle Databases in the real world. Oracle rac, oracle data guard, data recovery, oracle, rac, data guard, oracle rac 12c, oracle database, rman, oracle 19c, oracle 12c racIf you are;a junior Oracle DBADBA who is managing other RDBMS and want to immigrate to OracleYou are at the right place!In the course, you will have down-to-earth way explanations with hands-on examples. During the course, we focus more on the practical side of Oracle Databases. All my students will have a chance to learn not only the whats but also learn the whys and hows.Oracle Database is an enterprise database that can handle online transaction processing needs, as well as data warehousing and workloads for enterprise resource planning (ERP). Oracle DB was designed to be a flexible way to handle large applications and massive amounts of structured data.This course starts with the very basics. First, you will learn how to install the tools. Then the show will start and we will start with introducing the Oracle Database architecture, this course will take you all away from performing basic database operations up to implementing advanced operation options.At the end of the course;Backup and recovery concepts in OracleSetting up the laboratory environmentCreating and managing the recovery catalogUsing flashback Technologies in OracleBacking up the databaseReporting on RMAN operations.Managing RMAN backupsUsing Data Recovery Advisor of OracleRestoring and recovering database and database objects.The point-in-time recovery concept in Oracle will be crystal clear for you.What is RAC ( Real Application Cluster )Creating Virtual MachinesAdminister Database Instances and Cluster DatabasesOracle RAC One NodeHow to Convert RAC Database to RAC One NodeWorkload ManagementMonitoring PerformanceDesign and Deployment TechniquesCloning Oracle RACManaging backup, and restoring cluster databaseAdd and Delete Node From ClusterWhat is DataguardCloning Virtual MachinesInstalling Database Software and Creating DatabaseCreating Physical Standby DatabaseManaging Physical Standby DatabaseBasic usage of Data Guard Broker UtilityCreating and managing snapshot databasesSwitchover and failover operations on physical standby database via both SQLPlus and Data Guard BrokerCreating Far Sync InstanceConfiguring primary and standby databases for far sync instanceCreating Logical Standby databaseManaging Logical Standby databaseWhat is oracle SQL?SQL stands for Structured Query Language—the language developers use to interact with databases to create, read, update, and delete database records and manage other aspects of those databases. ANSI created the standard for SQL. Many database vendors, like Oracle, expand on this standard to create their version of the language. Oracle SQL is compliant with ANSI SQL standards, with features designed specifically for the Oracle database management system. This RDBMS was released as the first commercially available relational database management system in 1977 and holds the top market share worldwide for relational database management systems. Oracle SQL extends the SQL standard with a procedural language PL/SQL and adds the ability to use the Java programming language.What careers use Oracle SQL?Having Oracle SQL skills can add value to many careers. The most obvious is being a database administrator in enterprises that use the Oracle database management system. But SQL dialects are pretty similar, and knowledge of Oracle SQL can apply to many types of relational databases and doesn’t limit you to Oracle. Database developers also use Oracle SQL all day long to create new databases and table structures. Most applications require a database to function, so software engineers and web developers also use Oracle SQL frequently. Data scientists must access data to create machine learning models and find trends, and a lot of this data will get stored in databases that require a knowledge of SQL to retrieve and transform. Business analysts also use Oracle SQL to generate reports that help businesses get to their next stage.What skills should I have before learning Oracle SQL?There are no prerequisites to learning Oracle SQL. Oracle SQL has a simpler syntax than many standard programming languages and reads almost like English. Most people can understand what a SQL query is trying to do before they even know the language. All you need is an interest in the language and a commitment to learning. That said, some things could help with your Oracle SQL education if you are already familiar with them. If you are familiar with Excel spreadsheets and understand how columns and rows work, you can apply that knowledge to Oracle database tables. It also helps to know at least the concepts of how a relational database management system works. Also, if you already know a programming language, that will help learn Oracle’s extended features like PL/SQL.Fresh ContentOracle is a unique technology that provides high availability and scalability for all application types. It prevents the server from being a single point of failure. And this course introduces all the Oracle Database High Availability features fundamental to manage Oracle Database and designing a backup and recovery. Why would you want to take this course? Our answer is simple: The quality of teaching. When you enroll, you will feel our seasoned developers’ expertise. Step-by-Step Way, Simple and Easy With Exercises By the end of the course, you’ll have a firm understanding of the Oracle Database in all aspects and valuable insights on how things work under the hood and you’ll also be very confident, and hungry to learn more.Video and Audio Production QualityAll our videos are created/produced as high-quality video and audio to provide you the best learning experience. You will be,Seeing clearlyHearing clearlyMoving through the course without distractions You’ll also get:Lifetime Access to The CourseFast & Friendly Support in the Q&A sectionUdemy Certificate of Completion Ready for DownloadDive in now to our Full Oracle Database High Availability Features courseWe offer full support, answering any questions.See you in the course!
Overview
Section 1: Intro to Oracle Database, Oracle Data Guard, Data Recovery, Oracle Rman
Lecture 1 Let’s See What We Will Cover In This RMAN Course
Lecture 2 Project Files and Course Documents Oracle RAC, Oracle Guard
Lecture 3 FAQ about Full Oracle Database High Availability Features
Section 2: Downloads Oracle RAC, Oracle RMAN
Lecture 4 Download Virtualbox in Oracle Database
Lecture 5 Download Linux in Oracle Database
Lecture 6 Download Oracle Software
Section 3: Installation in Oracle Database
Lecture 7 Install Virtual Box in Oracle Database
Lecture 8 Create Virtual Machine in Oracle Database
Lecture 9 Install Guest Operating System
Lecture 10 Prerequisites
Lecture 11 Oracle Software Installation
Lecture 12 Clone Virtual Machine
Lecture 13 Create Primary Database
Lecture 14 Create Catalog Database
Lecture 15 Create Sample Data
Section 4: Intro to Backup and Recovery
Lecture 16 Introduction to Backup and Recovery
Section 5: Starting and Interacting with the RMAN Client
Lecture 17 Starting and Interacting with the RMAN Client
Section 6: Create Recovery Catalog
Lecture 18 Create Recovery Catalog
Section 7: Flashback Database and Restore Points
Lecture 19 Flashback Database and Restore Points Presentation
Lecture 20 Flashback Database and Restore Points
Section 8: Backup Database
Lecture 21 Backup Database Concepts
Lecture 22 Backup Database
Lecture 23 Backup Database – Advanced Topics
Section 9: Reporting on RMAN Operations
Lecture 24 Reporting on RMAN Operations
Section 10: Maintaining RMAN Backups and Repository Records
Lecture 25 Maintaining RMAN Backups and Repository Records Presentation
Lecture 26 Maintaining RMAN Backups and Repository Records
Section 11: Managing Recovery Catalog
Lecture 27 Managing Recovery Catalog Presentation
Lecture 28 Managing Recovery Catalog
Section 12: Data Repair Concepts
Lecture 29 Data Repair Concepts
Lecture 30 Data Recovery Advisor
Section 13: Validating Database Files and Backups
Lecture 31 Validating Database Files and Backups
Section 14: Performing Complete Database Recovery
Lecture 32 Performing Datafile Recovery
Lecture 33 Performing Tablespace Recovery
Lecture 34 Performing PDB Recovery
Lecture 35 Performing Database Recovery
Section 15: Performing Point-in-Time Recovery
Lecture 36 Database Point In Time Recovery
Lecture 37 Tablespace Point In Time Recovery
Section 16: Performing Block Media Recovery
Lecture 38 Performing Block Media Recovery
Section 17: What We Have Learned In This RMAN Course?
Lecture 39 Let’s Wrap Up What We Covered In This RMAN Course
Section 18: Introduction to Oracle RAC (Real Application Cluster)
Lecture 40 Intro to RAC
Section 19: Setting Up The Environment
Lecture 41 Create Virtual Machine
Lecture 42 Install Guest Operating System
Lecture 43 Install Grid Prerequisites Part1
Lecture 44 Install Grid Prerequisites Part2
Lecture 45 Clone Virtual Machine
Lecture 46 Create Shared Disk
Lecture 47 Install Grid Infrastructure
Lecture 48 Install Database Software
Lecture 49 Create Database
Section 20: Administration of Oracle RAC
Lecture 50 Start Crs
Lecture 51 Start Database
Lecture 52 Stop Database & CRS
Lecture 53 Disable CRS
Lecture 54 Add & Delete Service
Lecture 55 Kill a Session & Set Spfile Parameter
Section 21: RAC One Node
Lecture 56 Administration of RAC One Node
Section 22: Workload Management
Lecture 57 Workload Management
Section 23: Monitoring Performance
Lecture 58 Monitoring Performance
Section 24: Design & Deployment Techniques
Lecture 59 Design & Deployment Techniques
Lecture 60 Clone Oracle RAC
Section 25: Managing Backup & Recovery
Lecture 61 Introduction to Recovery & RMAN
Lecture 62 Backup Database
Lecture 63 Restore Database
Section 26: Add & Delete Node
Lecture 64 Add Node to Cluster
Lecture 65 Delete Node from Cluster
Section 27: Tips & Tricks
Lecture 66 First Controls of Day
Lecture 67 Monthly Controls
Lecture 68 Useful Scripts Usage
Lecture 69 Opatch-AWR-ASH
Lecture 70 ORA Errors Solutions
Section 28: Let’s Start to Learn Oracle Data Guard
Lecture 71 What is Oracle Data Guard?
Lecture 72 Understanding the Oracle Data Guard Administration
Lecture 73 Redo Transport Services
Lecture 74 Apply Services
Section 29: Downloads
Lecture 75 Download Virtualbox
Lecture 76 Download Oracle Linux
Lecture 77 Download Oracle Software
Section 30: Installations
Lecture 78 Install Virtualbox
Lecture 79 Create Virtual Machine
Lecture 80 Install Guest Operating System
Lecture 81 Install Prerequisites
Lecture 82 Install Oracle Software
Lecture 83 Clone Virtual Machine
Lecture 84 Create Database
Section 31: Creating Physical Standby
Lecture 85 Creating Physical Standby Presentation
Lecture 86 Creating Physical Standby Practice
Section 32: Managing Physical Standby
Lecture 87 Managing Physical Standby
Section 33: Managing Snapshot Database
Lecture 88 Managing Snapshot Database
Section 34: Role Transitions on Physical Standby
Lecture 89 Role Transitions Presentation
Lecture 90 Switchover on Physical Standby
Lecture 91 Failover on Physical Standby
Section 35: Far Sync Instance
Lecture 92 What is Far Sync Instance?
Lecture 93 Far Sync Instance Practice
Section 36: Creating Logical Standby
Lecture 94 Creating Logical Standby
Lecture 95 Creating Logical Standby Practice
Section 37: Managing Logical Standby
Lecture 96 Managing Logical Standby
Section 38: Role Transitions on Logical Standby
Lecture 97 Switchover on Logical Standby
Lecture 98 Failover on Logical Standby
Section 39: Extra
Lecture 99 Full Oracle Database High Availability Features
Anyone who is Oracle Database beginner but wants to become expert,DBA`s who are looking to sharpen their skills to the expert level,DBA`s that manage other RDBMS and want to immigrate Oracle,Anyone who wants to become seasoned DBA,Anyone who wants to become an Oracle DBA at a big company,People who want to learn Oracle Database Administration,People who want to learn Oracle Guard,People who want to learn Oracle RAC
Course Information:
Udemy | English | 15h 33m | 196.61 MB
Created by: Oak Academy
You Can See More Courses in the Developer >> Greetings from CourseDown.com