【Oracle】RMAN duplicate复制库

基础环境:

• 172.17.4.60 操作系统:Linux 6.4 数据库:Oracle11gR2 (源数据库)
• 172.17.4.61 操作系统:Linux 6.4 数据库:Oracle11gR2 (测试库)

目的:从源数据库以RMAN的物理恢复的方式，恢复至测试库中。
如何验证，在源数据库，插入几条数据如下:

[email?protected]> create user zsd identified by zsd;

User created.

[email?protected]> grant dba to zsd;

Grant succeeded.

[email?protected]> conn zsd/zsd;
Connected.

[email?protected]> create table t1(name varchar2(20));

Table created.

[email?protected]> insert into t1 values('zsd');

1 row created.

[email?protected]> insert into t1 values('lzh');

1 row created.

[email?protected]> insert into t1 values('zjf');

1 row created.

[email?protected]> commit;

Commit complete.

[email?protected]> select * from t1;

NAME
--------------------
zsd
lzh
zjf

Step 0.基础环境的host配置

两台服务器都需要做如下配置。

[[email?protected] ~]$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
172.17.4.60 db1
172.17.4.61 db2

源数据库端(172.17.4.60):

[[email?protected] ~]$ cat /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=db1

测试数据库端(172.17.4.61):

[[email?protected] ~]$ cat /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=db2

Step 1.修改环境变量

[[email?protected] dbs]$ cd ~
[[email?protected] ~]$ vi .bash_profile

修改ORACLE_SID与源数据库一致，如下:
ORACLE_SID=oradb

Step 2.建立pfile dummy文件

[o[email?protected] ~]$ cd $ORACLE_HOME/dbs
[[email?protected] dbs]$ vi dummy.ora
db_name='zsddummy'

Step 3.从源数据库(172.17.4.60)复制口令文件至测试库（172.17.4.61）。

[[email?protected] dbs]$ pwd
/u01/app/product/11.2.0/db_1/dbs
[[email?protected] dbs]$ scp 172.17.4.60:/u01/app/product/11.2.0/db_1/dbs/orapworadb ./


[[email?protected] dbs]$ ls -lht
总用量 20K
-rw-r-----. 1 oracle oinstall 1.5K 12月 29 15:48 orapworadb
-rw-r--r--. 1 oracle oinstall   19 12月 29 15:44 dummy.ora
-rw-rw----. 1 oracle oinstall 1.6K 12月 29 15:27 hc_oradb.dat
-rw-r-----. 1 oracle oinstall   24 5月  15 2017 lkORADB
-rw-r--r--. 1 oracle oinstall 2.8K 5月  15 2009 init.ora

Step 4.创建相应目录

• 4.1 审计目录

源数据库端(172.17.4.60):

[email?protected]> show parameter audit_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /u01/app/admin/oradb/adump

测试数据库端(172.17.4.61):

[[email?protected] oradb]$ mkdir -p /u01/app/admin/oradb/adump

• 4.2 快速恢复区目录

源数据库端(172.17.4.60):

[email?protected]> show parameter db_recovery_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/fast_recovery_area
db_recovery_file_dest_size           big integer 4182M

测试数据库端(172.17.4.61):

[[email?protected] oradb]$ mkdir -p /u01/app/fast_recovery_area

• 4.3 数据目录

源数据库端(172.17.4.60):

[email?protected]> select name from v$dbfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oradata/oradb/users01.dbf
/u01/app/oradata/oradb/undotbs01.dbf
/u01/app/oradata/oradb/sysaux01.dbf
/u01/app/oradata/oradb/system01.dbf

测试数据库端(172.17.4.61):

[[email?protected] oradb]$ mkdir -p /u01/app/oradata/oradb/
[[email?protected] oradb]$ ls -ld /u01/app/oradata/oradb/
drwxr-x---. 2 oracle oinstall 4096 12月 29 15:27 /u01/app/oradata/oradb/

Step 5.net服务

测试数据库端(172.17.4.61):

[[email?protected] ~]$ cat /u01/app/product/11.2.0/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = db2)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
SID_LIST_LISTENER =  
(SID_LIST =  
  (SID_DESC =  
  (GLOBAL_DBNAME = oradb.zsd.com)
  (ORACLE_HOME=/u01/app/product/11.2.0/db_1)
  (SID_NAME = oradb)
  )
)
ADR_BASE_LISTENER = /u01/app

（编辑：核心网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!