配置data guard物理备库(6)

FAL_SERVER=lsnode2 改成 FAL_SERVER=lsnode1 FAL_CLIENT=lsnode1 改成 FAL_CLIENT=lsnode2

[root@node2 dbs]# su - oracle

[oracle@node2 ~]$ lsnrctl start (主库也要开起来)

####################### 在主库,让主库正常启动

#######################

[root@node2 dbs]# su - oracle [oracle@node2 ~]$ lsnrctl start [oracle@node1 ~]$ sqlplus /nolog SQL> conn /as sysdba Connected to an idle instance. SQL> startup

ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes Conflicting重复 conflicting冲突

是因为这行注意不要写错。我把valid写成vaild

改完就可以 SQL> startup

ORACLE instance started.

Total System Global Area 218103808 bytes ......

Database mounted.

Database opened. 在备库

[oracle@node2 /]$ sqlplus system/oracle@lsnode1

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 23 16:17:46 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR:

ORA-12514: TNS:listener does not currently know of service requested in connect http://space.itpub.net/7589639/viewspace-705848

出错原因是由于，在修改init$ORACLE_SID.ora文件时，在主库里面新添加了一项db_unique_name=uqn_node1； 备库上新添加一项db_unique_name=uqn_node2

在配置监听文件和客户端tnsnames.ora时，就要修改GLOBAL_DBNAME成相应的uqn_node2或uqn_node2 [oracle@dg01 admin]$ cat listener.ora (备库也要加红色那串,uqn_node1改uqn_node2)

SID_LIST_LISTENER = (SID_LIST = (SID_DESC =

(SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/oracle) (PROGRAM = extproc) )

(SID_DESC =

(GLOBAL_DBNAME =uqn_node1) (ORACLE_HOME =/u01/oracle) (SID_NAME = dgdemo) ) )

LISTENER =

(DESCRIPTION_LIST = (DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) )

[oracle@dg01 admin]$ cat tnsnames.ora 改(SERVICE_NAME = uqn_node2)这行 LSNODE2 = (DESCRIPTION = (ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.254)(PORT = 1521)) )

(CONNECT_DATA =

(SERVICE_NAME = uqn_node2) ) ) LSNODE1 = (DESCRIPTION = (ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.253)(PORT = 1521)) )

(CONNECT_DATA =

(SERVICE_NAME = uqn_node1) ) )

EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) )

(CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )

改完错误再试就可以了

[oracle@node2 ~]$ sqlplus system/oracle@lsnode1

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 23 17:43:22 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

----------------------------------------------------------------------------------------- 两台电脑都重启了

[oracle@node2 ~]$ sqlplus system/oracle@lsnode1 在node2连lsnode1

ERROR:

ORA-12541: TNS:no listener (这错误是lsnode1的lsnrctl没有启动) [oracle@node1 ~]$ lsnrctl start 再运行就可以

-----------------------------------------------------------------------------------------------

到这时，根据主库initdgdemo.ora这文件有设了log_archive_dest_2='SERVICE=lsnode2 ，主库会边工作一边把redolog传到lsnode2 在主库

SQL> show parameter log_archive;

NAME TYPE VALUE ------------------------------------ ----------- ------------------------------

log_archive_config string DG_CONFIG=(uqn_node1,uqn_node2 ) log_archive_dest string

log_archive_dest_1 string LOCATION=/u01/oradata/arch log_archive_dest_10 string

log_archive_dest_2 string SERVICE=lsnode2 valid_for=(ONL

INE_LOGFILES,PRIMARY_ROLE) db_ unique_name=uqn_node2 log_archive_dest_3 string log_archive_dest_4 string log_archive_dest_5 string

NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_6 string log_archive_dest_7 string log_archive_dest_8 string log_archive_dest_9 string

log_archive_dest_state_1 string ENABLE log_archive_dest_state_10 string enable log_archive_dest_state_2 string ENABLE ###########################################

在备库操作,启动备库到mount

############################################### [oracle@node2 ~]$ sqlplus /nolog SQL> conn / as sysdba