Physical standby or Logical standby

[former_member199632]

Hello,
How to identify whether it is physical standby or logical standby database;

I want to know what the Standby DB using in our environment.

Is there a way to identify by querying the SB database, either it is Logical / Physical

According to the definitions ;

A physical standby database : has on-disk database structures that are identical to the primary database on a block-for-block

basis, and is updated using Oracle media recovery.

A logical standby database is an independent database that contains the same data as the primary database. It is updated using SQL statements,

and has the advantage that it can be used for recovery and for other tasks such as reporting and queries at the same time.

I have checked our Primary DB and Standby database structures.

Mostly It looks like same. (The way the datafiles,arch files,control files located)

(Pl check 2 images attached.)

Here are Standby DB settings;

No dataguard implemented.

Database log mode - Archive Mode

Automatic archival - Enabled

Status - MOUNTED

regards,

Zerandib

[Former Member · Accepted solution]

Hi Zerandib,

Execute following query, in order to identify standby database role;

SQL> select database_role from v$database;

Best regards,

Orkun Gedik