server6[db1]_orwccp1> dgmgrl
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/*****@db_p2
Connected as SYSDBA.
DGMGRL> show configuration
Configuration - db_dg_config
Protection Mode: MaxPerformance
Members:
db_p2 - Primary database
db_p1 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 35 seconds ago)
DGMGRL> validate database db_p2
Database Role: Primary database
Ready for Switchover: Yes
DGMGRL> validate database db_p1
Database Role: Physical standby database
Primary Database: db_p2
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
DGMGRL> add database dbDR as connect identifier is "dbdr" maintained as physical;
Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set
Failed.
DGMGRL> disable configuration;
Disabled.
DGMGRL> remove configuration;
Removed configuration
DGMGRL>
sqlplus as sysdba (Do This in Primary And Standby)
SQL> alter system set dg_broker_start=false scope=both sid='*';
System altered.
SQL> alter system set dg_broker_start=true scope=both sid='*';
System altered.
SQL> alter system set log_archive_dest_2='' scope=BOTH sid='*';
System altered.
SQL> alter system set log_archive_dest_3='' scope=BOTH sid='*';
System altered.
dgmgrl
server6[db1]_orwccp1> dgmgrl
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/*******@db_p2
Connected as SYSDBA.
DGMGRL> CREATE CONFIGURATION 'db_dg_config' AS PRIMARY DATABASE IS 'db_p2' CONNECT IDENTIFIER IS db_p2;
Configuration "db_dg_config" created with primary database "db_p2"
DGMGRL> add database db_P1 as connect identifier is "db_p1" maintained as physical;
Database "db_p1" added
DGMGRL> add database dbDR as connect identifier is "dbdr" maintained as physical;
Database "dbdr" added
Enabled.
DGMGRL> disable configuration;
Disabled.
DGMGRL> enable configuration;
Enabled.
DGMGRL>
DGMGRL>
DGMGRL> show configuration
Configuration - db_dg_config
Protection Mode: MaxPerformance
Members:
db_p2 - Primary database
db_p1 - Physical standby database
dbdr - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 14 seconds ago)
DGMGRL> validate database db_p2
Database Role: Primary database
Ready for Switchover: Yes
DGMGRL> validate database db_p1
Database Role: Physical standby database
Primary Database: db_p2
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
DGMGRL>
No comments:
Post a Comment