6.备库中开始恢复文件

[oracle@edbjr2p2 dbs]$ export ORACLE_SID=AUX1

[oracle@edbjr2p2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 31 10:09:23 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size 1218968 bytes

Variable Size 88082024 bytes

Database Buffers 188743680 bytes

Redo Buffers 7168000 bytes

SQL> alter database mount standby database;

Database altered.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

[oracle@edbjr2p2 dbs]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Dec 31 10:12:20 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1363387608, not open)

RMAN> restore database

2> ;

Starting restore at 31-DEC-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=151 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /u01/app/oracle/oradata/AUX1/system01.dbf

restoring datafile 00002 to /u01/app/oracle/oradata/AUX1/undotbs01.dbf

restoring datafile 00003 to /u01/app/oracle/oradata/AUX1/sysaux01.dbf

restoring datafile 00004 to /u01/app/oracle/oradata/AUX1/users01.dbf

channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/10.2.0/db_1/dbs/01osspjr_1_1

channel ORA_DISK_1: restored backup piece 1

piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/01osspjr_1_1 tag=TAG20131231T095715

channel ORA_DISK_1: restore complete, elapsed time: 00:01:07

Finished restore at 31-DEC-13

RMAN> exit;

Recovery Manager complete.

[oracle@edbjr2p2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 31 10:14:25 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> alter database recover managed standby database disconnect from session;

Database altered.

主库和备库都执行alter system register;确保数据库都已经注册到监听

至此配置ok

6.测试

现在来进行测试，打开主库，在主库中建立表空间，查看备库中alert日志中能否看到表空间建立。

主库：

SYS@ORCL>create tablespace test

2 datafile '/u01/app/oracle/oradata/ORCL/test01.dbf' size 5m;

Tablespace created.

SYS@ORCL>alter system archive log current;

System altered.

SYS@ORCL>

备库中查看alert日志

[oracle@edbjr2p2 ~]$ cd $ORACLE_HOME/dbs

[oracle@edbjr2p2 dbs]$ ls

initAUX1.ora initdw.ora init.ora orapwAUX1

[oracle@edbjr2p2 dbs]$ cd /u01/app/oracle/admin/AUX1/bdump/

[oracle@edbjr2p2 bdump]$ ls

alert_AUX1.log aux1_arc2_14480.trc aux1_mrp0_14551.trc

aux1_arc0_14476.trc aux1_arc3_14482.trc

aux1_arc1_14478.trc aux1_dbw0_12923.trc

[oracle@edbjr2p2 bdump]$ tail -100f alert_AUX1.log

如果能看到以下内容则代表配置成功

Recovery created file /u01/app/oracle/oradata/AUX1/test01.dbf

Successfully added datafile 7 to media recovery

Datafile #7: '/u01/app/oracle/oradata/AUX1/test01.dbf'

Media Recovery Waiting for thread 1 sequence 30