eygle.com - 留言簿 - 回复留言

eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com

返回留言簿

回复留言

留言ID:

留言原文:

To: 盖老师
　　您好!
oracle 版本:11.2.0.3RAC备库,单实例的主库.
DGMGRL> convert database prod to snapshot standby;
Converting database "prod" to a Snapshot Standby database, please wait...
Database "prod" converted successfully
DGMGRL> convert database prod to physical standby;
Converting database "prod" to a Physical Standby database, please wait...
Starting instance "prod1"...
ORACLE instance started.
Database mounted.
Continuing to convert database "prod" ...
Error: ORA-16541: database is not enabled

Failed.
Failed to convert database "prod"
主库tnsnames.ora(rac备库部分的)
PROD =
(DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
 (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
(LOAD_BALANCE = OFF)
(FAILOVER = ON)
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = prod_DGMGRL)
 (FAILOVER_MODE =
 (TYPE = SELECT)
 (METHOD = BASIC)
 (RETRIES = 0)
 (DELAY = 1)
 )
 )
)

From: eyglefans
2013.12.04 10:14