Register the database into dataguard:
DGMGRL> show configuration
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;
No comments:
Post a Comment