SERVER_2008_64_oracle_11g DG搭建笔记

《SERVER_2008_64_oracle_11g DG搭建笔记》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、oracleDG主库、备库安装路劲一样C:UsersAdministrator>sqlplus/nologSQL>conn/assysdba已连接。#关闭数据库，将数据库修改为日志记录模式SQL>shutdownimmediate;ORACLE例程已经关闭。SQL>startupmount;数据库装载完毕。SQL>alterdatabasearchivelog;数据库已更改。SQL>alterdatabaseforcelogging;数据库已更改。#添加数据库日子记录文件SQL>selectgroup#,m

2、emberfromv$logfileorderbygroup#;GROUP#----------MEMBER1D:ORACLEORADATADGREDO01.LOG2D:ORACLEORADATADGREDO02.LOG3D:ORACLEORADATADGREDO03.LOGSQL>alterdatabaseaddstandbylogfilegroup4('D:APPADMINISTRATORORADATAYKTCMSSTAN04.LOG')size50m;SQL>alterd

3、atabaseaddstandbylogfilegroup5('D:APPADMINISTRATORORADATAYKTCMSSTAN05.LOG')size50m;SQL>alterdatabaseaddstandbylogfilegroup6('D:APPADMINISTRATORORADATAYKTCMSSTAN06.LOG')size50m;数据库已更改。#创建控制文件SQL>alterdatabasecreatestandbycontrolfileas'D:APPADMINIS

4、TRATORORADATAYKTCMSstandby.ctl';数据库已更改。#创建参数文件SQL>createpfile='d:initora.ora'fromspfile;文件已创建。#编辑参数文件，initora.ora添加DG参数。添加内容如下。#DG_configdb_unique_name='primary'archive_lag_target=1800FAL_SERVER=primaryFAL_CLIENT=standbylog_archive_config='DG_CONFIG=(pri

5、mary,standby)'log_archive_dest_1='LOCATION=D:logVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=primary'LOG_ARCHIVE_DEST_2='SERVICE=standbyarchASYNCVALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=standby'LOG_ARCHIVE_DEST_STATE_1=ENABLELOG_ARCHIVE_D

6、EST_STATE_2=ENABLE#修改后，通过参数文件启动主库SQL>shutdownimmediate;ORA-01109:数据库未打开已经卸载数据库。ORACLE例程已经关闭。SQL>startuppfile='d:initora.ora'nomount;ORACLE例程已经启动。TotalSystemGlobalArea263049216bytesFixedSize2174840bytesVariableSize230686856bytesDatabaseBuffers25165824bytesRe

7、doBuffers5021696bytesSQL>createspfilefrompfile='d:initora.ora';文件已创建。SQL>shutdownimmediate;ORA-01507:??????ORACLE例程已经关闭。SQL>startup;ORACLE例程已经启动。TotalSystemGlobalArea263049216bytesFixedSize2174840bytesVariableSize230686856bytesDatabaseBuffers25165824bytesRe

8、doBuffers5021696bytes数据库装载完毕。数据库已经打开。#创建密码文件,文件在D:appAdministratorproduct11.2.0dbhome_1databasePWD(DBname).ora#如果不存在就用CMD执行命令创建,这个备库会用到。C:>orapwdfile=D:appAdministratorproduct11.2.0