HOME > > Difference between Physical and Logical Standby Database

Difference between Physical and Logical Standby Database

Anup - Thursday, January 21, 2010
Physical Standby Database:
A physical standby database is a exact copy of the primary database. Oracle uses the primary database archive log file to recover the physical standby database.

We can open a physical standby database in read only mode, but at the time of read only mode, the received logs will not be applied.

When the logs are applied, the database is not accessible.

Logical Standby Database:
Logical Standby database are opened in read/write mode, even while they are is applied mode. That is, they can be used to generate reports and the like. It is indeed a fully functional database.
Kavita said...

Hi,
Sir i almost visit your blog for asm and dataguard .....Sir as in case of asm u have mentioned its working ,background process,concepts ,
Architecture ......Sir i know u are quite busy but when get some time pls post on dataguard the same way theory(conecpt,Architecture,process)

Thanks in Advance
Best Regards
Kavita

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me