How to create physical standby database with 11g RMAN DUPLICATE FROM ACTIVE DATABASE [ID 747250.1]
来源:互联网 发布:软件侵权鉴定报告 编辑:程序博客网 时间:2024/05/17 18:03
How to create physical standby database with 11g RMAN DUPLICATE FROM ACTIVE DATABASE [ID 747250.1]
Modified 15-FEB-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
Applies to:
Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.7 - Release: 11.1 to 11.1
Information in this document applies to any platform.
***Checked for relevance on 15-Feb-2011***
Goal
This note outlines the required steps to create a physical standby database using 11g RMAN DUPLICATE FROM ACTIVE DATABASE. The script is taken from Data Guard labs based on the 11g OBEs available from OTN.
Solution
Install Oracle on standby system.
Update tnsname.ora on primary & standby systems. In this example, Chicago is Primary and Boston is Standby.
tnsnames.ora (on both systems)
BOSTON =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lcarpent.us.oracle.com)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = Boston.us.oracle.com))
)
CHICAGO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = stadu67.us.oracle.com)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = Chicago.us.oracle.com))
)
Also, insert a static entry for Boston in the listener.ora file of the standby system.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Boston.us.oracle.com)
(ORACLE_HOME = /scratch/OracleHomes/OraHome111)
(SID_NAME = Boston)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lcarpent.us.oracle.com)(PORT = 1521))
)
Then execute the following script on standby, assuming ASM is setup with +DATA and +FLASH disk groups:
source ./makeBoston
# Create temporary password file, must have same password as primary
orapwd file=/scratch/OracleHomes/OraHome111/dbs/orapwBoston password=oracle
# Create temporary parameter file
cat > /scratch/OracleHomes/OraHome111/dbs/tempini.ora <
db_name=temp
EOF
# Start up the auxiliary instance nomount
sqlplus '/ as sysdba' <
SET ECHO ON
STARTUP PFILE='/scratch/OracleHomes/OraHome111/dbs/tempini.ora' NOMOUNT;
EOF
rman <
set echo on
connect target sys/oracle@chicago; # Primary
connect auxiliary sys/oracle@boston; # Standby: tnsname used by primary
run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate channel prmy5 type disk;
allocate auxiliary channel stby1 type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'Chicago','Boston'
set 'db_unique_name'='Boston'
set standby_file_management='AUTO'
set db_create_file_dest='+DATA'
set db_recovery_file_dest='+FLASH'
set DB_RECOVERY_FILE_DEST_SIZE='8G'
set dg_broker_start='TRUE'
set control_files='+DATA/boston/controlfile/control01.ctl'
nofilenamecheck
;
}
EOF
exit 0
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977(满)
DBA3 群:62697850 DBA 超级群:63306533;
聊天 群:40132017
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
- How to create physical standby database with 11g RMAN DUPLICATE FROM ACTIVE DATABASE [ID 747250.1]
- How to create physical standby database with 11g RMAN DUPLICATE FROM ACTIVE DATABASE [ID 747250.1]
- Oracle 11g Active Data Guard step by step: How to create a Physical Standby Database using RMAN
- Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE (Doc ID
- RMAN DUPLICATE TARGET DATABASE FOR STANDBY(Active Dataguard) FROM ACTIVE DATABASE (Oracle 11g)
- 11g rman新特性 duplicate target database for standby from active database
- 11g RMAN duplicate from active database
- Oracle 11g Dataguard Duplicate standby database from active database
- RMAN 'Duplicate From Active Database' Feature in 11G [ID 452868.1]
- Duplicate standby database from active database
- Duplicate standby database from active database
- Oracle 11g Data Guard 使用duplicate from active database 创建 standby database
- Oracle 11g Data Guard 使用duplicate from active database 创建 standby database
- Oracle 11g Data Guard 使用duplicate from active database 创建 standby database
- Oracle 11g Data Guard 使用duplicate from active database 创建 standby database .
- 11g DG使用duplicate from active database 创建 物理 standby database
- Oracle 11g Data Guard 使用duplicate from active database 创建 standby database
- How to create a logical standby database based on a physical standby database
- Eclipse 3.4+ Dropins方式安装插件
- DIV+CSS容易犯的十个错误
- Linux USB驅動框架分析
- 欢迎大家
- 程序员基础 MySQL数据库开发必备常识
- How to create physical standby database with 11g RMAN DUPLICATE FROM ACTIVE DATABASE [ID 747250.1]
- 学会孤单
- 【转】如何保护.net中的dll文件(防破解、反编译)
- 保留源 XAML 中空白的2种方式
- CSS HACK
- 基于云计算的通讯录产品设计
- 透视Ext JS 4类背后的机制与特点(中)
- 【转】C#路径/文件/目录/I/O常见操作汇总 收藏
- 进入SAP 鞋服行业