How to create physical standby database with 11g RMAN DUPLICATE FROM ACTIVE DATABASE [ID 747250.1]
|
|
|
Modified 15-FEB-2011Type HOWTOStatus 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***
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.
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表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
使用RMAN DUPLICATE...FROM ACTIVE DATABASE 创建物理备库 简化standby创建过程,提高效率
Oracle RMAN 11g Backup and Recovery explains how to configure databases, generate accurate archives, and carry out system restores. Work from the command line or Oracle Enterprise Manager, automate ...
Oracle11g利用rman创建物理standby实验配置指南.pdfOracle11g利用rman创建物理standby实验配置指南.pdfOracle11g利用rman创建物理standby实验配置指南.pdfOracle11g利用rman创建物理standby实验配置指南.pdfOracle11...
Rman通过duplicate创建standby
如何在Oracle 10g On Windows下创建standby database.doc
自己在centos linux 上做的 oracle physical standby配置 ,已测试通过
Oracle standby database的建立与维护.pdf
Oracle Standby Database技术的原理及实现.pdf
how to open a standby database while you lost your primary database
Oracle数据库中Standby Database的搭建和使用.pdf
RH4下Ora9[1].2安装及Standby,RMAN实施.docRH4下Ora9[1].2安装及Standby,RMAN实施.docRH4下Ora9[1].2安装及Standby,RMAN实施.docRH4下Ora9[1].2安装及Standby,RMAN实施.docRH4下Ora9[1].2安装及Standby,RMAN实施.doc
为Linux中的Oracle 11g rac搭建单实例的物理备库的操作步骤
Oracle8i------------------_Standby_Database.ppt
Chapter 1: Getting Started . . . ................................................................................. 1 Oracle in Processes ..................................................................
【DATAGUARD】 将11g物理备库转换为Snapshot Standby【DATAGUARD】 将11g物理备库转换为Snapshot Standby【DATAGUARD】 将11g物理备库转换为Snapshot Standby
使用 create database 的 with override 选项 .......... 144 更改数据库所有权 .......... 145 变更数据库 .......... 145 alter database 语法 .......... 146 使用 drop database 命令 .......... 147 管理空间...
SQL> alter database recover managed standby database using current logfile disconnect from session; SQL> select open_mode,switchover_status,database_role,name from v$database; MOUNTED NOT ALLOWED ...
Oracle DataGuard物理Standby Database配置的详细步骤
Chapter 1: Data Converter History ........................................................................................3 Section 1-1: Early History ....................................................