oracle Data guard 都安装好了,启动顺序是
先启动备库
SQL> startup nomount;
SQL>alter database mount standby database ;
[color=blue]SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ERROR at line 1:
ORA-16136: Managed Standby Recovery not active
出错后打开备库 alert_primarydb.log
Errors in file /u01/oracle/admin/primarydb/bdump/primarydb_arc1_9794.trc:
ORA-12541: TNS:no listener
PING[ARC1]: Heartbeat failed to connect to standby '172.16.41.162'. Error is 12541.[/color]
【说明】
[primary database]
IP:172.16.41.162
ORACLE_SID=primarydb
DB_UNIQUE_NAME=primarydb
[physical standby database]
IP:172.16.41.238
ORACLE_SID=primarydb
DB_UNIQUE_NANEM=primarydb
我是从主库中拷贝listener.ora 和tnsnames.ora文件到备库中的。
内容如下
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = primarydb)
(GLOBAL_DBNAME = primarydb)
(ORACLE_HOME = /u01/oracle)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(Host = 172.16.41.162)(PORT = 1521))
)
)
Generated by Oracle configuration tools.
PRIMARYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.41.162)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = primarydb)
)
)
STANDBYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.41.238)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = primarydb)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
请达人们指教一下,这个是什么错啊。