利用RMAN远程复制

来源：互联网发布：象棋软件编辑：程序博客网时间：2024/05/16 15:14

1.利用RMAN备份源数据库

RMAN> run{
2> allocate channel d1 device type disk;
3> backup as compressed backupset
4> incremental level=0
5> format='/u01/rmanbak/inc0_%d_%U'
6> tag='inc0'
7> channel=d1
8> database plus archivelog delete input;
9> backup
10> format='/u01/rmanbak/bkctl.ctl'
11> tag='bkctl'
12> channel=d1
13> current controlfile;
14> }

2.在目标数据库上创建相应目录

mkdir -p /u01/app/oracle/rac1/admin/adump

mkdir -p /u01/app/oracle/rac1/admin/bdump

mkdir -p /u01/app/oracle/rac1/admin/cdump

mkdir -p /u01/app/oracle/rac1/admin/udump

mkdir -p /u01/app/oracle/oradata/rac1/archivelog

3.创建密码文件和pfile

orapwd file=/u01/app/oracle/product/10.2.0/db_1/dbs/orapwrac1 password=oracle entries=5

从源数据库拷贝pfile到目标数据库相应位置

4.启动目标数据库到nomount状态

5.在目标数据库上配置tnsname.ora

RAC12 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.98)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac1)
    )
)

RAC11 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.99)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac1)

6.利用RMAN连接源数据库和目标数据库

rman target sys/sysdba@rac11

rman auxiliary /

7.复制数据库

RMAN> run {
2> allocate auxiliary channel d1 device type disk;
3> duplicate target database to rac1 nofilenamecheck;
4> }