15、将备库启动到nomount状态，然后连接主库进行RMAN duplicate操作

SQL> conn /as sysdba

SQL> create spfile frompfile='/home/oracle/initdg.ora';

SQL> startup nomount

备注：

若启动出现 ORA-32004: obsoleteor deprecated parameter(s) specified for RDBMS instance ，则查看日志，

文本格 式的alert文件在哪里呢？看一下动态视图V$DIAG_INFO吧。

SQL> select * from v$diag_info ;

$ tail -f /data/oracle/app/oracle/diag/rdbms/orcl_standby/orcl/trace/alert_orcl.log

看看有无类似过期参数提示：

WARNING: The background_dump_dest init.ora parameter has beendeprecated.

16、RMAN同时连接主库与备库

在备库机器上执行（主库为启动startup，备库为nomount状态）

$ rman target sys/sysoracle@orcl_primary auxiliary sys/sysoracle@orcl_standby

Recovery Manager: Release 11.2.0.4.0 -Production on Tue May 20 11:45:02 2014

Copyright (c) 1982, 2011, Oracle and/or itsaffiliates. All rights reserved.

connected to target database: ORCL(DBID=4079000510)

connected to auxiliary database: ORCL (notmounted)

RMAN>

17、RMAN通过网络在线duplicate复制主库数据到备库

RMAN> duplicate target database for standby nofilenamecheck from active database;

Starting Duplicate Db at 20-MAY-14

using target database control file insteadof recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=315 devicetype=DISK

…… 省略

Finished Duplicate Db at 20-MAY-14

RMAN> exit

Recovery Manager complete.

18、将备库置于active dataguard模式下

在Oracle 11g之前，物理备库（physical Standby）在应用redo的时候，数据库需要处于mount状态。从11g开始，应用redo的时候，物理备库可以处于read-only模式，这就称为Active Data Guard 。通过Active Data Guard，可以在物理备库进行查询或者导出数据，从而减少对主库的访问和压力。

$ sqlplus /nolog

SQL> conn /as sysdba

查看状态

SQL> select open_mode,database_role,db_unique_name from v$database;

OPEN_MODE DATABASE_ROLE DB_UNIQUE_NAME

-------------------- ----------------------------------------------

MOUNTED PHYSICAL STANDBY orcl_standby

1）打开备库（Dataguard只能启动备库到readonly模式）

SQL> alter database open;

2）启用实时重做应用

选项“USING CURRENT LOGFILE”的含义是当备库收到日志后，尽快完成恢复。

SQL> alter database recover managed standby database using current logfile disconnect from session;

取消备库的自动恢复

取消Redo Apply

SQL> alter database recover managed standby database cancel;

3）查看状态

状态“READ ONLY WITH APPLY”即表示此时备库处于Read Only状态的同时可以接受主库传过来的日志进行恢复，以便达到备库可以即时查看到主库变化的目的。

SQL> select open_mode,database_role,db_unique_name from v$database;

OPEN_MODE DATABASE_ROLEDB_UNIQUE_NAME

-------------------- ----------------------------------------------

READ ONLY WITH APPLY PHYSICAL STANDBY orcl_standby

查看日志状态

SQL> select status from v$standby_log;

STATUS

----------

ACTIVE

ACTIVE

UNASSIGNED

SQL> select member from v$logfile;

MEMBER

--------------------------------------------------------------------------------

/data/oracle/app/oracle/fast_recovery_area/ORCL_STANDBY/onlinelog/o1_mf_3_9qon4l1s_.log

/data/oracle/app/oracle/fast_recovery_area/ORCL_STANDBY/onlinelog/o1_mf_2_9qon4hjg_.log

/data/oracle/app/oracle/fast_recovery_area/ORCL_STANDBY/onlinelog/o1_mf_1_9qon4f3v_.log

/data/oracle/app/oracle/fast_recovery_area/ORCL_STANDBY/onlinelog/o1_mf_11_9qon4nh8_.log

MEMBER

--------------------------------------------------------------------------------

/data/oracle/app/oracle/fast_recovery_area/ORCL_STANDBY/onlinelog/o1_mf_12_9qon4s8k_.log

/data/oracle/app/oracle/fast_recovery_area/ORCL_STANDBY/onlinelog/o1_mf_13_9qon4y3c_.log

6 rows selected.

五、修改dataguard的数据保护模式为最高可用性模式