Tuesday, June 10, 2014

Register the database into dataguard:

On primary database only

dgmgrl

connect sys/<password>

show configuration;
================================
If it is not configured then
DGMGRL> show configuration
Error: ORA-16532: Data Guard broker configuration does not exist

Configuration details cannot be determined by DGMGRL

Otherwise:

DGMGRL> show configuration

Configuration
  Name:                abcprod
  Enabled:             YES
  Protection Mode:     MaxPerformance
  Databases:
    fc_abcprod - Primary database
    dr_abcprod - Physical standby database

Fast-Start Failover: DISABLED

Current status for "abcprod":
Warning: ORA-16608: one or more databases have warnings

On DR site:
DGMGRL> show configuration

Configuration
  Name:                abcprod
  Enabled:             YES
  Protection Mode:     MaxPerformance
  Databases:
    fc_abcprod - Primary database
    dr_abcprod - Physical standby database

Fast-Start Failover: DISABLED

Current status for "abcprod":
Warning: ORA-16608: one or more databases have warnings

===================================
Create new dataguard configuration:

Create configuration ABCPROD as primary database is FC_ABCPROD connect identifier is FC_ABCPROD;

add database DR_ABCPROD as connect identifier is  DR_ABCPROD maintained as physical;


DGMGRL> enable configuration;

DGMGRL> show configuration

No comments:

Post a Comment

Convert snapshot standby database to Physical standby database: Dataguard 11gR2

Step 1 SQL> shutdown immediate; Step 2 SQL> startup nomount Step 3 SQL> alter database mount; Step 4 SQL>  ALTER DATABASE CONV...