Data Guard

Set Oraclesid=oms
sqlplus /nolog
conn sys/sys as sysdba
17:00:23 SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

Elapsed: 00:00:00.01
17:00:32 SQL> alter system set DG_BROKER_START = true;
(both on primary and standby)

System altered.

Elapsed: 00:00:01.45
17:00:35 SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

C:\Documents and Settings\oracle.dba>dgmgrl
DGMGRL for 32-bit Windows: Version 10.2.0.1.0 - Production

Copyright (c) 2000, 2005, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/sys
Connected.

DGMGRL> create configuration 'omssty' as primary database is 'oms' connect identifier is oms;
Configuration "omssty" created with primary database "OMS"

DGMGRL> add database 'testdb' as connect identifier is testdb maintained as physical;
Database "testdb" added

DGMGRL> enable configuration
Enabled.

DGMGRL> show configuration;

Configuration
Name: omssty
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
OMS - Primary database
testdb - Physical standby database

Current status for "omssty":

DGMGRL> REMOVE CONFIGURATION; (For Deleting the configuration)

DGMGRL> SHOW DATABASE VERBOSE OMS;

DGMGRL> SHOW DATABASE VERBOSE testdb;