ORACLE11G搭建dataguard详细步骤（物理standby所有操作总结） - 数据库编程

序言：
DATAGUARD是通过建立一个PRIMARY和STANDBY组来确立其参照关系；STANDBY一旦创建，DATAGUARD就会通过将主数据库(PRIMARY)的REDO传递给STANDBY数据库，然后在STANDBY中应用REDO实现数据库的同步。

1、安装环境
项目列表 primary库 standby库操作系统：
都是centos6.4
都是centos6.4
oracle软件版本：
oracle 11.2.0.1.0
oracle 11.2.0.1.0
IP地址：
192.168.121.217

192.168.121.218
db_unique_name：
pdunq
pdunq_dg
?

2.3 准备参数文件

2.3.2 修改pfile

[oracle@powerlong5 ~]$ rman target sys/syspl1758@PD1 auxiliary /


Recovery Manager: Release 11.2.0.1.0 - Production on Sat Feb 7 19:08:16 2015


Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.


connected to target database: POWERDES (DBID=3391761643)
connected to auxiliary database: POWERDES (not mounted)


RMAN> run {
allocate auxiliary channel c1 device type disk;
allocate auxiliary channel c2 device type disk;
duplicate target database for standby nofilenamecheck dorecover;
release channel c1;
release channel c2;
}
2> 3> 4> 5> 6> 7>
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=767 device type=DISK


allocated channel: c2
channel c2: SID=1150 device type=DISK


Starting Duplicate Db at 07-FEB-15


contents of Memory Script:
{
set until scn 10903678943;
restore clone standby controlfile;
}
executing Memory Script


executing command: SET until clause


Starting restore at 07-FEB-15


channel c1: starting datafile backup set restore
channel c1: restoring control file
channel c1: reading from backup piece /oracle/app/oracle/flash_recovery_area/PDUNQ/backupset/2015_02_07/o1_mf_ncsnf_TAG20150207T182252_bfct20tb_.bkp
channel c1: piece handle=/oracle/app/oracle/flash_recovery_area/PDUNQ/backupset/2015_02_07/o1_mf_ncsnf_TAG20150207T182252_bfct20tb_.bkp tag=TAG20150207T182252
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:01
output file name=/oracle/data_ora/powerdes/control01.ctl
output file name=/oracle/app/oracle/flash_recovery_area/powerdes/control02.ctl
Finished restore at 07-FEB-15


contents of Memory Script:
{
sql clone \'alter database mount standby database\';
}
executing Memory Script


sql statement: alter database mount standby database


contents of Memory Script:
{
set until scn 10903678943;
set newname for datafile 1 to
\"/home/oradata/pwerdes/system01.dbf\";
set newname for datafile 2 to
\"/home/oradata/pwerdes/sysaux01.dbf\";
set newname for datafile 3 to
\"/home/oradata/pwerdes/undotbs01.dbf\";
set newname for datafile 4 to
\"/home/oradata/pwerdes/users01.dbf\";
set newname for datafile 6 to
\"/home/oradata/pwerdes/plas01.dbf\";
set newname for datafile 7 to
\"/home/oradata/pwerdes/pl01.dbf\";
set newname for datafile 8 to
\"/home/oradata/pwerdes/help01.dbf\";
set newname for datafile 9 to
\"/home/oradata/pwerdes/adobelc01.dbf\";
set newname for datafile 10 to
\"/home/oradata/pwerdes/sms01.dbf\";
restore
clone database
;
}
executing Memory Script


executing command: SET until clause


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SE

ORACLE11G搭建dataguard详细步骤（物理standby所有操作总结）(一)