How do I know if my database is primary or standby?

How do I know if my DB is standby or primary?

You can use the DGMGRL show configuration and show database database_name commands to confirm the Data Guard Standby database configuration before enabling a standby database. Here is how you enable your primary and standby databases using the DGMGRL command: DGMGRL> enable configuration; Enabled.

How do I check standby database?

Following command will help to check the Standby is sync with Primary Database in Oracle Dataguard Environment. select thread#, max(sequence#) "Last Standby Seq Applied" from v$archived_log val, v$database vdb where val. resetlogs_change# = vdb. resetlogs_change# and val.

How do I change my database from primary to standby?

To change the current primary database to a physical standby database role, use the following SQL statement on the primary database: SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY; After this statement completes, the primary database is converted into a standby database.

How do you check database mode?

Checking ARCHIVELOG mode status1Log in as OS user oracle and enter the following commands: $ export ORACLE_SID=<MYDB> where <MYDB> is the name of the database $ sqlplus /nolog SQL> connect / as sysdba.2To check the ARCHIVELOG mode status, enter the following SQL command: SQL> archive log list;