1、/oracle/app/oracle/ORACLE_HOME$ORACLE_BASE/product/11.2.0/db_1ORACLE_SIDdbtest闪回区4G归档开启2主数据库配置2.1设置数据库强制归档sqlplus / as sysdbaSQL ALTER DATABASE FORCE LOGGING; select force_logging from v$database;FOR-YES2.2添加STANDBY日志文件alter database add standby logfile group 4 (/oradata/dbtest/redo04.log) size 50m;
2、alter database add standby logfile group 5 (/oradata/dbtest/redo05.logalter database add standby logfile group 6 (/oradata/dbtest/redo06.logalter database add standby logfile group 7 (/oradata/dbtest/redo07.log select * from v$logfile order by 1; 2.3修改参数文件2.3.1生成pfilecreate pfile from spfile;shutdow
3、n immediate;2.3.2修改pfilevi $ORACLE_HOME/dbs/initdbtest.ora在最后添加如下内容:*.db_unique_name=dbtest1*.fal_server=dbtest2*.fal_client=dbtest1*.standby_file_management=auto*.db_file_name_convert=/oradata/dbtest/,*.log_file_name_convert=*.log_archive_config=dg_config=(dbtest1,dbtest2)*.log_archive_dest_2=servi
4、ce=dbtest2 LGWR SYNC AFFIRM valid_for=(online_logfiles,primary_role) db_unique_name=dbtest2*.log_archive_dest_state_2=ENABLE2.3.3生成spfile shutdown immediateoracledbserver01 $ cd $ORACLE_HOME/dbsoracledbserver01 dbs$ mv spfilejkfwdb.ora spfilejkfwdb.ora.bak startup nomount create spfile from pfile;Fi
5、le created. show parameter uniq shutdown immediate; startup show parameter spfile2.4修改监听配置文件2.5修改TNS配置文件oracledg1 admin$ cat tnsnames.ora# tnsnames.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.DBTEST = (DES
6、CRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.132.3)(PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dbtest1) )DBTEST1 =DBTEST2 = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.132.4)(PORT = 1521) (SERVICE_NAME = dbtest2)EXTPROC_CONNECTION_DATA = (ADDRESS_LIST = (ADDRESS = (PRO
7、TOCOL = IPC)(KEY = EXTPROC2) (SID = PLSExtProc) (PRESENTATION = RO)2.6重启监听服务lsnrctl stoplsnrctl start2.7配置最大可用模式 alter database set standby database to maximize availability;Database altered. exit2.8备份数据库oracledg1 admin$ rman target /RMAN backup database plus archivelog; backup current controlfile f
8、or standby;备份完成后会在闪回区生产备份文件3备数据库配置3.1建立相应的文件目录包括dump文件目录,闪回区,数据文件目录,可以通过 show parameter dest命令查看mkdir -p /oracle/app/oracle/admin/dbtest/adumpmkdir -p /oracle/app/oracle/admin/dbtest/dpdumpmkdir -p /oracle/app/oracle/diag/rdbms/dbtest1/dbtest/tracemkdir -p /oracle/app/oracle/diag/rdbms/dbtest1/dbtes
9、t/cdumpmkdir -p /oracle/app/oracle/flash_recovery_areamkdir -p /oradata/dbtest3.2从主数据库服务器上拷贝文件注意:下面命令在主数据库上执行3.2.1拷贝闪回区内容oracledg1 admin$ cd /oracle/app/oracle/flash_recovery_areascp -r ./* 192.168.132.4:/oracle/app/oracle/flash_recovery_area/3.2.2拷贝参数文件oracledg1 flash_recovery_area$ cd $ORACLE_HOME
10、/dbsscp ./* 192.168.132.4:/oracle/app/oracle/product/11.2.0/db_1/dbs/3.2.3拷贝密码文件3.2.4拷贝监听文件和tns文件oracledg1 dbs$ cd ./network/admin/scp *.ora 192.168.132.4:/oracle/app/oracle/product/11.2.0/db_1/network/admin/3.3修改监听配置文件修改ip地址3.4修改TNS配置文件3.5重启监听服务3.6修改参数文件并启动数据库到nomountCd $ORACLE_HOME/dbsCp initdbtes
11、t.ora initdbtest.ora.bak去掉 上面添加的部分即:3.7恢复数据库oracledg2 admin$ rman target sys/funo1234dbtest1 auxiliary / duplicate target database for standby nofilenamecheck;3.8修改参数文件oracledg2 admin$ sqlplus / as sysdba添加如下内容*.db_unique_name=dbtest23.9启动数据库 startup nomount; alter database mount standby database; alter database recover managed standby database using current logfile disconnect from session;3.10验证主库备库均执行如下命令: archive log list;主库备库如果最后一行数字相同,说明配置成功3.11切换到只读模式 alter database recover managed standby database cancel; alter database open read only;3.12切换到同步模式(不需要停库)
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1