Oracle 11g RMAN能够实现基于活动数据库进行异机克隆，从而省去需要先备份再ftp到辅助服务器的过程。这一切可以全部交给Oracle来搞定。在克隆期间，Oracle会读取Target DB的所有数据结构，无须人为的干预(不同的磁盘系统，文件路径与文件名要指定转换方式)。尽管如此，对于生产环境数据库在整个克隆期间性能会下降，其次在Target Server与Auxiliary Server中会产生较大的网络流量。如果这些可以接受的话，从活动数据库进行异机克隆是一个不错的选择。本文首先描述了克隆时不同的连接与克隆方式样本，最后演示了基于活动数据库的克隆。
1、RMAN不同克隆类型的连接方式
关于RMAN不同克隆类型，请参考: 基于 RMAN 的同机数据库克隆 基于RMAN的异机数据库克隆(rman duplicate)
$ export ORACLE_SID=sybo3
# 从备份集克隆，不连接到Target DB以及catalog，或者没有使用catalog
$ rman AUXILIARY /
# 从备份集克隆，无catalog，元数据来源于Target DB控制文件
$ rman TARGET sys/pwd@TAR AUXILIARY sys/pwd@AUX
# 从备份集克隆连接到catalog，但不连接到target DB，元数据库来自RMAN catalog
$ rman CATALOG rman/pwd@catalogdb AUXILIARY sys/pwd@AUX
# 同时连接到target DB以及catalog 元数据来源于Target DB控制文件或catalog，该方式支持从备份集克隆，从活动数据库克隆
$ rman TARGET sys/pwd@TAR CATALOG rman/pwd@catalogdb AUXILIARY sys/pwd@AUX
2、常用的数据库克隆场景
# Auxiliary DB使用与Target DB相同的磁盘系统，文件位置及文件名，下同。需要转换的情形请参考: RMAN 数据库克隆文件位置转换方法
DUPLICATE TARGET DATABASE TO sybo3
SPFILE
NOFILENAMECHECK;
# 将数据库克隆到Target DB一周以前的状态，注，备份集或归档日志应存在
DUPLICATE TARGET DATABASE TO sybo3
UNTIL TIME 'SYSDATE-7'
SPFILE
NOFILENAMECHECK;
# 备份集保存在不同于Target DB保存的位置，此时需要在RMAN中单独指定其位置
DUPLICATE DATABASE TO sybo3
SPFILE
BACKUP LOCATION '/u01/bak/fast_recovery_area/sybo3'
NOFILENAMECHECK;
3、基于活动数据库克隆图示
4、演示机遇活动数据库异机克隆
--环境:
--目标数据库: 192.168.7.25/sybo3 /u01/database/sybo3 主机名:linux3
--辅助数据库: 192.168.7.26/sybo3 /u01/database/sybo3 主机名:linux4 目标数据库与辅助数据库使用相同的文件位置
--说明：
--本次演示使用为使用任何备份文件，连接到target DB。
--对于下面描述过程中，如创建参数文件，密码文件，监听等等有不甚了解的，可参考下面链接中有关文章的描述。
--http://blog.csdn.net/robinson_0612/article/category/827734 (体系结构相关)
--http://blog.csdn.net/robinson_0612/article/category/828434 (网络配置相关)
[oracle@linux3 database]$ cat /etc/issue
Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)
Kernel \r on an \m
SQL> select * from v$version where rownum<2;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
--Target DB的配置,位于主机linux3
SQL> select instance_name,host_name from v$instance;
INSTANCE_NAME HOST_NAME
---------------- ----------------------------------------------------------------
sybo3 linux3.orasrv.com
--Target DB处于归档模式
SQL> select name,open_mode,log_mode from v$database;
NAME OPEN_MODE LOG_MODE
--------- -------------------- ------------
SYBO3 READ WRITE ARCHIVELOG
--Target DB上用于验证克隆成功的表
SQL> select * from t;
NAME ACTION
---------- --------------------
Robinson Transfer DB
Jackson Transfer DB by rman
-- Author : Robinson Cheng
-- Blog : http://blog.csdn.net/robinson_0612
[oracle@linux3 ~]$ export ORACLE_SID=sybo3
[oracle@linux3 ~]$ rman target /
RMAN> list backupset; --->目标数据库无任何备份集
specification does not match any backup in the repository
RMAN> list copy;
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
specification does not match any archived log in the repository
RMAN> list backup of archivelog all;
specification does not match any backup in the repository
a、在Auxiliary server创建相应的dump文件夹
[oracle@linux4 database]$ more sybo3.sh
#!/bin/sh
mkdir -p /u01/database
mkdir -p /u01/database/sybo3/adump
mkdir -p /u01/database/sybo3/controlf
mkdir -p /u01/database/sybo3/fra
mkdir -p /u01/database/sybo3/oradata
mkdir -p /u01/database/sybo3/redo
mkdir -p /u01/database/sybo3/dpdump
mkdir -p /u01/database/sybo3/pfile
[oracle@linux4 database]$ ./sybo3.sh
b、配置辅助实例参数文件
--由于auxiliary DB与target DB不存在文件位置转换，因此无需作任何修改，直接将其ftp到Auxiliary server
--如果没有pfile文件，可从target db生成。 create pfile from spfile;
[oracle@linux3 ~]$ scp $ORACLE_HOME/dbs/initsybo3.ora 192.168.7.26:$ORACLE_HOME/dbs
c、生成辅助实例密码文件
--如果使用orapwd命令建立密码文件应保证与target DB密码相同
--或者直接使用Target DB的密码文件
[oracle@linux3 ~]$ scp $ORACLE_HOME/dbs/orapwsybo3 192.168.7.26:$ORACLE_HOME/dbs
d、在Auxiliary Server与Target Server配置监听(方式多样，不详述)
--Auxiliary Server
[oracle@linux4 admin]$ more listener.ora
SID_LIST_LISTENER_SYBO3 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = sybo3.orasrv.com)
(ORACLE_HOME = /u01/oracle/db_1)
(SID_NAME = sybo3)
)
)
LISTENER_SYBO3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.26)(PORT = 1531))
)
ADR_BASE_LISTENER_SYBO3 = /u01/oracle
[oracle@linux4 admin]$ more tnsnames.ora
TAR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.25)(PORT = 1531))
)
(CONNECT_DATA =
(SERVICE_NAME = SYBO3.ORASRV.COM)
)
)
AUX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.26)(PORT = 1531))
)
(CONNECT_DATA =
(SERVICE_NAME = SYBO3.ORASRV.COM)
)
)
--Target Server
[oracle@linux3 ~]$ more /u01/oracle/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/oracle/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER_SYBO3 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = sybo3.orasrv.com)
(ORACLE_HOME = /u01/oracle/db_1)
(SID_NAME = sybo3)
)
)
LISTENER_SYBO3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux3.orasrv.com)(PORT = 1531))
)
ADR_BASE_LISTENER_SYBO3 = /u01/oracle
[oracle@linux3 ~]$ more /u01/oracle/db_1/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/oracle/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
# 注，在Target Server与Auxiliary Server的tnames.ora文件中，使用了相同的entry，即同时存在TAR与AUX
TAR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.25)(PORT = 1531))
)
(CONNECT_DATA =
(SERVICE_NAME = SYBO3.ORASRV.COM)
)
)
AUX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.26)(PORT = 1531))
)
(CONNECT_DATA =
(SERVICE_NAME = SYBO3.ORASRV.COM)
)
)
--使用下面的命令确保能够Ping通
[oracle@linux3 admin]$ tnsping TAR
[oracle@linux3 admin]$ tnsping AUX
[oracle@linux4 admin]$ tnsping TAR
[oracle@linux4 admin]$ tnsping AUX
e、实施数据库克隆
[oracle@linux4 ~]$ export ORACLE_SID=sybo3
[oracle@linux4 ~]$ sqlplus / as sysdba
SQL> startup nomount;
SQL> exit
[oracle@linux4 ~]$ rman target sys/oracle@TAR auxiliary sys/oracle@AUX
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Aug 2 11:44:09 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: SYBO3 (DBID=2347733014)
connected to auxiliary database: SYBO3 (not mounted)
RMAN> duplicate database to sybo3 from active database spfile nofilenamecheck; --->发布duplicate命令
Starting Duplicate Db at 02-AUG-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=134 device type=DISK
contents of Memory Script:
{
backup as copy reuse --->该命令块备份服务器参数文件并修改spfile参数
targetfile '/u01/oracle/db_1/dbs/spfilesybo3.ora' auxiliary format
'/u01/oracle/db_1/dbs/spfilesybo3.ora' ;
sql clone "alter system set spfile= ''/u01/oracle/db_1/dbs/spfilesybo3.ora''";
}
executing Memory Script
Starting backup at 02-AUG-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=145 device type=DISK
Finished backup at 02-AUG-13
sql statement: alter system set spfile= ''/u01/oracle/db_1/dbs/spfilesybo3.ora''
contents of Memory Script:
{
sql clone "alter system set db_name = --->该命令块主要是修改db_name，重启auxliary DB
''SYBO3'' comment=
''duplicate'' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ''SYBO3'' comment= ''duplicate'' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 376635392 bytes
Fixed Size 1336652 bytes
Variable Size 285215412 bytes
Database Buffers 83886080 bytes
Redo Buffers 6197248 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''SYBO3'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''SYBO3'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount --->该命令块备份控制文件并恢复控制文件到Auxiliary DB
backup as copy current controlfile auxiliary format '/u01/database/sybo3/controlf/control01.ctl';
restore clone controlfile to '/u01/database/sybo3/controlf/control02.ctl' from
'/u01/database/sybo3/controlf/control01.ctl';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''SYBO3'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''SYBO3'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 376635392 bytes
Fixed Size 1336652 bytes
Variable Size 285215412 bytes
Database Buffers 83886080 bytes
Redo Buffers 6197248 bytes
Starting backup at 02-AUG-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/oracle/db_1/dbs/snapcf_sybo3.f tag=TAG20130802T114449 RECID=5 STAMP=822397490
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 02-AUG-13
Starting restore at 02-AUG-13
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=133 device type=DISK
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 02-AUG-13
database mounted
RMAN-05538: WARNING: implicitly using DB_FILE_NAME_CONVERT --->这个地方提示隐式使用DB_FILE_NAME_CONVERT参数
contents of Memory Script:
{ --->该命令块用于set newname以及热备数据文件，使用copy方式
set newname for datafile 1 to
"/u01/database/sybo3/oradata/system01.dbf";
set newname for datafile 2 to
"/u01/database/sybo3/oradata/sysaux01.dbf";
set newname for datafile 3 to
"/u01/database/sybo3/oradata/undotbs01.dbf";
set newname for datafile 4 to
"/u01/database/sybo3/oradata/users01.dbf";
set newname for datafile 5 to
"/u01/database/sybo3/oradata/example01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u01/database/sybo3/oradata/system01.dbf" datafile
2 auxiliary format
"/u01/database/sybo3/oradata/sysaux01.dbf" datafile
3 auxiliary format
"/u01/database/sybo3/oradata/undotbs01.dbf" datafile
4 auxiliary format
"/u01/database/sybo3/oradata/users01.dbf" datafile
5 auxiliary format
"/u01/database/sybo3/oradata/example01.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 02-AUG-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/database/sybo3/oradata/system01.dbf
output file name=/u01/database/sybo3/oradata/system01.dbf tag=TAG20130802T114457
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/database/sybo3/oradata/sysaux01.dbf
output file name=/u01/database/sybo3/oradata/sysaux01.dbf tag=TAG20130802T114457
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u01/database/sybo3/oradata/example01.dbf
output file name=/u01/database/sybo3/oradata/example01.dbf tag=TAG20130802T114457
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/database/sybo3/oradata/undotbs01.dbf
output file name=/u01/database/sybo3/oradata/undotbs01.dbf tag=TAG20130802T114457
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/database/sybo3/oradata/users01.dbf
output file name=/u01/database/sybo3/oradata/users01.dbf tag=TAG20130802T114457
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 02-AUG-13
sql statement: alter system archive log current
contents of Memory Script:
{
backup as copy reuse --->该命令块备份归档日志
archivelog like "/u01/database/sybo3/fra/SYBO3/archivelog/2013_08_02/o1_mf_1_43_8zpbwsry_.arc" auxiliary format
"/u01/database/sybo3/fra/SYBO3/archivelog/2013_08_02/o1_mf_1_43_%u_.arc" ;
catalog clone recovery area; --->而且克隆整个recovery area
switch clone datafile all;
}
executing Memory Script
Starting backup at 02-AUG-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=43 RECID=48 STAMP=822397594
output file name=/u01/database/sybo3/fra/SYBO3/archivelog/2013_08_02/o1_mf_1_43_1aog9ikr_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 02-AUG-13
searching for all files in the recovery area
List of Files Unknown to the Database
=====================================
File Name: /u01/database/sybo3/fra/SYBO3/archivelog/2013_08_02/o1_mf_1_43_1aog9ikr_.arc
cataloging files...
cataloging done
List of Cataloged Files --->这个地方列出了已经传送到Auxiliary Server的数据文件，以及归档日志
=======================
File Name: /u01/database/sybo3/fra/SYBO3/archivelog/2013_08_02/o1_mf_1_43_1aog9ikr_.arc
datafile 1 switched to datafile copy
input datafile copy RECID=5 STAMP=822397596 file name=/u01/database/sybo3/oradata/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=6 STAMP=822397596 file name=/u01/database/sybo3/oradata/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=7 STAMP=822397596 file name=/u01/database/sybo3/oradata/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=8 STAMP=822397596 file name=/u01/database/sybo3/oradata/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=9 STAMP=822397596 file name=/u01/database/sybo3/oradata/example01.dbf
contents of Memory Script:
{
set until scn 1234019;
recover --->这个命令块开始recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 02-AUG-13
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 43 is already on disk as file /u01/database/sybo3/fra/SYBO3/archivelog/
2013_08_02/o1_mf_1_43_1aog9ikr_.arc
archived log file name=/u01/database/sybo3/fra/SYBO3/archivelog/2013_08_02/o1_mf_1_43_1aog9ikr_.arc thread=1 sequence=43
media recovery complete, elapsed time: 00:00:00
Finished recover at 02-AUG-13
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount; --->该命令块修改参数以及重建控制文件
sql clone "alter system set db_name =
''SYBO3'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 376635392 bytes
Fixed Size 1336652 bytes
Variable Size 285215412 bytes
Database Buffers 83886080 bytes
Redo Buffers 6197248 bytes
sql statement: alter system set db_name = ''SYBO3'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 376635392 bytes
Fixed Size 1336652 bytes
Variable Size 285215412 bytes
Database Buffers 83886080 bytes
Redo Buffers 6197248 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "SYBO3" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 SIZE 50 M ,
GROUP 2 SIZE 50 M ,
GROUP 3 SIZE 50 M
DATAFILE
'/u01/database/sybo3/oradata/system01.dbf'
CHARACTER SET AL32UTF8
contents of Memory Script:
{
set newname for tempfile 1 to --->将数据文件，临时文件更新到控制文件
"/u01/database/sybo3/oradata/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/u01/database/sybo3/oradata/sysaux01.dbf",
"/u01/database/sybo3/oradata/undotbs01.dbf",
"/u01/database/sybo3/oradata/users01.dbf",
"/u01/database/sybo3/oradata/example01.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/database/sybo3/oradata/temp01.dbf in control file
cataloged datafile copy
datafile copy file name=/u01/database/sybo3/oradata/sysaux01.dbf RECID=1 STAMP=822397612
cataloged datafile copy
datafile copy file name=/u01/database/sybo3/oradata/undotbs01.dbf RECID=2 STAMP=822397612
cataloged datafile copy
datafile copy file name=/u01/database/sybo3/oradata/users01.dbf RECID=3 STAMP=822397612
cataloged datafile copy
datafile copy file name=/u01/database/sybo3/oradata/example01.dbf RECID=4 STAMP=822397612
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=822397612 file name=/u01/database/sybo3/oradata/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=822397612 file name=/u01/database/sybo3/oradata/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=822397612 file name=/u01/database/sybo3/oradata/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=822397612 file name=/u01/database/sybo3/oradata/example01.dbf
contents of Memory Script:
{
Alter clone database open resetlogs; --->open 数据库
}
executing Memory Script
database opened
Finished Duplicate Db at 02-AUG-13
f、验证结果
[oracle@linux4 ~]$ sqlplus / as sysdba
SQL> select * from t;
NAME ACTION
---------- --------------------
Robinson Transfer DB
Jackson Transfer DB by rman
SQL> set linesize 190
SQL> select host_name,instance_name from v$instance;
HOST_NAME INSTANCE_NAME
------------------------------------ ----------------
linux4.orasrv.com sybo3
5、后记
a、无论使用何种方式进行数据库克隆，都是使用了基于时间点的不完全恢复，都需要使用open resetlog方式打开数据库。
b、从活动数据库进行克隆时，需要保证Target DB处于归档模式。
c、从活动数据库进行克隆应当保证Target Server与Auxiliary Server 的tnsnames文件中都存在到Target DB与Auxiliary DB的连接字符串。
d、可以在Target Server与Auxiliary Server任意一端发布duplicate database to newdb from active database进行克隆。
e、从活动数据库克隆应保证Traget DB与Auxiliary DB具有相同的密码(位于密码文件)或者直接从Target Server复制密码文件到Auxiliary Server。
相关参考
RMAN 数据库克隆文件位置转换方法
基于RMAN的异机数据库克隆(rman duplicate)
基于 RMAN 的同机数据库克隆
基于用户管理的同机数据库克隆
RMAN duplicate from active 时遭遇 ORA-17627 ORA-12154
Oracle 冷备份
Oracle 热备份
Oracle 备份恢复概念
Oracle 实例恢复
Oracle 基于用户管理恢复的处理
SYSTEM 表空间管理及备份恢复
SYSAUX表空间管理及恢复
Oracle 基于备份控制文件的恢复(unsing backup controlfile)
RMAN 概述及其体系结构
RMAN 配置、监控与管理
RMAN 备份详解
RMAN 还原与恢复
RMAN catalog 的创建和使用
基于catalog 创建RMAN存储脚本
基于catalog 的RMAN 备份与恢复
RMAN 备份路径困惑
自定义 RMAN 显示的日期时间格式
只读表空间的备份与恢复
Oracle 基于用户管理的不完全恢复
理解 using backup controlfile
使用RMAN实现异机备份恢复(WIN平台)
使用RMAN迁移文件系统数据库到ASM
基于Linux下 Oracle 备份策略(RMAN)
Linux 下RMAN备份shell脚本
使用RMAN迁移数据库到异机
RMAN 提示符下执行SQL语句
Oracle 基于 RMAN 的不完全恢复(incomplete recovery by RMAN)
rman 还原归档日志(restore archivelog)