Apr 11, 2013
Data guard Interview Question and Answers
2.1K

Data guard Interview Question and Answers

Data guard Interview Question and Answers: Data guard Interview Question and Answers 1. Can Oracle’s Data Guard be used on Standard Edition, and if so how? How can you test that the standby database is in sync? In Oracle Standard Edition, it is possible to be a standby database, and...
Feb 25, 2012
Difference between Physical Standby and Logical Standby
3.5K

Difference between Physical Standby and Logical Standby

Physical standby: ============ 1. Physical standby schema matches exactly the source database. 2. Archived redo logs and FTP’ed directly to the standby database which is always running in “recover” mode. Upon arrival, the archived redo logs are applied directly to the standby database. Logical standby: =========== 1. Logical standby database...