加关键词的网站,1个百度指数代表多少搜索,wordpress和蝉知,it外包公司值得去吗本文记录了物理dg的第二种安装方法#xff0c;使用rman duplicate from active database#xff0c;不需要做备份文件。准备工作#xff1a;1.两台虚拟机#xff0c;主机名#xff1a;n1, n2#xff0c;操作系统#xff1a;centos6.7#xff0c;建好信任关系2.oracle d…本文记录了物理dg的第二种安装方法使用rman duplicate from active database不需要做备份文件。准备工作1.两台虚拟机主机名n1, n2操作系统centos6.7建好信任关系2.oracle database 11.2.0.4软件已装好3.节点1(n1)数据库创建好db_nameorcldb_unique_namedg1归档模式(归档目录/oracle/arc/)4.变量n1变量 export ORACLE_SIDdg1 export ORACLE_BASE/oracle/db export ORACLE_HOME$ORACLE_BASE/ora11g export NLS_LANGAMERICAN_AMERICA.AL32UTF8 export LD_LIBRARY_PATH$LD_LIBRARY_PATH:$ORACLE_HOME/lib export PATH$PATH:$ORACLE_HOME/bin n2变量 export ORACLE_SIDdg2 export ORACLE_BASE/oracle/db export ORACLE_HOME$ORACLE_BASE/ora11g export NLS_LANGAMERICAN_AMERICA.AL32UTF8 export LD_LIBRARY_PATH$LD_LIBRARY_PATH:$ORACLE_HOME/lib export PATH$PATH:$ORACLE_HOME/bin5.tns文件内容($ORACLE_BASE/network/admin)n1、n2都需要# tnsnames.ora Network Configuration File: /oracle/db/ora11g/network/admin/tnsnames.ora # Generated by Oracle configuration tools. dg1 (DESCRIPTION (ADDRESS_LIST (ADDRESS (PROTOCOL TCP)(HOST n1)(PORT 1521)) ) (CONNECT_DATA (SERVICE_NAME dg1) ) ) dg2 (DESCRIPTION (ADDRESS_LIST (ADDRESS (PROTOCOL TCP)(HOST n2)(PORT 1521)) ) (CONNECT_DATA (SERVICE_NAME dg2) ) )6.静态listener($ORACLE_BASE/network/admin/listener.ora)主备库最好都设置n1# listener.ora Network Configuration File: /oracle/db/ora11g/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER (SID_LIST (SID_DESC (GLOBAL_DBNAME dg1) (ORACLE_HOME /oracle/db/ora11g) (SID_NAME dg1) ) ) LISTENER (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST n1)(PORT 1521)) )n2# listener.ora Network Configuration File: /oracle/db/ora11g/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER (SID_LIST (SID_DESC (GLOBAL_DBNAME dg2) (ORACLE_HOME /oracle/db/ora11g) (SID_NAME dg2) ) ) LISTENER (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST n2)(PORT 1521)) )1.主库创建pfilecreate pfile/tmp/init.ora from spfile;2.将上一步生成的pfile及主库的 密码文件 scp 到备库(注意备库上 密码文件 的名称)scp /tmp/init.ora oraclen2:/tmp scp $ORACLE_HOME/dbs/orapwdg1 oraclen2:$ORACLE_HOME/dbs/orapwdg23.备库创建spfilecreate spfile from pfile/tmp/init.ora;4.备库启动到nomountstartup nomount5.备库修改参数并重启到nomountalter system set db_unique_namedg2 scopespfile; alter system set log_archive_configDG_CONFIG(dg1,dg2) scopespfile; alter system set log_archive_dest_1LOCATION/oracle/arc/ VALID_FOR(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAMEdg2 scopespfile; alter system set fal_serverdg1 scopespfile; alter system set fal_clientdg2 scopespfile; alter system set standby_file_managementauto scopespfile; alter system set service_namesdg2 scopespfile;startup nomount force6.备库执行rman(rman target sys/sysdg1 auxiliary sys/sysdg2)duplicate target database for standby nofilenamecheck from active database;7.备库增加standby日志(主库也需要加如果在duplicate之前主库已经添加了standby这时备库可能需要删除再重建standby)alter database add standby logfile group 4 (/oracle/db/oradata/orcl/sredo41.log,/oracle/db/oradata/orcl/sredo42.log) size 50M; alter database add standby logfile group 5 (/oracle/db/oradata/orcl/sredo51.log,/oracle/db/oradata/orcl/sredo52.log) size 50M; alter database add standby logfile group 6 (/oracle/db/oradata/orcl/sredo61.log,/oracle/db/oradata/orcl/sredo62.log) size 50M;8.dg创建完成检查是否正常(检查方法参见 oracle物理dg安装方法一)注可能会出现的错误1.备库启动到nomount--db_recovery_file_dest参数对应的目录(/oracle/db/fast_recovery_area具体值查看/tmp/init.ora文件)没有创建会报以下错需要手动创建SQL startup nomount ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory SQL host [oraclen2 tmp]$ mkdir -p /oracle/db/fast_recovery_area [oraclen2 tmp]$ exit exit --audit_file_dest参数对应的目录(/oracle/db/admin/orcl/adump具体值查看/tmp/init.ora文件)没有创建会报以下错需要手动创建(创建后需要退出sqlplus重新登录) SQL startup nomount ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 2: No such file or directory Additional information: 9925 SQL host [oraclen2 tmp]$ mkdir -p /oracle/db/admin/orcl/adump [oraclen2 tmp]$ exit exit SQL select status from v$instance; select status from v$instance * ERROR at line 1: ORA-01012: not logged on Process ID: 0 Session ID: 0 Serial number: 0 SQL startup nomount ORA-01012: not logged on SQL exit Disconnected [oraclen2 tmp]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 12 13:47:34 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL select status from v$instance; STATUS ------------------------------------ STARTED SQL shutdown immediate ORA-01507: database not mounted ORACLE instance shut down. SQL startup nomount ORACLE instance started. Total System Global Area 839282688 bytes Fixed Size 2257880 bytes Variable Size 545262632 bytes Database Buffers 289406976 bytes Redo Buffers 2355200 bytes2.备库执行rman(rman target sys/sysdg1 auxiliary sys/sysdg2)--控制文件数据文件 所在目录要存在否则备库duplicate会报错手动创建好对应目录重新执行duplicate继续进行contents of Memory Script:{ backup as copy current controlfile for standby auxiliary format /oracle/db/oradata/orcl/control01.ctl; restore clone controlfile to /oracle/db/oradata/orcl/control02.ctl from /oracle/db/oradata/orcl/control01.ctl; } executing Memory Script Starting backup at 11-APR-16 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy copying standby control file RMAN-00571: RMAN-00569: ERROR MESSAGE STACK FOLLOWS RMAN-00571: RMAN-03002: failure of Duplicate Db command at 04/11/2016 18:41:11 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/11/2016 18:41:11 ORA-17628: Oracle error 19505 returned by remote Oracle server3.备库执行rman(rman target sys/sysdg1 auxiliary sys/sysdg2)--主库rman检查是不是有expired的归档日志等有的话需要先crosscheck、delete掉(然后备库要退出rman重新登再执行duplicate)否则备库dupliate会报错 Starting backup at 11-APR-16 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy copying standby control file output file name/oracle/db/ora11g/dbs/snapcf_dg1.f tagTAG20160411T184405 RECID11 STAMP908909046 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 11-APR-16 Starting restore at 11-APR-16 using channel ORA_AUX_DISK_1 DBGSQL: TARGET begin :fhdbi : dbms_rcvcat.getDbid; end; DBGSQL: sqlcode 6550 DBGSQL: B :fhdbi 32767 RMAN-00571: RMAN-00569: ERROR MESSAGE STACK FOLLOWS RMAN-00571: RMAN-03002: failure of Duplicate Db command at 04/11/2016 18:44:06 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-06550: line 1, column 17: PLS-00201: identifier DBMS_RCVCAT.GETDBID must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored检查及删除过期expired日志的命令crosscheck archivelog all;list expired archivelog all;delete expired archivelog all;
