Oracle Data Guard 12c Interview Questions and Answers - 1
Question: 1
What are the services required on standby database?
Standby database requires Fetch Archive Log (FAL) client to request and fetch archive log files from primary database, remote file server to receive archived log files from primary database, archiver process to archive redo logs applied to standby database, and Managed Recovery Process (MRP) to apply redo logs to the standby database.
Question: 2
What is the difference between logical standby database and physical stand by database?
A physical standby database is physically same as production database.
It has same file structure as production database while logical database can have different physical structure as compared to production database.
A physical standby is available only when production database is not available while logical standby can be available for reporting in parallel to production database.
Question: 3
Why do you need to have data guard?
Data guard setup ensures that another database is available as a copy of production database at almost real time.
As a result, we have higher protection for enterprise data and the new database is available very quickly without the need to actually restore and recover from backup.
Therefore, data guard offers an excellent disaster recovery solution.
Question: 4
What is data guard?
Data guard is a setup in which you can have one or more standby database available for a production database.
Question: 5
What are the services required on primary database?
Primary database requires log writer to generate log information, archiver process to generate archive log files, and fetch archive log server to request the archive log files from standby database.
1000+ Verbal Reasoning Test with Answers Pdf More
1000+ Classification Quiz Non Verbal Reasoning Questions Pdf More
1000+ Computer MCQ Questions for Competitive Exams Pdf More
Non Verbal Reasoning Questions and Answers for Bank Exams More
tnpsc vao chemistry question paper with answers More
TNPSC Economics Study Material in Tamil and English Pdf More
Top 50+ Select the Correct Question Tag TNPSC Exams More
Top 10,000+ TNPSC Group 2 General Knowledge Questions and Answers More
Top 100+ Indian Economy Online Test Questions and Answers 2020-2021 More
Top 100+ Grammar General English Analogy Test with Answers More