一、环境（主备库环境相同）    操作系统：Red Hat Enterprise Linux Server release 5.5     oracle：11.2.0.1.0 主库/etc/hosts如下 <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code521" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> [root@wbg1 ~]# cat /etc/hosts </li> <li> # Do not remove the following line, or various programs </li> <li> # that require network functionality will fail. </li> <li> 127.0.0.1 wbg1 localhost.localdomain localhost </li> <li> ::1 localhost6.localdomain6 localhost6 </li> <li> </li> <li> 1.1.1.51 wbg1 </li> <li> 1.1.1.52 wbg2 </li> </ol> </div> </div> 备库/etc/hosts如下   <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code781" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> [oracle@wbg2 dbs]$ cat /etc/hosts </li> <li> # Do not remove the following line, or various programs </li> <li> # that require network functionality will fail. </li> <li> 127.0.0.1 wbg2 localhost.localdomain localhost </li> <li> ::1 localhost6.localdomain6 localhost6 </li> <li> </li> <li> 1.1.1.51 wbg1 </li> <li> 1.1.1.52 wbg2 </li> </ol> </div> </div>                        二、搭建过程 1.网络配置，tnsname.ora（主备库相同） <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code649" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> primary= </li> <li> (DESCRIPTION= </li> <li>  (ADDRESS=(PROTOCOL=tcp)(HOST=wbg1)(PORT=1521)) </li> <li>  (CONNECT_DATA=(SERVICE_NAME=wbg))) </li> <li> standby= </li> <li> (DESCRIPTION= </li> <li>  (ADDRESS=(PROTOCOL=tcp)(HOST=wbg2)(PORT=1521)) </li> <li>  (CONNECT_DATA=(SERVICE_NAME=standby))) </li> </ol> </div> </div> 2.从主库拷贝口令文件到备库 <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code897" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> scp orapwprimary wbg2:/u01/app/oracle/product/11.2.0/db_1/dbs/orapwstandby                                                            </li> </ol> </div> </div> 3.主库打开强制记录日志 <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code136" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> SQL> ALTER DATABASE FORCE LOGGING; </li> <li> </li> <li> Database altered. </li> </ol> </div> </div> 4.在不停库的前提下DB_UNIQUE_NAME是不能改的，那么就让主库的别名和DB_NAME相同好了                                                                          <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code440" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> SQL> alter system set DB_UNIQUE_NAME=chicago; </li> <li> alter system set DB_UNIQUE_NAME=chicago </li> <li>                  * </li> <li> ERROR at line 1: </li> <li> ORA-02095: specified initialization parameter cannot be modified </li> </ol> </div> </div> 5.对主库的parameter进行配置 <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code573" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> SQL> alter system set log_archive_config='DG_CONFIG=(wbg,standby)'; </li> <li> </li> <li> System altered. </li> <li> </li> <li> SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION=/u01/app/oracle/arch/wbg/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=wbg'; </li> <li> </li> <li> System altered. </li> <li> </li> <li> SQL> alter system set LOG_ARCHIVE_DEST_2='SERVICE=standby ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby'; </li> <li> </li> <li> System altered. </li> <li> </li> <li> </li> <li> </li> <li> SQL> alter system set FAL_SERVER=standby; </li> <li> </li> <li> System altered. </li> <li> </li> <li> SQL> alter system set DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/standby/','/u01/app/oracle/oradata/wbg/' scope=spfile; </li> <li> </li> <li> System altered. </li> <li> </li> <li> SQL> alter system set LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/standby/','/u01/app/oracle/oradata/wbg/' scope=spfile; </li> <li> </li> <li> System altered </li> <li> </li> <li> SQL> alter system set STANDBY_FILE_MANAGEMENT=AUTO; </li> <li> </li> <li> System altered. </li> </ol> </div> </div> 6.为主库添加standby redo <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code998" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> SQL> ALTER DATABASE ADD STANDBY LOGFILE '/u01/app/oracle/oradata/wbg/std01.log' size 50m; </li> <li> </li> <li> Database altered. </li> <li> </li> <li> SQL> ALTER DATABASE ADD STANDBY LOGFILE '/u01/app/oracle/oradata/wbg/std02.log' size 50m; </li> <li> </li> <li> Database altered. </li> <li> </li> <li> SQL> ALTER DATABASE ADD STANDBY LOGFILE '/u01/app/oracle/oradata/wbg/std03.log' size 50m; </li> <li> </li> <li> Database altered. </li> <li> </li> <li> SQL> ALTER DATABASE ADD STANDBY LOGFILE '/u01/app/oracle/oradata/wbg/std04.log' size 50m; </li> <li> </li> <li> Database altered. </li> </ol> </div> </div> 7.通过主库生产备库的控制文件，并拷贝到备库 <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code255" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/boston.ctl'; </li> <li> </li> <li> Database altered. </li> </ol> </div> </div> 8.在主库生产pfile，并拷贝到备库 9.在备库修改从主库拷贝过来的pfile，修改为 <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code288" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> *.compatible='11.2.0.1.0' </li> <li> *.control_files='/u01/app/oracle/oradata/standby/control01.ctl' </li> <li> *.db_block_size=8192 </li> <li> *.db_file_name_convert='/u01/app/oracle/oradata/wbg/','/u01/app/oracle/oradata/standby/' </li> <li> *.db_name='WBG' </li> <li> DB_UNIQUE_NAME='standby' </li> <li> *.diagnostic_dest='/u01/app/oracle' </li> <li> *.fal_server='primary' </li> <li> *.log_archive_config='DG_CONFIG=(wbg,standby)' </li> <li> *.log_archive_dest_1='LOCATION=/u01/app/oracle/arch/standby/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby' </li> <li> *.log_archive_dest_2='SERVICE=primary ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=primary' </li> <li> *.log_file_name_convert='/u01/app/oracle/oradata/wbg/','/u01/app/oracle/oradata/standby/' </li> <li> *.memory_target=662700032 </li> <li> *.open_cursors=300 </li> <li> *.processes=150 </li> <li> *.remote_login_passwordfile='EXCLUSIVE' </li> <li> *.standby_file_management='AUTO' </li> <li> *.undo_tablespace='UNDOTBS1' </li> </ol> </div> </div> 10.在主库通过rman进行备库，并拷贝到备库 <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code688" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> [oracle@wbg1 ~]$ rman target / </li> <li> </li> <li> Recovery Manager: Release 11.2.0.1.0 - Production on Sun Apr 12 15:30:14 2015 </li> <li> </li> <li> Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. </li> <li> </li> <li> connected to target database: WBG (DBID=1668536352) </li> <li> </li> <li> RMAN> backup database format '/u01/app/oracle/rman/primary/%U' plus archivelog format '/u01/app/oracle/rman/primary/%U'; </li> <li> </li> <li> </li> <li> Starting backup at 12-APR-15 </li> <li> current log archived </li> <li> using target database control file instead of recovery catalog </li> <li> allocated channel: ORA_DISK_1 </li> <li> channel ORA_DISK_1: SID=37 device type=DISK </li> <li> channel ORA_DISK_1: starting archived log backup set </li> <li> channel ORA_DISK_1: specifying archived log(s) in backup set </li> <li> input archived log thread=1 sequence=3 RECID=1 STAMP=876840801 </li> <li> input archived log thread=1 sequence=4 RECID=2 STAMP=876841838 </li> <li> input archived log thread=1 sequence=5 RECID=3 STAMP=876842896 </li> <li> input archived log thread=1 sequence=6 RECID=4 STAMP=876842961 </li> <li> input archived log thread=1 sequence=7 RECID=5 STAMP=876843016 </li> <li> channel ORA_DISK_1: starting piece 1 at 12-APR-15 </li> <li> channel ORA_DISK_1: finished piece 1 at 12-APR-15 </li> <li> piece handle=/u01/app/oracle/rman/primary/01q47409_1_1 tag=TAG20150412T153017 comment=NONE </li> <li> channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07 </li> <li> Finished backup at 12-APR-15 </li> <li> </li> <li> Starting backup at 12-APR-15 </li> <li> using channel ORA_DISK_1 </li> <li> channel ORA_DISK_1: starting full datafile backup set </li> <li> channel ORA_DISK_1: specifying datafile(s) in backup set </li> <li> input datafile file number=00001 name=/u01/app/oracle/oradata/wbg/system01.dbf </li> <li> input datafile file number=00002 name=/u01/app/oracle/oradata/wbg/sysaux01.dbf </li> <li> input datafile file number=00005 name=/u01/app/oracle/oradata/wbg/example01.dbf </li> <li> input datafile file number=00003 name=/u01/app/oracle/oradata/wbg/undotbs01.dbf </li> <li> input datafile file number=00004 name=/u01/app/oracle/oradata/wbg/users01.dbf </li> <li> channel ORA_DISK_1: starting piece 1 at 12-APR-15 </li> <li> channel ORA_DISK_1: finished piece 1 at 12-APR-15 </li> <li> piece handle=/u01/app/oracle/rman/primary/02q4740g_1_1 tag=TAG20150412T153024 comment=NONE </li> <li> channel ORA_DISK_1: backup set complete, elapsed time: 00:01:45 </li> <li> channel ORA_DISK_1: starting full datafile backup set </li> <li> channel ORA_DISK_1: specifying datafile(s) in backup set </li> <li> including current control file in backup set </li> <li> including current SPFILE in backup set </li> <li> channel ORA_DISK_1: starting piece 1 at 12-APR-15 </li> <li> channel ORA_DISK_1: finished piece 1 at 12-APR-15 </li> <li> piece handle=/u01/app/oracle/rman/primary/03q4743p_1_1 tag=TAG20150412T153024 comment=NONE </li> <li> channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 </li> <li> Finished backup at 12-APR-15 </li> <li> </li> <li> Starting backup at 12-APR-15 </li> <li> current log archived </li> <li> using channel ORA_DISK_1 </li> <li> channel ORA_DISK_1: starting archived log backup set </li> <li> channel ORA_DISK_1: specifying archived log(s) in backup set </li> <li> input archived log thread=1 sequence=8 RECID=6 STAMP=876843134 </li> <li> channel ORA_DISK_1: starting piece 1 at 12-APR-15 </li> <li> channel ORA_DISK_1: finished piece 1 at 12-APR-15 </li> <li> piece handle=/u01/app/oracle/rman/primary/04q4743u_1_1 tag=TAG20150412T153214 comment=NONE </li> <li> channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 </li> <li> Finished backup at 12-APR-15 </li> <li> </li> <li> RMAN> quit </li> <li> </li> <li> </li> <li> Recovery Manager complete. </li> <li> [oracle@wbg1 ~]$ </li> </ol> </div> </div> 11.启动备库的instance，并可以看到，文件已经可以convert过来 <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code372" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> [oracle@wbg2 dbs]$ !sql </li> <li> sqlplus / as sysdba </li> <li> </li> <li> SQL*Plus: Release 11.2.0.1.0 Production on Sun Apr 12 16:07:39 2015 </li> <li> </li> <li> Copyright (c) 1982, 2009, Oracle. All rights reserved. </li> <li> </li> <li> Connected to an idle instance. </li> <li> </li> <li> SQL> startup nomount </li> <li> ORACLE instance started. </li> <li> </li> <li> Total System Global Area 661209088 bytes </li> <li> Fixed Size 1338560 bytes </li> <li> Variable Size 394265408 bytes </li> <li> Database Buffers 260046848 bytes </li> <li> Redo Buffers 5558272 bytes </li> <li> SQL> !echo $ORACLE_SID </li> <li> standby </li> <li> </li> <li> SQL> alter database mount; </li> <li> </li> <li> Database altered. </li> <li> </li> <li> SQL> select name from v$datafile; </li> <li> </li> <li> NAME </li> <li> -------------------------------------------------------------------------------- </li> <li> /u01/app/oracle/oradata/standby/system01.dbf </li> <li> /u01/app/oracle/oradata/standby/sysaux01.dbf </li> <li> /u01/app/oracle/oradata/standby/undotbs01.dbf </li> <li> /u01/app/oracle/oradata/standby/users01.dbf </li> <li> /u01/app/oracle/oradata/standby/example01.dbf </li> </ol> </div> </div> 12.在备库用rman进行恢复 <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code203" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> [oracle@wbg2 standby]$ rman target / </li> <li> </li> <li> Recovery Manager: Release 11.2.0.1.0 - Production on Sun Apr 12 16:20:54 2015 </li> <li> </li> <li> Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. </li> <li> </li> <li> connected to target database: WBG (DBID=1668536352, not open) </li> <li> </li> <li> RMAN> catalog start with '/u01/app/oracle/rman/standby/'; </li> <li> </li> <li> using target database control file instead of recovery catalog </li> <li> searching for all files that match the pattern /u01/app/oracle/rman/standby/ </li> <li> </li> <li> List of Files Unknown to the Database </li> <li> ===================================== </li> <li> File Name: /u01/app/oracle/rman/standby/01q47409_1_1 </li> <li> File Name: /u01/app/oracle/rman/standby/03q4743p_1_1 </li> <li> File Name: /u01/app/oracle/rman/standby/02q4740g_1_1 </li> <li> File Name: /u01/app/oracle/rman/standby/04q4743u_1_1 </li> <li> </li> <li> Do you really want to catalog the above files (enter YES or NO)? yes </li> <li> cataloging files... </li> <li> cataloging done </li> <li> </li> <li> List of Cataloged Files </li> <li> ======================= </li> <li> File Name: /u01/app/oracle/rman/standby/01q47409_1_1 </li> <li> File Name: /u01/app/oracle/rman/standby/03q4743p_1_1 </li> <li> File Name: /u01/app/oracle/rman/standby/02q4740g_1_1 </li> <li> File Name: /u01/app/oracle/rman/standby/04q4743u_1_1 </li> <li> </li> <li> RMAN> restore database; </li> <li> </li> <li> Starting restore at 12-APR-15 </li> <li> allocated channel: ORA_DISK_1 </li> <li> channel ORA_DISK_1: SID=20 device type=DISK </li> <li> </li> <li> channel ORA_DISK_1: starting datafile backup set restore </li> <li> channel ORA_DISK_1: specifying datafile(s) to restore from backup set </li> <li> channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/standby/system01.dbf </li> <li> channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/standby/sysaux01.dbf </li> <li> channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/standby/undotbs01.dbf </li> <li> channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/standby/users01.dbf </li> <li> channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/standby/example01.dbf </li> <li> channel ORA_DISK_1: reading from backup piece /u01/app/oracle/rman/standby/02q4740g_1_1 </li> <li> channel ORA_DISK_1: piece handle=/u01/app/oracle/rman/standby/02q4740g_1_1 tag=TAG20150412T153024 </li> <li> channel ORA_DISK_1: restored backup piece 1 </li> <li> channel ORA_DISK_1: restore complete, elapsed time: 00:01:05 </li> <li> Finished restore at 12-APR-15 </li> <li> </li> <li> RMAN> recover database; </li> <li> </li> <li> Starting recover at 12-APR-15 </li> <li> using channel ORA_DISK_1 </li> <li> </li> <li> starting media recovery </li> <li> </li> <li> channel ORA_DISK_1: starting archived log restore to default destination </li> <li> channel ORA_DISK_1: restoring archived log </li> <li> archived log thread=1 sequence=5 </li> <li> channel ORA_DISK_1: restoring archived log </li> <li> archived log thread=1 sequence=6 </li> <li> channel ORA_DISK_1: restoring archived log </li> <li> archived log thread=1 sequence=7 </li> <li> channel ORA_DISK_1: reading from backup piece /u01/app/oracle/rman/standby/01q47409_1_1 </li> <li> channel ORA_DISK_1: piece handle=/u01/app/oracle/rman/standby/01q47409_1_1 tag=TAG20150412T153017 </li> <li> channel ORA_DISK_1: restored backup piece 1 </li> <li> channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 </li> <li> archived log file name=/u01/app/oracle/arch/standby/1_5_876836460.dbf thread=1 sequence=0 </li> <li> archived log file name=/u01/app/oracle/arch/standby/1_6_876836460.dbf thread=1 sequence=6 </li> <li> archived log file name=/u01/app/oracle/arch/standby/1_7_876836460.dbf thread=1 sequence=7 </li> <li> channel ORA_DISK_1: starting archived log restore to default destination </li> <li> channel ORA_DISK_1: restoring archived log </li> <li> archived log thread=1 sequence=8 </li> <li> channel ORA_DISK_1: reading from backup piece /u01/app/oracle/rman/standby/04q4743u_1_1 </li> <li> channel ORA_DISK_1: piece handle=/u01/app/oracle/rman/standby/04q4743u_1_1 tag=TAG20150412T153214 </li> <li> channel ORA_DISK_1: restored backup piece 1 </li> <li> channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 </li> <li> archived log file name=/u01/app/oracle/arch/standby/1_8_876836460.dbf thread=1 sequence=8 </li> <li> unable to find archived log </li> <li> archived log thread=1 sequence=9 </li> <li> RMAN-00571: =========================================================== </li> <li> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== </li> <li> RMAN-00571: =========================================================== </li> <li> RMAN-03002: failure of recover command at 04/12/2015 16:34:13 </li> <li> RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 9 and starting SCN of 892714 </li> <li> </li> <li> RMAN> </li> </ol> </div> </div> 13.在备库的sqlplus中clear日志文件 <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code372" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> SQL> ALTER DATABASE CLEAR LOGFILE GROUP 1; </li> <li> </li> <li> Database altered. </li> </ol> </div> </div> 14.打开备库，备库开启recover <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code931" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> SQL> alter database open; </li> <li> </li> <li> Database altered. </li> <li> </li> <li> SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; </li> <li> </li> <li> Database altered. </li> </ol> </div> </div> 15.查看主备库告警日志，可以看见主库在发送日志，备库在接收日志，至此dg完成                                                                                主库： <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code730" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> Sun Apr 12 17:29:06 2015 </li> <li> Using STANDBY_ARCHIVE_DEST parameter default value as /u01/app/oracle/arch/wbg/ </li> <li> ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH; </li> <li> Sun Apr 12 17:29:08 2015 </li> <li> ****************************************************************** </li> <li> LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2 </li> <li> ****************************************************************** </li> <li> Sun Apr 12 17:29:08 2015 </li> <li> Thread 1 advanced to log sequence 33 (LGWR switch) </li> <li> Current log# 3 seq# 33 mem# 0: /u01/app/oracle/oradata/wbg/redo03.log </li> <li> Sun Apr 12 17:29:08 2015 </li> <li> Archived Log entry 53 added for thread 1 sequence 32 ID 0xcb3dbb7c dest 1: </li> <li> LNS: Standby redo logfile selected for thread 1 sequence 32 for destination LOG_ARCHIVE_DEST_2 </li> <li> LNS: Standby redo logfile selected for thread 1 sequence 33 for destination LOG_ARCHIVE_DEST_2 </li> <li> Sun Apr 12 17:29:26 2015 </li> <li> ALTER SYSTEM ARCHIVE LOG </li> <li> Sun Apr 12 17:29:26 2015 </li> <li> Thread 1 advanced to log sequence 34 (LGWR switch) </li> <li> Current log# 1 seq# 34 mem# 0: /u01/app/oracle/oradata/wbg/redo01.log </li> <li> Archived Log entry 55 added for thread 1 sequence 33 ID 0xcb3dbb7c dest 1: </li> <li> Sun Apr 12 17:29:26 2015 </li> <li> LNS: Standby redo logfile selected for thread 1 sequence 34 for destination LOG_ARCHIVE_DEST_2 </li> <li> ALTER SYSTEM ARCHIVE LOG </li> <li> Thread 1 advanced to log sequence 35 (LGWR switch) </li> <li> Current log# 2 seq# 35 mem# 0: /u01/app/oracle/oradata/wbg/redo02.log </li> <li> Archived Log entry 57 added for thread 1 sequence 34 ID 0xcb3dbb7c dest 1: </li> <li> LNS: Standby redo logfile selected for thread 1 sequence 35 for destination LOG_ARCHIVE_DEST_2 </li> <li> ALTER SYSTEM ARCHIVE LOG </li> <li> Thread 1 advanced to log sequence 36 (LGWR switch) </li> <li> Current log# 3 seq# 36 mem# 0: /u01/app/oracle/oradata/wbg/redo03.log </li> <li> Archived Log entry 59 added for thread 1 sequence 35 ID 0xcb3dbb7c dest 1: </li> <li> LNS: Standby redo logfile selected for thread 1 sequence 36 for destination LOG_ARCHIVE_DEST_2 </li> </ol> </div> </div> 备库： <div> <div class="codeheads"> 点击(此处)折叠或打开 </div> <div id="code647" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> Sun Apr 12 18:10:43 2015 </li> <li> RFS[6]: Assigned to RFS process 1957 </li> <li> RFS[6]: Identified database type as 'physical standby': Client is ARCH pid 3004 </li> <li> RFS[6]: Opened log for thread 1 sequence 29 dbid 1668536352 branch 876836460 </li> <li> Sun Apr 12 18:10:43 2015 </li> <li> RFS[7]: Assigned to RFS process 1959 </li> <li> RFS[7]: Identified database type as 'physical standby': Client is ARCH pid 3008 </li> <li> Archived Log entry 25 added for thread 1 sequence 29 rlc 876836460 ID 0xcb3dbb7c dest 2: </li> <li> RFS[7]: Opened log for thread 1 sequence 30 dbid 1668536352 branch 876836460 </li> <li> Archived Log entry 26 added for thread 1 sequence 30 rlc 876836460 ID 0xcb3dbb7c dest 2: </li> <li> Sun Apr 12 18:10:43 2015 </li> <li> RFS[8]: Assigned to RFS process 1961 </li> <li> RFS[8]: Identified database type as 'physical standby': Client is ARCH pid 3011 </li> <li> RFS[8]: Opened log for thread 1 sequence 31 dbid 1668536352 branch 876836460 </li> <li> Archived Log entry 27 added for thread 1 sequence 31 rlc 876836460 ID 0xcb3dbb7c dest 2: </li> <li> Sun Apr 12 18:10:45 2015 </li> <li> RFS[9]: Assigned to RFS process 1963 </li> <li> RFS[9]: Identified database type as 'physical standby': Client is LGWR ASYNC pid 3173 </li> <li> Primary database is in MAXIMUM PERFORMANCE mode </li> <li> RFS[9]: Selected log 4 for thread 1 sequence 32 dbid 1668536352 branch 876836460 </li> <li> Sun Apr 12 18:10:45 2015 </li> <li> Archived Log entry 28 added for thread 1 sequence 32 ID 0xcb3dbb7c dest 1: </li> <li> RFS[9]: Selected log 4 for thread 1 sequence 33 dbid 1668536352 branch 876836460 </li> <li> Sun Apr 12 18:11:03 2015 </li> <li> RFS[9]: Selected log 5 for thread 1 sequence 34 dbid 1668536352 branch 876836460 </li> <li> Sun Apr 12 18:11:03 2015 </li> <li> Archived Log entry 29 added for thread 1 sequence 33 ID 0xcb3dbb7c dest 1: </li> <li> Sun Apr 12 18:11:04 2015 </li> <li> Archived Log entry 30 added for thread 1 sequence 34 ID 0xcb3dbb7c dest 1: </li> <li> RFS[9]: Selected log 4 for thread 1 sequence 35 dbid 1668536352 branch 876836460 </li> <li> Sun Apr 12 18:11:05 2015 </li> <li> Archived Log entry 31 added for thread 1 sequence 35 ID 0xcb3dbb7c dest 1: </li> <li> RFS[9]: Selected log 4 for thread 1 sequence 36 dbid 1668536352 branch 876836460 </li> <li> Sun Apr 12 18:11:37 2015 </li> <li> RFS[10]: Assigned to RFS process 1968 </li> <li> RFS[10]: Identified database type as 'physical standby': Client is ARCH pid 3004 </li> </ol> </div> </div> 三、总结 1.用这种方法搭建物理dg，可以保持业务正常使用 2.备库恢复的方法，类似于rman的异机恢复，而且更加简单 3.修改主库的parameter，只能修改spfile

ITPub博客

主库不停做物理dg

最新文章