Oracle Data Guard: Difference between revisions

Revision as of 00:58, 21 February 2015

Revision as of 00:18, 17 March 2015

Line 26:

=== Physical standby (Redo Apply) ===

A physical standby database replicates the exact contents of its primary database across the [[Oracle Net]] [[network layer]]. While the relative physical storage locations can differ, the data in the database will be exactly the same as in the primary database. ItPhysical standby databases can function either in managed-recovery mode or in read-only mode, but not in both modes at the same time (unless the databases are at Oracle Database 11.1 or higher and the Active Data Guard option is licensed (See- see below).It usesThe thestandby makes use of "Redo applyApply" technology.

Physical standby databases have the same DBID identifiers as their primary equivalents.<ref>

{{cite book

|last1= Tchoko

|first1= Floribert

|title= Oracle: Protect Your Data

|url= https://books.google.com/books?id=1Py_soo_3pkC

|publisher= AuthorHouse

|publication-date= 2012

|page= 128

|isbn= 9781467896214

|accessdate= 2015-03-17

|quote= [...] a new identifier DBID is assigned to the new database unless the database is a standby database. In this case it retains the same DBID as the source database.

}}

</ref>

=== Logical standby (SQL Apply) ===