data guard 操作指南(2)

*.log_archive_config='dg_config=(whgjj,standby)'

*.log_archive_dest_1='location=G:\\app\\Administrator\\oradata\\whgjj\\archivelog valid_for=(all_logfiles,all_roles) db_unique_name=whgjj'

*.log_archive_dest_2='service=standby lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=standby'

*.log_archive_dest_3='LOCATION=G:\\app\\Administrator\\oradata\\whgjj\\standbylog valid_for=(standby_logfile,standby_role) db_unique_name=whgjj' *.log_archive_dest_state_1='enable' *.log_archive_dest_state_2='enable' *.log_archive_format='%t_%s_%r.arc'

关闭数据库，在用initorcl.ora重启，并创建spfile文件

SQL>create spfile from pfile='$ORACLE_HOME/database/initorcl.ora'

6.文件拷贝

.拷贝参数文件，密码文件到备库上

initorcl.ora参数文件,PWDorcl.ora密码文件考到$ORACLE_HOME/database下，

9.启动主数据库

SQL>shutdown immediate; SQL>startup

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

三、备库的配置：

1.用oradim工具创建备库orcl实例

oradim.exe -new -sid WHGJJ -startmode m 2.创建备库存放数据文件和后台跟踪目录 $ORACLE_BASE\\ORADATA\\whgjj $ORACLE_BASE\\admin\\orcl

$ORACLE_BASE\\admin\\orcl\\bdump 3.在备库创建监听和配置tnsnams.ora listener.ora配置如下: (SID_LIST = (SID_DESC =

(GLOBAL_DBNAME = whgjj)

(ORACLE_HOME =E:\\app\\Administrator\\product\\11.2.0\\dbhome_1) (SID_NAME = whgjj)

)

(SID_DESC =

(SID_NAME = CLRExtProc)

(ORACLE_HOME = E:\\app\\Administrator\\product\\11.2.0\\dbhome_1) (PROGRAM = extproc) (ENVS =

\11.dll\

) )

LISTENER =

(DESCRIPTION_LIST = (DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

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

tnsnames.ora配置如下: WHGJJ =

(DESCRIPTION = (ADDRESS_LIST =

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

(CONNECT_DATA = (SERVICE_NAME = whgjj) ) )

STANDBY = (DESCRIPTION = (ADDRESS_LIST =

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

(CONNECT_DATA = (SERVICE_NAME = whgjj) )

)

5.测试主备之间网络连通 Whgjj :

C:>lsnrctl start C:>tnsping standby standby：

C:>lsnrctl start C:>tnsping primary

6.配置备库初始化参数

编辑$ORACLE_HOME/database目录下的initorcl.ora添加以下内容

*.db_name='whgjj'

*.db_unique_name='standby' *.fal_client='standby' *.fal_server='whgjj'

*.log_archive_config='dg_config=(whgjj,standby)'

*.log_archive_dest_1='location=E:\\app\\Administrator\\oradata\\whgjj\\archivelog valid_for=(all_logfiles,all_roles) db_unique_name=standby'

*.log_archive_dest_2='service=whgjj lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=whgjj'

*.log_archive_dest_3='LOCATION=E:\\app\\Administrator\\oradata\\whgjj\\standbylog valid_for=(standby_logfile,standby_role) db_unique_name=standby' *.log_archive_dest_state_1='enable' *.log_archive_dest_state_2='enable'

*.log_file_name_convert='G:\\app\\Administrator\\oradata\\whgjj','E:\\app\\Administrator\\oradata\\whgjj'

*.db_file_name_convert='G:\\app\\Administrator\\oradata\\whgjj','E:\\app\\Administrator\\oradata\\whgjj'