Oracle Data Guard interview questions
1.what is the differance between physical standby & logical standby?
2.what are the process involved in Physical standby?
3.what is active data guard?
4.what are the parameters that needed to set in DB level for physical standby?
5.what is the process used for data guard broker?
6.What is the use of standby redolog?
7.What are different protection modes in dataguard?
8.What is snapshot standby database?
9.What is the difference between switchover and failover?
10.What is the process to apply a psu patch in dataguard setup?
11.What is the use of fal_client and fal_server parameter in dataguard environment?
12.What is standby_file_management parameter oracle?
13.few of the archives got deleted and before applying to DG ,how to sync the DG with primary?
14.I added a tempfile on primary database, but the tempfile is not reflecting on standby database despite, the standby_file_management is set to AUTO,why?
15.What are the different types of redo transport services in dataguard.?
16.What are the different services available in Oracle Data Guard?
17.How to check what protection mode of primary database in your Oracle Data Guard?
18.What is the usage of DB_FILE_NAME_CONVERT parameter in Oracle Data Guard setup?
19.How to delay the application of logs to a physical standby?
20.How many standby databases we can create (in 10g/11g)?
21.What are differences between physical, logical, snapshot standby and ADG (or) what are different types of standby databases?
22.What are the parameters we’ve to set in primary/standby for Data Guard?
23.What is the use of fal_server & fal_client, is it mandatory to set these?
24.How to find out backlog of standby?
25.If you didn't have access to the standby database and you wanted 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?
26.How can you recover standby which far behind from primary (or) without archive logs how can we make standby sync?
27.What are advantages offered by Maximum Performance protection mode?
28.What are the benefits of maximum protection mode?
29.How is the maximum protection mode enabled?
30.What are the advantages of maximum availability protection mode?
31.What is the utility of the Redo Transport Service?
32.What do you understand by Broker in this software?
33.What are the tasks that you can perform using Broker?
34.What are the disadvantages that are associated with the Logical Standby systems?
35. What Is Dg Broker?
36. What Is The Difference Between Data Guard And Standby?
37.What Are New Features In 11g Data Guard?
38.What Is the use of Dg_config parameter?
39.What Is Rta (real Time Apply) Mode Mrp?
40.What Is The Difference Between Sync/async, Lgwr/arch, And Affirm/noaffirm ?
41.What Is Staticconnectidentifier Property Used For?
42.Steps To Create Physical Standby Database?
43.what is Fast-Start Failover in DG?
44.Does DG broker needs separate licence?
45.what are the conditions Fast-Start Failover will initiate?
46.what is Dataguard Broker Observer?
47.what is the use of NetTimeout parameter in DG?
48.how to find if real time apply enabled on DG?
49.which DG mode ,primary response will be good?
50.what will happen if standby down on max.protection mode?
51.what is the pre-request for Fast-Start Failover?
52.how to redirect data guard broker log into a file?
53.How to reinstate the old Primary as a Standby after Failover in Oracle DB?
54.what is the view used to check that archive log applied to standby DB?
55.why do we need same password file used for DG setup?
56.how to stop archive shipping without stopping the DB?
57.how to recover/sync standby DB if primary object configured with nologging options?
58.how to move a datafile that created on primary but not created on standby ,even though standby_file=auto?
59.why do we need pwd file need while configuring the DG?
60.why standby db always has more redolog group than primary db?
61.when we configure the standby DB,will that standby DB in archive or no archive mode?
62.what are the steps to start the physical DB for real time apply mode?
63.can we open physical standby DB in read only mode?
64.can the init parameter change will reflect from primary to standby db?
65.How many MRP process would exist on the typical standby DB?
66.when the standby DB open what are the operations allowed?
67.There was a block corruption on Primary db will that cause any problem on standby DB?
68.can you tell me paramater for 1 to many DG configuration ,cascading model?
69.can we cascade physical standby from RAC to another standby?
70.if we give access to DB how to find out physical standby configured or not for the database?
71.what are the pre-request for creating the snapshopt standby database?
72.what are the parameter change needed to configure RAC to standby configuration and NON RAC to standby configuration?
73.what are the various mehtod to cone/create the standby database from Primary database?
1.what is the differance between physical standby & logical standby?
2.what are the process involved in Physical standby?
3.what is active data guard?
4.what are the parameters that needed to set in DB level for physical standby?
5.what is the process used for data guard broker?
6.What is the use of standby redolog?
7.What are different protection modes in dataguard?
8.What is snapshot standby database?
9.What is the difference between switchover and failover?
10.What is the process to apply a psu patch in dataguard setup?
11.What is the use of fal_client and fal_server parameter in dataguard environment?
12.What is standby_file_management parameter oracle?
13.few of the archives got deleted and before applying to DG ,how to sync the DG with primary?
14.I added a tempfile on primary database, but the tempfile is not reflecting on standby database despite, the standby_file_management is set to AUTO,why?
15.What are the different types of redo transport services in dataguard.?
16.What are the different services available in Oracle Data Guard?
17.How to check what protection mode of primary database in your Oracle Data Guard?
18.What is the usage of DB_FILE_NAME_CONVERT parameter in Oracle Data Guard setup?
19.How to delay the application of logs to a physical standby?
20.How many standby databases we can create (in 10g/11g)?
21.What are differences between physical, logical, snapshot standby and ADG (or) what are different types of standby databases?
22.What are the parameters we’ve to set in primary/standby for Data Guard?
23.What is the use of fal_server & fal_client, is it mandatory to set these?
24.How to find out backlog of standby?
25.If you didn't have access to the standby database and you wanted 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?
26.How can you recover standby which far behind from primary (or) without archive logs how can we make standby sync?
27.What are advantages offered by Maximum Performance protection mode?
28.What are the benefits of maximum protection mode?
29.How is the maximum protection mode enabled?
30.What are the advantages of maximum availability protection mode?
31.What is the utility of the Redo Transport Service?
32.What do you understand by Broker in this software?
33.What are the tasks that you can perform using Broker?
34.What are the disadvantages that are associated with the Logical Standby systems?
35. What Is Dg Broker?
36. What Is The Difference Between Data Guard And Standby?
37.What Are New Features In 11g Data Guard?
38.What Is the use of Dg_config parameter?
39.What Is Rta (real Time Apply) Mode Mrp?
40.What Is The Difference Between Sync/async, Lgwr/arch, And Affirm/noaffirm ?
41.What Is Staticconnectidentifier Property Used For?
42.Steps To Create Physical Standby Database?
43.what is Fast-Start Failover in DG?
44.Does DG broker needs separate licence?
45.what are the conditions Fast-Start Failover will initiate?
46.what is Dataguard Broker Observer?
47.what is the use of NetTimeout parameter in DG?
48.how to find if real time apply enabled on DG?
49.which DG mode ,primary response will be good?
50.what will happen if standby down on max.protection mode?
51.what is the pre-request for Fast-Start Failover?
52.how to redirect data guard broker log into a file?
53.How to reinstate the old Primary as a Standby after Failover in Oracle DB?
54.what is the view used to check that archive log applied to standby DB?
55.why do we need same password file used for DG setup?
56.how to stop archive shipping without stopping the DB?
57.how to recover/sync standby DB if primary object configured with nologging options?
58.how to move a datafile that created on primary but not created on standby ,even though standby_file=auto?
59.why do we need pwd file need while configuring the DG?
60.why standby db always has more redolog group than primary db?
61.when we configure the standby DB,will that standby DB in archive or no archive mode?
62.what are the steps to start the physical DB for real time apply mode?
63.can we open physical standby DB in read only mode?
64.can the init parameter change will reflect from primary to standby db?
65.How many MRP process would exist on the typical standby DB?
66.when the standby DB open what are the operations allowed?
67.There was a block corruption on Primary db will that cause any problem on standby DB?
68.can you tell me paramater for 1 to many DG configuration ,cascading model?
69.can we cascade physical standby from RAC to another standby?
70.if we give access to DB how to find out physical standby configured or not for the database?
71.what are the pre-request for creating the snapshopt standby database?
72.what are the parameter change needed to configure RAC to standby configuration and NON RAC to standby configuration?
73.what are the various mehtod to cone/create the standby database from Primary database?
