Oracle 之 duplicate 复制数据库

	主机名	IP
主库	orcl.example.com	192.168.13.11
测试库	s1115.example.com	192.168.13.21

1. 创建密码文件（测试库）

[oracle@s1115 ~]$ cd $ORACLE_HOME/dbs
[oracle@s1115 dbs]$ orapwd file=orapworcl password=oracle_4U entries=10 format=12

• file 文件名
• password 密码（需和主库一致）
• entries 允许sys用户连接数
• format 忽略密码复杂度要求

2. 创建测试库的 pfile （文件内容从源库获取）

[oracle@s1115 ~]$ cd $ORACLE_HOME/dbs
[oracle@s1115 dbs]$ vim initorcl.ora

*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/fast_recovery_area/orcl/control02.ctl','/u01/app/oracle/oradata/orcl/control03.ctl'
*.db_block_size=8192
*.db_domain='example.com'
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=21474836480
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.memory_target=796m
*.open_cursors=300
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
db_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'
log_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'

3. 手工创建测试库所需要的目录（目录参考 pfile 创建）

4. 启动测试库

SQL> startup nomount pfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/initorcl.ora';
SQL> select status from v$instance;

5. netmgr 配置静态监听（监听状态应为 UNKNOWN）

[oracle@s1115 ~]$ lsnrctl status;

6. 从主库连接测试库

[oracle@orcl ~]$ ping 192.168.13.21
[oracle@orcl ~]$ sqlplus sys/oracle_4U@192.168.13.21:1522/orcl.example.com as sysdba

7. 用 rman duplicate 链接目标数据库（主库）和测试库

[oracle@orcl ~]$ rman target sys/oracle_4U@192.168.13.11:1521/orcl.example.com auxiliary sys/oracle_4U@192.168.13.21:1522/orcl.example.com

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Nov 16 14:50:07 2018

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

connected to target database: ORCL (DBID=1519857657)
connected to auxiliary database: ORCL (not mounted)

8. 执行duplicate命令（在主库执行）

RMAN> duplicate target database to orcl from active database nofilenamecheck;
// nofilenamecheck 不进行文件名检查，如果不指定，数据文件相同就会报错