Thursday, 31 August 2023

Standby OR DR Database!!!

Datagaurd:

1. What are standby database modes? And explain each of them?
2. What are standby database types? And explain each of them?
3. What are standby redologs?
4. Whrere do we create Standby redologs PROD database or Standby database?
5. What happens if we don't create standby redologs?
6. Your Standby/DR database goes out of sync then How you will make it sync?
7. What is the OPEN MODE status of a PDB in Primary DB and Standby DB?
8. Can we create Standby or DR database at CDB level or PDB level?
9. What are the different ways to clone Production Database to lower environment?
10. What are the different ways to build standby database for Production Database?
11. Can we run RMAN backup standby database?
12. Can we enable BCT in standby database?
13. What happens if the FRA is full on standby Database?
14. What happens to my standby database in case if I open my primary database with resetlogs?
15. What happens to my standby database in case if I patch my primary database with lastest CPU?
16. What happens to my standby database if I upgrade my Primary database?
17. What is Active Dataguard database?
18. What is the difference between Active Dataguard and normal Dataguard database?
19. Do we need any seperate lisence for this Active Dataguard? And what are the advantages of this?
20. What is sync and async in standby database?
21. What is affirm and noaffirm in Standby database?
22. What is redo tranfer in standby database and what is the difference between ARCH and LGWR redo tranfer mode in standby database?
23. What is LNS process used for?
24. What RFS process used for?
25. What is MRP process used for?
26. Why do we need Production database password file on standby side?
27. Can we recreate new password file on standby side with different password than production database?
28. What is LSP process in standby?
29. What is LCR in standby database?
30. Why we need to enable force logging on Production database to build standby database?
31. Is archive log mode mandatory to build standby database?
32. Is switchover and failover supported in snapshot standby database?
33. Is switchover and failover supported in logical standby database?
34. What happens on standby side if I create Restore Point on Primary database?
35. What happens to standby database in case if I flashback production database to Restore Point?
36. What is switch over and failover?

No comments:

Post a Comment

How can you ensure Seamless Data recovery with cloud disaster recovery solution??

 1. Plan Ahead Begin with conducting a thorough risk assessment to identify potential threats to your data and applications. based on the as...