dataguard安装记录.doc

主库部分#主库安装instance(archive log mode)，备库只安装软件SQLALTER DATABASE FORCE LOGGING;#创建密码文件,如果有就不用创建了oracleprimary dbs$ orapwd file=orapw$ORACLE_SID password=oracle entries=5#添加主库STANDBY LOGFILE 文件ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 (/oracle/oradata/sunrac/redo04.log) SIZE 50M;ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 (/oracle/oradata/sunrac/redo05.log) SIZE 50M;ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 (/oracle/oradata/sunrac/redo06.log) SIZE 50M;ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 (/oracle/oradata/sunrac/redo07.log) SIZE 50M;#主库生成pfile SQLcreate pfile from spfile;#主库修改pfile文件log_archive_dest_1=LOCATION=/oracle/archivelog_archive_dest_state_1=enablelog_archive_dest_2=SERVICE=standbylog_archive_dest_state_2=enable#log_archive_start=true /ORA-32004: obsolete and/or deprecated parameter(s) specifiedfal_server=standbyfal_client=primarydb_unique_name=primarySQLcreate spfile from pfile;#主库中创建备库control fileSQLshutdown immediateSQLstartup mount;SQLalter database create standby controlfile as /oracle/oradata/sunrac/standby.ctl;SQLalter database open;SQLshutdown immediate#copy 主库的数据到备库中1.oradata/*(data file,control file, redo file)scp -r /oracle/oradata standby:/oracle/oradata2.admin/*(bdump,cdump,adump)scp -r /oracle/admin standby:/oracle3.dbs/*(listener.ora initprimary.ora)scp -r /oracle/db/dbs/initsunrac.ora standby:/oracle/db/dbsscp -r /oracle/db/dbs/orapwsunrac standby:/oracle/db/dbs#备库中删除主库拷贝过来的控制文件#将之前生成的standby.ctl 复制成三份控制文件保存cd /oracle/oradata/sunraccp standby.ctl control01.ctl;cp standby.ctl control02.ctl;cp standby.ctl control03.ctl;=备库部分#修改备库的pfile文件log_archive_dest_1=LOCATION=/u01/archivelog_archive_dest_state_1=enablelog_archive_dest_2=SERVICE=primarylog_archive_dest_state_2=enablelog_archive_start=true#此处的fal_server,fal_client的值是tnsnames.ora文件里面的值fal_server=primaryfal_client=standbydb_unique_name=standby#另外创建备库logfile 组#创建备库的logfile 组是根据主库中logfile group的数量决定的。#(maximum number of logfiles for each thread + 1) * maximum number of threadsALTER DATABASE ADD STANDBY LOGFILE GROUP 4 (/oracle/oradata/sunrac/redo04.log) SIZE 50M;ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 (/oracle/oradata/sunrac/redo05.log) SIZE 50M;ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 (/oracle/oradata/sunrac/redo06.log) SIZE 50M;ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 (/oracle/oradata/sunrac/redo07.log) SIZE 50M;测试#启动主库#启动备库listenerSQLcreate spfile from pfile;SQLstartup nomount;SQLalter database mount standby database;SQLselect name,database_role from v$database;NAME DATABASE_ROLE- -PRIMARY PHYSICAL STANDBYSQLalter database recover managed standby database disconnect from session;SQLselect sequence#,first_time,next_time from v$archived_log order by sequence#;SQLselect sequence#,applied from v$archived_log order by sequence#;#primary databaselistener.ora#SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/db) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = primary) (ORACLE_HOME = /oracle/db) (SERVICE_NAME = sunrac) ) )LISTENER01 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primary)(PORT = 1521) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0) ) )LISTENER02 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0) ) )#primary databasetnsnames.ora#PRIMARY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.21)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = sunrac) ) )STANDBY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.22)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = sunrac) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )#standby databaselistener.ora#SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/db) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = primary) (ORACLE_HOME = /oracle/db) (SERVICE_NAME = sunrac) ) )LISTENER02 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0) ) )#primary databasetnsnames.ora#PRIMARY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = primary) ) )STANDBY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 1