InterviewSolution
| 1. |
Snapshot Standby Database (updatable Snapshot For Testing)? |
|
Answer» A snapshot standby DATABASE is a fully UPDATABLE standby database that is created by converting a physical standby database into a snapshot standby database. Like a physical or logical standby database, a snapshot standby database receives and ARCHIVES redo DATA from a primary database. Unlike a physical or logical standby database, a snapshot standby database does not apply the redo data that it receives. The redo data RECEIVED by a snapshot standby database is not applied until the snapshot standby is converted back into a physical standby database, after first discarding any local updates made to the snapshot standby database. A snapshot standby database is a fully updatable standby database that is created by converting a physical standby database into a snapshot standby database. Like a physical or logical standby database, a snapshot standby database receives and archives redo data from a primary database. Unlike a physical or logical standby database, a snapshot standby database does not apply the redo data that it receives. The redo data received by a snapshot standby database is not applied until the snapshot standby is converted back into a physical standby database, after first discarding any local updates made to the snapshot standby database. |
|