使用rman复制数据库

本文，介绍使用Rman复制数据库。
环境：Linux6.4+ Ora11.2g。在同一个系统中，使用现有的orcl实例，复制一个名为的db实例。

一、用到的关键技术和概念：

1 使用了rman的 auxiliary命令，先过目
rman target / auxiliary sys/******@db_link

2
被复制的数据库，是target指向的数据库实例，称作 目标数据库
auxiliary指向的实例，则是复制后的数据库,称作 辅助数据库

二、概览一下流程图：

三、具体步骤：
1.创建辅助实例db的密码文件
 orapwd file=$ORACLE_HOME/dbs/orapwdb password=123456 entries=10

2.创建辅助实例的初始化参数文件
[oracle@testo dbs]$ vi initdb.ora

*.control_files='/u01/app/oracle/oradata/db/control01.ctl','/u01/app/oracle/oradata/db/control02.ctl'#Restore Controlfile
*.db_block_size=8192
*.db_name='db'
*.db_recovery_file_dest_size=21474836480
*.db_recovery_file_dest='/u01/flb'
*.diagnostic_dest='/u01/app/oracle'
*.memory_target=383671552
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'


db_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/db'
log_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/db'

3.创建辅助实例db的数据文件存放目录
mkdir -p $ORACLE_BASE/oradata/db

4.配置辅助实例和目标实例的listener与tnsname
[oracle@testo admin]$ vi listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2/db/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/11.2/db)
      (SID_NAME = orcl)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = db)
      (ORACLE_HOME = /u01/app/oracle/product/11.2/db)
      (SID_NAME = db)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = testo.com)(PORT = 1521))
  )

ADR_BASE_LISTENER = /u01/app/oracle


[oracle@testo admin]$ vi tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2/db/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL_LINK =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.27.181)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

DB_LINK =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.27.181)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = db)
    )
  )

5.启动目标数据库到读写模式、启动辅助数据库到nomount状态

启动目标数据库：
export ORACLE_SID=orcl
sqlplus / as sysdba
SQL>startup

启动辅助数据库：
export ORACLE_SID=db
sqlplus / as sysdba
SQL>startup nomount

6.使用rman连接目标数据库与辅助数据库

rman target sys/******@orcl_link auxiliary sys/******@db_link


7.在rman中执行复制
 run{
allocate auxiliary channel aux1 device type disk;
allocate auxiliary channel aux2 device type disk;
duplicate target database to db;
 }

完毕！

【参考】 三思笔记--RMAN高级应用之Dumplicate复制数据库

QQ图片20130910132213.jpg

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

转载于:http://blog.itpub.net/29121762/viewspace-772467/