Oracle11gR2在Linux平台下通过RMAN创建DataGuard

注：如果这一步RMAN失败之后，需要先关掉数据库，然后删除spfile，并将库启动到nomount状态再重 新开始用RMAN进行Duplicate Database。
RMAN Duplicate Database之后,修改Primary DB 上的log_archive_dest_2参数为’service=stydb’
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /home//db/11.2/db_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = standby) (ORACLE_HOME = /home//db/11.2/db_1) (SID_NAME = stydb) ) )
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
159387560 bytes 50331648 bytes 5226496 bytes
5、通过RMAN创建辅助数据库
rman target sys/password@pridb; connect auxiliary sys/password@stydb; run { duplicate target database for standby from active database spfile parameter_value_convert ‘orcl’,'stydb' set 'db_unique_name'='stydb' set standby_file_management='AUTO'
set db_create_file_dest='+DATA' set db_recovery_file_dest='+FRA' set control_files='/home//db/stydb/controlfile/control01.ctl' nofilenamecheck ; }
Alias
LISTENER
Version
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date
08-OCT-2010 22:11:39
Uptime
3 days 10 hr. 13 min. 44 sec
Trace Level
off
Security
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbabc_sty)(PORT=1521)))
添加完成直接检查lsnrctl的状态
[oracle@dbabc_sty ~]$ lsnrctl
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 12-OCT-2010 08:25:20
Copyright (c) 1991, 2010, Oracle. All rights reserved.
The command completed successfully
LSNRCTL>
3、在Standby DB上创建密码文件，此密码必须跟Primary DB的sys密码相同
orapwd file=/home//db/11.2/db_1/dbs/orapwstandby password=password
您可能也喜欢：
Oracle RMAN异 Oracle RMAN 机异目录恢复 恢复归档文件
Oracle RMAN增 Oracle
Oracle 11g R2 RHEL 4 上安装
量备份脚本
Dataguard
ASM安装Grid 配置 Oracle
Real-time Apply Infrastructure（1）10g RAC
SQL> startup nomount ORACLE instance started.
Total System Global Area Fixed Size Variable Size Database Buffers Redo Buffers SQL>
217157632 bytes 2211928 bytes
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "standby" has 1 instance(s).
Instance "standby", status UNKNOWN, has 1 handler(s) for this service...
Orcl
Orcl
Primary DB
Stydb
Stydb
Standby DB
1、在Primary DB和Standby DB系统上更新tnsname.ora. In this example, pridb is Primary and stydb is Standby。示例如下
STYDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = stydb)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = stydb)) )
SQL> recover standby dat用
SELECT NAME, creator, sequence#, applied, completion_time FROM v$archived_log
WHERE applied = 'NO';
本文参考：metalink：How to create physical standby database with 11g RMAN DUPLICATE FROM ACTIVE DATABASE [ID 747250.1]
SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 7 14:25:10 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File /home//grid/network/admin/listener.ora
Listener Log File
/home//diag/tnslsnr/dbabc_sty/listener/alert/log.xml
Articles from
Oracle 11gR2 在 Linux平 台 下 通 过 RMAN创 建 DataGuard
2010-10-20 09:10:51 dbabc
说明：
Hostname dbabc_pri dbabc_sty
Ip 127.0.0.1 127.0.0.2
Service_name db_unique_name 备注
PRIDB= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dbabc_sty)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl)) )
2、在Standby DB系统的listener.ora上添加相关信息,示例如下
之后进行登陆测试
[oracle@testdb ~]$ sqlplus sys/password as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 12 08:31:23 2010 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance.
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = dbabc_sty)(PORT = 1521)) ) )
ALTER SYSTEM SET log_archive_dest_2='service=standby