Start DGMGRL configuration:
SQL> alter system set dg_broker_start=true sid='*';
System altered.
[oracle@prod ~]$ 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 sysdg
Password:
Connected as SYSDG.
DGMGRL> CREATE CONFIGURATION 'prod_dg' AS PRIMARY DATABASE IS 'PRIM' CONNECT IDENTIFIER IS PRIM;
Configuration "prod_dg" created with primary database "PRIM"
[oracle@prod ~]$ 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 sysdg
Password:
Connected as SYSDG.
DGMGRL> show configuration
Configuration - prod_dg
Protection Mode: MaxPerformance
Members:
PRIM - Primary database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> add database stand as connect identifier is stand;
Database "stand" added
DGMGRL> show configuration
Configuration - prod_dg
Protection Mode: MaxPerformance
Members:
PRIM - Primary database
stand - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration
Configuration - prod_dg
Protection Mode: MaxPerformance
Members:
PRIM - Primary database
stand - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 12 seconds ago)
DGMGRL> exit
SQL> alter system set dg_broker_start=true sid='*';
System altered.
[oracle@prod ~]$ 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 sysdg
Password:
Connected as SYSDG.
DGMGRL> CREATE CONFIGURATION 'prod_dg' AS PRIMARY DATABASE IS 'PRIM' CONNECT IDENTIFIER IS PRIM;
Configuration "prod_dg" created with primary database "PRIM"
[oracle@prod ~]$ 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 sysdg
Password:
Connected as SYSDG.
DGMGRL> show configuration
Configuration - prod_dg
Protection Mode: MaxPerformance
Members:
PRIM - Primary database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> add database stand as connect identifier is stand;
Database "stand" added
DGMGRL> show configuration
Configuration - prod_dg
Protection Mode: MaxPerformance
Members:
PRIM - Primary database
stand - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration
Configuration - prod_dg
Protection Mode: MaxPerformance
Members:
PRIM - Primary database
stand - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 12 seconds ago)
DGMGRL> exit
No comments:
Post a Comment