oracle 10g rac + 单机的physical standby的配法,望大家看完多顶！

最近把MAA的东西看了一起，下决心一定要做个试验坏境来练练手，经过一天的努力，终成正果！ 希望大家看完多顶！

平台：oracle 10g  rac(ASM+RAW) +  单机的physical standby (文件系统）

本文档主要有三部分：
一。rac primary库的设置。
二。standby physical的设置。
三。在rac 两个实例分别建表并同步到physical standby

下面为试验过程：

一. rac 主库：
0.将主库换到archivelog模式:10.2.0.1以后的rac 数据库要改为archivelog模式，比以前的版本简单了很多，只要两边设好归档目录，将rac中所有的实例都关闭，startup到mount
将数据库改成archivelog，open 之后，重启另一个实例既可,在本例在archivelog文件分别放在各自的主机上。
SQL> alter system set log_archive_dest_1='LOCATION=/racdb1_arch' scope=spfile sid='racdb1';
SQL> alter system set log_archive_dest_1='LOCATION=/racdb2_arch' scope=spfile sid='racdb2';

rac1,rac2
SQL>shutdown immediate;
SQL>startup mount;
SQL>alter database archivelog;
SQL>alter database open;
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /racdb1_arch
Oldest online log sequence     64
Next log sequence to archive   65
Current log sequence           65


rac2上：
SQL>startup
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /racdb2_arch
Oldest online log sequence     57
Next log sequence to archive   58
Current log sequence           58



1.将数据改成强制logging.
SQL> alter database force logging;  
SQL> select name,inst_id,force_logging from gv$database;

NAME         INST_ID FOR
--------- ---------- ---
RACDB              1 YES
RACDB              2 YES



2.修改主库的参数：
ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(racdb,standby)' scope=spfile;
alter system set log_archive_dest_1='LOCATION=/racdb1_arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=racdb' scope=spfile sid='racdb1';
alter system set log_archive_dest_1='LOCATION=/racdb1_arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=racdb' scope=spfile sid='racdb2';
alter system set  log_archive_dest_2='SERVICE=standby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby' scope=spfile;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE scope=spfile;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE scope=spfile;
ALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES=8 scope=spfile;
ALTER SYSTEM SET db_file_name_convert='+RACDATA/racdb/datafile/','/oradata/standby/' scope=spfile;
ALTER SYSTEM SET log_file_name_convert='+RACDATA/racdb/onlinelog/','/oradata/standby/' SCOPE=SPFILE;

ALTER SYSTEM SET FAL_CLIENT = racdb SCOPE=SPFILE;
ALTER SYSTEM SET FAL_SERVER = standby SCOPE=SPFILE;
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT =AUTO SCOPE=SPFILE;

SQL> create pfile='/rmanset/initstandby.ora' from spfile;  

File created.

3.重启两个实例使之生效。

4.备份数据rac库for physical standby database：
rac1-> export ORACLE_SID=racdb1
rac1-> rman target / nocatalog
RMAN> run{
2>  allocate CHANNEL ch00  type DISK  CONNECT 'sys/oracle@racdb1';
3>  allocate CHANNEL ch01  type DISK  CONNECT 'sys/oracle@racdb2';
4>  backup database    format '/rmanset/full_%d%t%s%p'         tag 'fullbackup';
5>  sql 'alter system archive log current';
6>  BACKUP FORMAT '/rmanset/%d_arch_%s_%p_%h' ARCHIVELOG ALL;                                         
7>  backup format '/rmanset/standby_%d' current controlfile for standby;
8>  RELEASE CHANNEL ch00;                                                         
9>  RELEASE CHANNEL ch01;                                                        
10> }

released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: sid=123 instance=racdb1 devtype=DISK

allocated channel: ch01
channel ch01: sid=147 instance=racdb2 devtype=DISK

Starting backup at 03-NOV-08
channel ch00: starting full datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00001 name=+RACDATA/racdb/datafile/system.259.669487425
input datafile fno=00005 name=+RACDATA/racdb/datafile/users.264.669487561
input datafile fno=00004 name=+RACDATA/racdb/datafile/undotbs2.263.669487539
channel ch00: starting piece 1 at 03-NOV-08
channel ch01: starting full datafile backupset
channel ch01: specifying datafile(s) in backupset
input datafile fno=00003 name=+RACDATA/racdb/datafile/sysaux.261.669487497
input datafile fno=00002 name=+RACDATA/racdb/datafile/undotbs1.260.669487479
channel ch01: starting piece 1 at 03-NOV-08
channel ch01: finished piece 1 at 03-NOV-08
piece handle=/rmanset/full_RACDB6698474611101 tag=FULLBACKUP comment=NONE
channel ch01: backup set complete, elapsed time: 00:02:10
channel ch01: starting full datafile backupset
channel ch01: specifying datafile(s) in backupset
including current control file in backupset
channel ch01: starting piece 1 at 03-NOV-08
channel ch00: finished piece 1 at 03-NOV-08
piece handle=/rmanset/full_RACDB6698474611091 tag=FULLBACKUP comment=NONE
channel ch00: backup set complete, elapsed time: 00:02:35
channel ch00: starting full datafile backupset
channel ch00: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ch00: starting piece 1 at 03-NOV-08
channel ch00: finished piece 1 at 03-NOV-08
piece handle=/rmanset/full_RACDB6698476171121 tag=FULLBACKUP comment=NONE
channel ch00: backup set complete, elapsed time: 00:00:03
channel ch01: finished piece 1 at 03-NOV-08
piece handle=/rmanset/full_RACDB6698475921111 tag=FULLBACKUP comment=NONE
channel ch01: backup set complete, elapsed time: 00:00:28
Finished backup at 03-NOV-08

sql statement: alter system archive log current

Starting backup at 03-NOV-08
current log archived
channel ch00: starting archive log backupset
channel ch00: specifying archive log(s) in backup set
input archive log thread=1 sequence=42 recid=141 stamp=669603048
input archive log thread=1 sequence=44 recid=149 stamp=669640424
input archive log thread=1 sequence=45 recid=151 stamp=669675778
input archive log thread=1 sequence=46 recid=152 stamp=669679426
input archive log thread=1 sequence=47 recid=156 stamp=669690456
input archive log thread=1 sequence=48 recid=158 stamp=669690550
input archive log thread=1 sequence=49 recid=160 stamp=669691146
input archive log thread=1 sequence=50 recid=162 stamp=669755973
input archive log thread=1 sequence=51 recid=163 stamp=669757116
input archive log thread=1 sequence=52 recid=166 stamp=669764278
channel ch00: starting piece 1 at 03-NOV-08
channel ch01: starting archive log backupset
channel ch01: specifying archive log(s) in backup set
input archive log thread=1 sequence=53 recid=170 stamp=669767346
input archive log thread=1 sequence=54 recid=172 stamp=669769357
input archive log thread=2 sequence=44 recid=165 stamp=669764276
input archive log thread=2 sequence=45 recid=167 stamp=669765472
input archive log thread=2 sequence=46 recid=168 stamp=669765474
input archive log thread=2 sequence=47 recid=169 stamp=669767345
input archive log thread=2 sequence=48 recid=171 stamp=669769352
input archive log thread=2 sequence=49 recid=175 stamp=669769944
input archive log thread=2 sequence=50 recid=177 stamp=669817006
input archive log thread=2 sequence=51 recid=180 stamp=669835061
input archive log thread=2 sequence=52 recid=183 stamp=669836097
input archive log thread=2 sequence=53 recid=184 stamp=669836099
input archive log thread=2 sequence=54 recid=185 stamp=669836363
input archive log thread=2 sequence=55 recid=187 stamp=669836743
input archive log thread=2 sequence=56 recid=189 stamp=669847629
input archive log thread=2 sequence=57 recid=191 stamp=669847636
channel ch01: starting piece 1 at 03-NOV-08
channel ch00: finished piece 1 at 03-NOV-08
piece handle=/rmanset/RACDB_arch_113_1_1 tag=TAG20081103T204721 comment=NONE
channel ch00: backup set complete, elapsed time: 00:00:17
channel ch01: finished piece 1 at 03-NOV-08
piece handle=/rmanset/RACDB_arch_114_1_2 tag=TAG20081103T204721 comment=NONE
channel ch01: backup set complete, elapsed time: 00:00:17
channel ch00: starting archive log backupset
channel ch00: specifying archive log(s) in backup set
input archive log thread=1 sequence=55 recid=173 stamp=669769375
input archive log thread=1 sequence=56 recid=174 stamp=669769928
input archive log thread=1 sequence=57 recid=176 stamp=669816893
input archive log thread=1 sequence=58 recid=178 stamp=669834633
input archive log thread=1 sequence=59 recid=179 stamp=669834635
input archive log thread=1 sequence=60 recid=181 stamp=669835972
input archive log thread=1 sequence=61 recid=182 stamp=669835974
input archive log thread=1 sequence=62 recid=186 stamp=669836740
input archive log thread=1 sequence=63 recid=188 stamp=669847628
input archive log thread=1 sequence=64 recid=190 stamp=669847635
channel ch00: starting piece 1 at 03-NOV-08
channel ch00: finished piece 1 at 03-NOV-08
piece handle=/rmanset/RACDB_arch_115_1_1 tag=TAG20081103T204721 comment=NONE
channel ch00: backup set complete, elapsed time: 00:00:04
Finished backup at 03-NOV-08

Starting backup at 03-NOV-08
channel ch00: starting full datafile backupset
channel ch00: specifying datafile(s) in backupset
including standby control file in backupset
channel ch00: starting piece 1 at 03-NOV-08
channel ch00: finished piece 1 at 03-NOV-08
piece handle=/rmanset/standby_RACDB tag=TAG20081103T204747 comment=NONE
channel ch00: backup set complete, elapsed time: 00:00:07
Finished backup at 03-NOV-08

released channel: ch00

released channel: ch01

RMAN>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10834762/viewspace-484092/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10834762/viewspace-484092/