InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are 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 – 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. Physical standby – in mount state, MRP will apply archives ADG – 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. |
|