What you'll learn
- Oracle DBA
- Oracle RAC DBA
- Oracle EBS DBA
- Oracle Cloud DBA's
Requirements
- Oracle DBA
Description
Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions
What are the differences between physical, logical, snapshot standby and ADG (or) what are different types of standby databases?
Answer :
Physical standby – in mount state, MRP will apply archives
ADG (Active Data Guard) – in READ ONLY state, MRP will apply archives
Logical standby – in READ ONLY state, LSP will run
Snapshot standby databases – Physical standby database can be converted to snapshot standby database, which will be in READ WRITE mode, can do any kind of testing, then we can convert back snapshot standby database to physical standby database and start MRP which will apply all pending archives.
If you didn't have access to the standby database and you want to find out what error has occurred in a Data Guard configuration, what view would you check in the primary database to check the error message?
Answer :
You can check the v$dataguard_status view.
select message from v$dataguard_status;
What is failover/switchover (or) what is the difference between failover and switchover?
Answer :
Switchover – This is done when both primary and standby databases are available. It is pre-planned.
Failover – This is done when the primary database is NO longer available (i.e. in a Disaster). It is not pre-planned.
Who this course is for:
- Oracle EBS DBA who want to implement DataGaurd
Instructor
- 4.3 Instructor Rating
- 364 Reviews
- 3,450 Students
- 27 Courses
Kishore A is an Oracle E-Business DBA, Oracle Cloud Infrastructure Consultant and Oracle 12c/19c DBA consultant who takes a leadership role in Planning, Installing, and implementing innovative business process and system solutions using state-of-the-art approaches and technology. Creative problem-solver who always goes the extra mile, is adept at learning new systems and processes, and has proven ability to work effectively. Strong customer/user advocate, apt negotiator with excellent analytical, collaboration, communication, decision-making, and organization skills. He also has experience on Oracle Identity and Access Management (SSO) for 8 years including Integrating PaaS, SaaS and Azure AD/ADFS and also has worked in RAC 19c environment. He is also a Distinguished Toastmaster (DTM). He has 15 OCI certifications.
Kishore has below Certifications for his credit
Oracle Cloud Database Services 2021 Certified Specialist
Oracle Database Cloud Administrator 2021 Certified Professional
Oracle Cloud Infrastructure 2021 Certified Architect Professional
Oracle Cloud Infrastructure 2021 Certified Cloud Operations Associate
Oracle Autonomous Database Cloud 2021 Certified Specialist
Oracle Cloud Database Migration and Integration 2021 Certified Specialist
Oracle Cloud Infrastructure 2021 Certified Architect Associate
Oracle Cloud Infrastructure Foundations 2021 Certified Associate
Oracle Cloud Infrastructure 2021 Enterprise Workloads Certified Associate
Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator
Oracle Database Cloud Service 2020 Certified Specialist
Oracle Database Cloud Administrator 2020 Certified Professional
Oracle Cloud Infrastructure 2019 Certified Cloud Operations Associate
Oracle Cloud Infrastructure 2020 Certified Architect Associate
Oracle Cloud Infrastructure Foundations 2020 Certified Associate
Oracle Cloud Infrastructure 2019 Certified Architect Professional
Oracle Autonomous Database Cloud 2019 Certified Specialist
Oracle Cloud Infrastructure 2019 Certified Architect Associate
Oracle Cloud Infrastructure 2018 Certified Architect Associate
Oracle Database Cloud Administrator Certified Professional
Oracle Database Cloud Service Operations Certified Associate
Oracle Database 11g Administrator Certified Professional
Oracle E-Business Suite R12 Applications Database Administrator Certified Professional