Step By Step Configuring Oracle 10gR2 (10.2.0.5) 3-Nodes RAC to Single Dataguard
Oracle version:10.2.0.5
RAC Primary database
192.168.1.51 racnode1
192.168.1.151 racnode1-vip
172.168.1.51 racnode1-priv
192.168.1.52 racnode2
192.168.1.152 racnode2-vip
172.168.1.52 racnode2-priv
192.168.1.53 racnode3
192.168.1.153 racnode3-vip
172.168.1.53 racnode3-priv
Single Standby database
192.168.1.59 standby
主库是一台3nodes的10g RAC,备库准备使用单实例数据库存储使用ASM
需要在standby机器上安装oracle database software并升级至10.2.0.5,安装过程略
RAC 信息
使用root用户执行 /u01/app/oracle/product/10.2.0/db_1/bin/localconfig add
访问ASM实例
[oracle@racnode1 ~]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Wed Dec 26 14:50:02 2012Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: RACDB (DBID=800157471)RMAN> run{2> configure channel 1 device type disk connect sys/oracle@racdb1;3> configure channel 2 device type disk connect sys/oracle@racdb2;4> configure channel 3 device type disk connect sys/oracle@racdb3;5> backup database format '/u01/app/oracle/backup/%d_FULLBAK_%T_%u_s%s_p%p' tag 'FULLBAK'6> plus archivelog;7> }using target database control file instead of recovery catalogold RMAN configuration parameters:CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters:CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters:CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters are successfully storedold RMAN configuration parameters:CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters:CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';new RMAN configuration parameters are successfully storedStarting backup at 26-DEC-2012 14:50:36current log archivedallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=843 instance=racdb1 devtype=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: sid=848 instance=racdb2 devtype=DISKallocated channel: ORA_DISK_3channel ORA_DISK_3: sid=844 instance=racdb3 devtype=DISKchannel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=23 recid=45 stamp=803055040channel ORA_DISK_1: starting piece 1 at 26-DEC-2012 14:50:50channel ORA_DISK_2: starting archive log backupsetchannel ORA_DISK_2: specifying archive log(s) in backup setinput archive log thread=2 sequence=14 recid=44 stamp=803055040channel ORA_DISK_2: starting piece 1 at 26-DEC-2012 14:50:51channel ORA_DISK_3: starting archive log backupsetchannel ORA_DISK_3: specifying archive log(s) in backup setinput archive log thread=3 sequence=7 recid=43 stamp=803055038channel ORA_DISK_3: starting piece 1 at 26-DEC-2012 14:50:51channel ORA_DISK_1: finished piece 1 at 26-DEC-2012 14:50:54piece handle=+FLASHDG/racdb/backupset/2012_12_26/annnf0_tag20121226t145048_0.283.803055051 tag=TAG20121226T145048 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:05channel ORA_DISK_2: finished piece 1 at 26-DEC-2012 14:50:54piece handle=+FLASHDG/racdb/backupset/2012_12_26/annnf0_tag20121226t145048_0.278.803055051 tag=TAG20121226T145048 comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:05channel ORA_DISK_3: finished piece 1 at 26-DEC-2012 14:50:54piece handle=+FLASHDG/racdb/backupset/2012_12_26/annnf0_tag20121226t145048_0.277.803055051 tag=TAG20121226T145048 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:05Finished backup at 26-DEC-2012 14:50:54Starting backup at 26-DEC-2012 14:50:54using channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=+DATADG/racdb/datafile/system.269.802972261channel ORA_DISK_1: starting piece 1 at 26-DEC-2012 14:50:55channel ORA_DISK_2: starting full datafile backupsetchannel ORA_DISK_2: specifying datafile(s) in backupsetinput datafile fno=00003 name=+DATADG/racdb/datafile/sysaux.265.802972263input datafile fno=00006 name=+DATADG/racdb/datafile/undotbs2.259.802972265input datafile fno=00004 name=+DATADG/racdb/datafile/users.257.802972267channel ORA_DISK_2: starting piece 1 at 26-DEC-2012 14:50:56channel ORA_DISK_3: starting full datafile backupsetchannel ORA_DISK_3: specifying datafile(s) in backupsetinput datafile fno=00005 name=+DATADG/racdb/datafile/example.258.802972265input datafile fno=00002 name=+DATADG/racdb/datafile/undotbs1.256.802972267input datafile fno=00007 name=+DATADG/racdb/datafile/undotbs3.264.802972269channel ORA_DISK_3: starting piece 1 at 26-DEC-2012 14:51:05channel ORA_DISK_1: finished piece 1 at 26-DEC-2012 14:51:36piece handle=/u01/app/oracle/backup/RACDB_FULLBAK_20121226_0kntr9ef_s20_p1 tag=FULLBAK comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:41channel ORA_DISK_2: finished piece 1 at 26-DEC-2012 14:51:44piece handle=/u01/app/oracle/backup/RACDB_FULLBAK_20121226_0lntr9ef_s21_p1 tag=FULLBAK comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:49channel ORA_DISK_3: finished piece 1 at 26-DEC-2012 14:51:44piece handle=/u01/app/oracle/backup/RACDB_FULLBAK_20121226_0mntr9eg_s22_p1 tag=FULLBAK comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:48Finished backup at 26-DEC-2012 14:51:43Starting backup at 26-DEC-2012 14:51:44current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=24 recid=47 stamp=803055105channel ORA_DISK_1: starting piece 1 at 26-DEC-2012 14:51:49channel ORA_DISK_3: starting archive log backupsetchannel ORA_DISK_3: specifying archive log(s) in backup setinput archive log thread=3 sequence=8 recid=48 stamp=803055106channel ORA_DISK_3: starting piece 1 at 26-DEC-2012 14:51:50channel ORA_DISK_1: finished piece 1 at 26-DEC-2012 14:51:50piece handle=+FLASHDG/racdb/backupset/2012_12_26/annnf0_tag20121226t145149_0.275.803055109 tag=TAG20121226T145149 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01channel ORA_DISK_3: finished piece 1 at 26-DEC-2012 14:51:51piece handle=+FLASHDG/racdb/backupset/2012_12_26/annnf0_tag20121226t145149_0.273.803055111 tag=TAG20121226T145149 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:01channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=2 sequence=15 recid=46 stamp=803055105channel ORA_DISK_1: starting piece 1 at 26-DEC-2012 14:51:52channel ORA_DISK_1: finished piece 1 at 26-DEC-2012 14:51:53piece handle=+FLASHDG/racdb/backupset/2012_12_26/annnf0_tag20121226t145149_0.272.803055113 tag=TAG20121226T145149 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02Finished backup at 26-DEC-2012 14:51:53Starting Control File and SPFILE Autobackup at 26-DEC-2012 14:51:53piece handle=/u01/app/oracle/backup/c-800157471-20121226-00 comment=NONEFinished Control File and SPFILE Autobackup at 26-DEC-2012 14:52:00RMAN>SQL> show parameter log_archive_configNAME TYPE VALUE------------------------------------ ----------- ------------------------------log_archive_config string dg_config=(racdb,standby)SQL> show parameter db_unique_nameNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_unique_name string standby
主库的alert.logRecovery of Online Redo Log: Thread 1 Group 11 Seq 61 Reading mem 0 Mem# 0: +DATADG/standby/onlinelog/group_11.264.803059801Thu Dec 27 10:43:49 CST 2012Recovery deleting file #8:'+DATADG/standby/datafile/zhongwc.279.803125553' from controlfile.Deleted Oracle managed file +DATADG/standby/datafile/zhongwc.279.803125553Recovery dropped tablespace 'ZHONGWC'
到此为止Configuring Oracle 10gR2 (10.2.0.5) 3-Nodes RAC to Single Dataguard搭建测试完毕
