duplicate rman复制数据库技术

环境介绍：

rhel5.4 32位 192.168.0.201，hostname=dg1  ORACLE_SID=orcl

rhel5.4 32位 192.168.0.202，hostname=dg2  ORACLE_SID=orcl

oracle版本： 11.2.0.1 32位企业版

主库（192.168.0.201）

1、首先在主库上创建测试数据（略）

2、通过rman创建备份文件

[oracle@dg1 ~]$mkdir -p /u01/app/oracle/bak

[oracle@dg1 ~]$ rman target /

RMAN> backup database format '/u01/app/oracle/bak/%d_%s.bak' plus archivelog format '/u01/app/oracle/bak/%d_%s.bak';

从库（192.168.0.202）

1、安装数据库软件

2、创建相应目录

[oracle@dg2 ~]$ mkdir -p /u01/app/oracle/bak

[oracle@dg2 ~]$ mkdir -p /u01/app/oracle/oradata/orcl

[oracle@dg2 ~]$ mkdir -p /u01/app/oracle/admin/orcl/{adump,bdump,cdump,dpdump,udump,pfile}

 

[oracle@dg2 ~]$ mkdir -p /u01/app/oracle/archive/orcl

[oracle@dg2 ~]$ mkdir -p /u01/app/oracle/oradata/orcl

[oracle@dg2 ~]$ mkdir -p /u01/app/oracle/flash_recovery_area/orcl

3、创建口令文件（和主库必须一致）

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

[oracle@dg2 dbs]$ orapwd file=orapworcl password=orcl entries=30

4、复制主库参数文件到从库

如果没有该参数文件，那么create pfile from spfile;创建

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

[oracle@dg1 dbs]$ scp initorcl.ora 192.168.0.202:$ORACLE_HOME/dbs

5、配置tns监听程序（主库也要配置）（netca创建--本地网络服务名配置）

DG2 =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.202)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orcl)

    )

  )

DG1 =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.201)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orcl)

    )

  )

6、复制主库备份集信息到备库

[oracle@dg1 ~]$ cd /u01/app/oracle/bak

[oracle@dg1 bak]$ scp * 192.168.0.202:/u01/app/oracle/bak/

reverse mapping checking getaddrinfo for bogon failed - POSSIBLE BREAK-IN ATTEMPT!

oracle@192.168.0.202's password: 

ORCL_32.bak                                                                   100%   32MB  15.8MB/s   00:02    

ORCL_33.bak                                                                   100%  745MB   6.3MB/s   01:59    

ORCL_34.bak                                                                   100% 9600KB   9.4MB/s   00:01    

ORCL_35.bak                                                                   100%   48KB  47.5KB/s   00:00 

7、将数据库启动到nomount状态（如果启动有问题，请检查你的参数文件）

oracle@dg2 ~]$ sqlplus "/as sysdba"

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  368263168 bytes

Fixed Size    1336596 bytes

Variable Size  306186988 bytes

Database Buffers   54525952 bytes

Redo Buffers    6213632 bytes

8、使用rman对从库进行恢复

[oracle@dg2 ~]$ rman target sys/orcl@dg1 auxiliary /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 30 10:07:21 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1344401817)

connected to auxiliary database: ORCL (not mounted)

RMAN> duplicate target database to orcl nofilenamecheck;

···················

·····················

························

database opened

Finished Duplicate Db at 30-MAY-13

恢复完成。

对数据库进行查询看看吧。。。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28698327/viewspace-762416/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28698327/viewspace-762416/