題記：可以使用rman 的duplicate命令直接把asm儲存的資料庫複製到檔案管理的系統，本文就是基於這樣的情況。。。。。

有關rman的另外2篇文章：

http://blog.itpub.net/26736162/viewspace-1223253/

http://blog.itpub.net/26736162/viewspace-1223247/

duplicate體系結構

搞點英語出來吧，英語不好的哥們就好好翻譯翻譯吧，這段英語是必須看懂的。。。。

You can duplicate a source database to a destination database, which can be on the same or different computers. The database instance associated with the duplicate database is called the auxiliary instance. All duplication techniques require a connection to the auxiliary instance. The diagram shows you the following techniques for database duplication:

From an active database, connected to the target and auxiliary instances
From backup, connected to the target and auxiliary instances
From backup, connected to the auxiliary instance, not connected to the target, but with recovery catalog connection
From backup, connected to the auxiliary instance, not connected to the target and the recovery catalog

Choosing a technique to duplicate your database—always with connection to the auxiliary instance:

簡單點就是 ①基於備份，而基於備份又分為3種情況 ②基於活動資料庫

本次實驗簡介

本次實驗就是基於備份，但是不連線到目標資料庫，也不連線到恢復目錄。

When you duplicate a database without a target database connection and without a recovery catalog, RMAN uses a BACKUP LOCATION where all necessary backups and copies reside.

The diagram illustrates backup-based duplication without connections to the target or to the recovery catalog database instance. A disk backup location containing all the backups or copies for duplication must be available to the destination host.

本次實驗原理圖

環境及搭建要求

環境：

source host ：192.168.59.130 sid：orclasm database：11gR2 檔案系統：ASM系統
Destination host ：192.168.59.135 sid：orcl database：11gR2

注意事項說明：

這裡列出source database主要是為了備份
源資料庫和輔助資料庫的幾種不同名稱：source/target database ----&gt>>>>----- (destination host)/duplicate database (auxiliary instance)
源資料庫是ASM管理的，目標資料庫是檔案管理系統的
源資料庫開啟了資料庫閃回，塊改變跟蹤，屬於歸檔模式

source database環境

C:\Users\Administrator>sqlplus sys/lhr@orclasm as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期二 7月 22 11:34:45 2014

連線到:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> select * from v$version where rownum=1;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

SQL> archive log list;

資料庫日誌模式存檔模式

自動存檔啟用

存檔終點 USE_DB_RECOVERY_FILE_DEST

最早的聯機日誌序列 290

下一個存檔日誌序列 292

當前日誌序列 292

SQL>

select * from v$block_change_tracking;

對輔助資料庫的要求

輔助資料庫應該提前安裝好資料庫，配置好環境變數。。。。。

輔助資料庫的環境變數配置：

[oracle@testdb dbs]$ more ~/.bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

export PATH=$PATH:$HOME/bin

# for oracle user

unset USERNAME

export GLOBAL_DB_UNIQUE_NAME=orcl

export ORACLE_HOSTNAME=192.168.59.135

export ORACLE_UNQNAME=orcl

export EDITOR=vi

export ORACLE_SID=orcl

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

export PATH=$ORACLE_HOME/bin:$PATH

umask 022

#export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

export SQLPATH=$ORACLE_HOME/sqlplus/admin

alias sqlplus='rlwrap sqlplus'

alias rman='rlwrap rman'

alias asmcmd='rlwrap asmcmd'

alias alert_log='tail -200f $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace/alert_$ORACLE_SID.log'

alias alert_xml='tail -200f $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/alert/log.xml'

alias alert_listener='tail -200f $ORACLE_BASE/diag/tnslsnr/rhel6/listener/trace/listener.log'

正式開始
1. 前期準備
  1. 建表

--登入源資料庫並建立一個新的表

[oracle@rhel6_lhr dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on 星期二 7月 22 11:44:15 2014

連線到:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> set time on;

11:44:15 SQL> SET LONG 99999999;

11:44:15 SQL> set timing on;

11:44:15 SQL> set serveroutput on size 1000000;

11:44:15 SQL> set sqlblanklines on;

11:44:15 SQL> set linesize 800;

11:44:15 SQL> set pagesize 50000;

11:44:15 SQL> set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> "

11:44:15 SYS@orclasm>

create table lhr.test_duplicate(id number,text varchar2(20));

insert into lhr.test_duplicate values(1,'a');

insert into lhr.test_duplicate values(2,'b');

commit;

表已建立。

已用時間: 00: 00: 01.22

11:44:17 SYS@orclasm>

已建立 1 行。

已用時間: 00: 00: 00.25

11:44:17 SYS@orclasm>

已建立 1 行。

已用時間: 00: 00: 00.01

11:44:18 SYS@orclasm>

提交完成。

已用時間: 00: 00: 00.00

11:44:18 SYS@orclasm> select * from lhr.test_duplicate;

ID TEXT

---------- --------------------

1 a

2 b

已用時間: 00: 00: 00.07

11:44:20 SYS@orclasm>

資料庫歸檔模式

讓源資料庫處於歸檔模式：

C:\Users\Administrator>sqlplus sys/lhr@orclasm as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期二 7月 22 11:34:45 2014

連線到:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> archive log list;

資料庫日誌模式存檔模式

自動存檔啟用

存檔終點 USE_DB_RECOVERY_FILE_DEST

最早的聯機日誌序列 290

下一個存檔日誌序列 292

當前日誌序列 292

SQL>

備份資料庫

--做個全備份source database並將備份傳送到destination database

[oracle@rhel6_lhr dbs]$ rman target /

恢復管理器: Release 11.2.0.3.0 - Production on 星期二 7月 22 11:47:07 2014

已連線到目標資料庫: ORCLASM (DBID=3424884828)

RMAN> backup as compressed backupset format '/home/oracle/oracle_bk/orclasm/full_%n_%T_%t_%s.bak' database plus archivelog delete input;

啟動 backup 於 22-7月 -14

當前日誌已存檔

使用通道 ORA_DISK_1

使用通道 ORA_DISK_2

通道 ORA_DISK_1: 正在啟動壓縮的歸檔日誌備份集

通道 ORA_DISK_1: 正在指定備份集內的歸檔日誌

輸入歸檔日誌執行緒=1 序列=294 RECID=290 STAMP=853588692

通道 ORA_DISK_1: 正在啟動段 1 於 22-7月 -14

通道 ORA_DISK_1: 已完成段 1 於 22-7月 -14

段控制程式碼=/home/oracle/oracle_bk/orclasm/full_ORCLASMx_20140722_853588692_16.bak 標記=TAG20140722T115812 註釋=NONE

通道 ORA_DISK_1: 備份集已完成, 經過時間:00:00:01

通道 ORA_DISK_1: 正在刪除歸檔日誌

歸檔日誌檔名=+FRA/orclasm/archivelog/2014_07_22/thread_1_seq_294.262.853588693 RECID=290 STAMP=853588692

完成 backup 於 22-7月 -14

啟動 backup 於 22-7月 -14

使用通道 ORA_DISK_1

使用通道 ORA_DISK_2

通道 ORA_DISK_1: 正在啟動壓縮的全部資料檔案備份集

通道 ORA_DISK_1: 正在指定備份集內的資料檔案

輸入資料檔案: 檔案號=00001 名稱=+DATA/orclasm/datafile/system.256.850260145

輸入資料檔案: 檔案號=00002 名稱=+DATA/orclasm/datafile/sysaux.257.850260145

輸入資料檔案: 檔案號=00006 名稱=+DATA/orclasm/datafile/undotbs2.267.851204361

輸入資料檔案: 檔案號=00007 名稱=+DATA/orclasm/datafile/tbs_rc.268.852116523

通道 ORA_DISK_1: 正在啟動段 1 於 22-7月 -14

通道 ORA_DISK_2: 正在啟動壓縮的全部資料檔案備份集

通道 ORA_DISK_2: 正在指定備份集內的資料檔案

輸入資料檔案: 檔案號=00004 名稱=+DATA/orclasm/datafile/users.259.850260147

輸入資料檔案: 檔案號=00005 名稱=+DATA/orclasm/datafile/example.265.850260295

輸入資料檔案: 檔案號=00003 名稱=+DATA/orclasm/datafile/undotbs1.258.851526539

輸入資料檔案: 檔案號=00008 名稱=+DATA/orclasm/datafile/ts_lhr.269.852632495

通道 ORA_DISK_2: 正在啟動段 1 於 22-7月 -14

通道 ORA_DISK_1: 已完成段 1 於 22-7月 -14

段控制程式碼=/home/oracle/oracle_bk/orclasm/full_ORCLASMx_20140722_853588694_17.bak 標記=TAG20140722T115814 註釋=NONE

通道 ORA_DISK_1: 備份集已完成, 經過時間:00:02:06

通道 ORA_DISK_2: 已完成段 1 於 22-7月 -14

段控制程式碼=/home/oracle/oracle_bk/orclasm/full_ORCLASMx_20140722_853588694_18.bak 標記=TAG20140722T115814 註釋=NONE

通道 ORA_DISK_2: 備份集已完成, 經過時間:00:02:06

完成 backup 於 22-7月 -14

啟動 backup 於 22-7月 -14

當前日誌已存檔

使用通道 ORA_DISK_1

使用通道 ORA_DISK_2

通道 ORA_DISK_1: 正在啟動壓縮的歸檔日誌備份集

通道 ORA_DISK_1: 正在指定備份集內的歸檔日誌

輸入歸檔日誌執行緒=1 序列=295 RECID=291 STAMP=853588821

通道 ORA_DISK_1: 正在啟動段 1 於 22-7月 -14

通道 ORA_DISK_1: 已完成段 1 於 22-7月 -14

段控制程式碼=/home/oracle/oracle_bk/orclasm/full_ORCLASMx_20140722_853588823_19.bak 標記=TAG20140722T120022 註釋=NONE

通道 ORA_DISK_1: 備份集已完成, 經過時間:00:00:01

通道 ORA_DISK_1: 正在刪除歸檔日誌

歸檔日誌檔名=+FRA/orclasm/archivelog/2014_07_22/thread_1_seq_295.262.853588821 RECID=291 STAMP=853588821

完成 backup 於 22-7月 -14

啟動 Control File Autobackup 於 22-7月 -14

段 handle=/home/oracle/oracle_bk/orclasm/control_c-3424884828-20140722-01.bak comment=NONE

完成 Control File Autobackup 於 22-7月 -14

RMAN> list backup;

備份集列表

===================

BS 關鍵字大小裝置型別佔用時間完成時間

------- ---------- ----------- ------------ ----------

15 955.50K DISK 00:00:00 22-7月 -14

BP 關鍵字: 15 狀態: AVAILABLE 已壓縮: YES 標記: TAG20140722T115812

段名:/home/oracle/oracle_bk/orclasm/full_ORCLASMx_20140722_853588692_16.bak

備份集 15 中的已存檔日誌列表

執行緒序列低 SCN 時間下限下一個 SCN 下一次

---- ------- ---------- ---------- ---------- ---------

1 294 7503944 22-7月 -14 7504825 22-7月 -14

BS 關鍵字型別 LV 大小裝置型別經過時間完成時間

------- ---- -- ---------- ----------- ------------ ----------

16 Full 128.61M DISK 00:02:03 22-7月 -14

BP 關鍵字: 16 狀態: AVAILABLE 已壓縮: YES 標記: TAG20140722T115814

段名:/home/oracle/oracle_bk/orclasm/full_ORCLASMx_20140722_853588694_18.bak

備份集 16 中的資料檔案列表

檔案 LV 型別 Ckp SCN Ckp 時間名稱

---- -- ---- ---------- ---------- ----

3 Full 7504837 22-7月 -14 +DATA/orclasm/datafile/undotbs1.258.851526539

4 Full 7504837 22-7月 -14 +DATA/orclasm/datafile/users.259.850260147

5 Full 7504837 22-7月 -14 +DATA/orclasm/datafile/example.265.850260295

8 Full 7504837 22-7月 -14 +DATA/orclasm/datafile/ts_lhr.269.852632495

BS 關鍵字型別 LV 大小裝置型別經過時間完成時間

------- ---- -- ---------- ----------- ------------ ----------

17 Full 328.95M DISK 00:02:04 22-7月 -14

BP 關鍵字: 17 狀態: AVAILABLE 已壓縮: YES 標記: TAG20140722T115814

段名:/home/oracle/oracle_bk/orclasm/full_ORCLASMx_20140722_853588694_17.bak

備份集 17 中的資料檔案列表

檔案 LV 型別 Ckp SCN Ckp 時間名稱

---- -- ---- ---------- ---------- ----

1 Full 7504835 22-7月 -14 +DATA/orclasm/datafile/system.256.850260145

2 Full 7504835 22-7月 -14 +DATA/orclasm/datafile/sysaux.257.850260145

6 Full 7504835 22-7月 -14 +DATA/orclasm/datafile/undotbs2.267.851204361

7 Full 7504835 22-7月 -14 +DATA/orclasm/datafile/tbs_rc.268.852116523

BS 關鍵字大小裝置型別佔用時間完成時間

------- ---------- ----------- ------------ ----------

18 847.50K DISK 00:00:00 22-7月 -14

BP 關鍵字: 18 狀態: AVAILABLE 已壓縮: YES 標記: TAG20140722T120022

段名:/home/oracle/oracle_bk/orclasm/full_ORCLASMx_20140722_853588823_19.bak

備份集 18 中的已存檔日誌列表

執行緒序列低 SCN 時間下限下一個 SCN 下一次

---- ------- ---------- ---------- ---------- ---------

1 295 7504825 22-7月 -14 7505140 22-7月 -14

BS 關鍵字型別 LV 大小裝置型別經過時間完成時間

------- ---- -- ---------- ----------- ------------ ----------

19 Full 9.55M DISK 00:00:04 22-7月 -14

BP 關鍵字: 19 狀態: AVAILABLE 已壓縮: NO 標記: TAG20140722T120024

段名:/home/oracle/oracle_bk/orclasm/control_c-3424884828-20140722-01.bak

包括的控制檔案: Ckp SCN: 7505224 Ckp 時間: 22-7月 -14

RMAN>

檢視備份：

將備份內容複製到destination host

[root@rhel6_lhr orclasm]# scp -r /home/oracle/oracle_bk/orclasm/* oracle@192.168.59.135:/home/oracle/ora_bk

oracle@192.168.59.135's password:

control_c-3424884828-20140722-01.bak 100% 9792KB 9.6MB/s 00:00

full_ORCLASMx_20140722_853588692_16.bak 100% 956KB 956.0KB/s 00:00

full_ORCLASMx_20140722_853588694_17.bak 100% 329MB 20.6MB/s 00:16

full_ORCLASMx_20140722_853588694_18.bak 100% 129MB 32.2MB/s 00:04

full_ORCLASMx_20140722_853588823_19.bak 100% 848KB 848.0KB/s 00:00

[root@rhel6_lhr orclasm]#

在destination 庫檢視，確保已經傳遞到：

建立pfile 引數檔案

這個步驟也可以在destination host直接建立，指定一個引數db_name 就可以了。。。。不過這樣存在一些其它的問題，不推薦。。。。

--在source database生成文字初始化引數檔案並傳送到destination host

C:\Users\Administrator>sqlplus sys/lhr@orclasm as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期二 7月 22 12:11:54 2014

連線到:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> create pfile='/tmp/initocl.ora' from spfile;

檔案已建立。

SQL>

這裡用root使用者傳送許可權不足，需要使用Oracle使用者：

[root@rhel6_lhr orclasm]# scp /tmp/initocl.ora oracle@192.168.59.135:$ORACLE_HOME/dbs

oracle@192.168.59.135's password:

scp: /dbs: Permission denied

[root@rhel6_lhr orclasm]# su - oracle

[oracle@rhel6_lhr ~]$ scp /tmp/initocl.ora oracle@192.168.59.135:$ORACLE_HOME/dbs

oracle@192.168.59.135's password:

initocl.ora 100% 1161 1.1KB/s 00:00

[oracle@rhel6_lhr ~]$

確保傳遞到目的地：

[oracle@testdb dbs]$ cd $ORACLE_HOME/dbs

[oracle@testdb dbs]$ ll

total 4

-rw-r--r--. 1 oracle oinstall 1161 Jul 22 12:16 initocl.ora

[oracle@testdb dbs]$

至此與source database就沒有任何關係了。。。。。。。。。

建立和source database的資料檔案相關的目錄結構

這一步至關重要，因為source database 為ASM儲存的，而auxiliary instance為filesystem的，所以相關路徑應該設定合理。

這裡檔名寫錯了，修改一下，先看看傳遞過來的檔案內容：

[oracle@testdb dbs]$ mv initocl.ora initorcl.ora

[oracle@testdb dbs]$ more initorcl.ora

orclasm.__db_cache_size=96468992

orclasm.__java_pool_size=4194304

orclasm.__large_pool_size=4194304

orclasm.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

orclasm.__pga_aggregate_target=209715200

orclasm.__sga_target=381681664

orclasm.__shared_io_pool_size=0

orclasm.__shared_pool_size=260046848

orclasm.__streams_pool_size=4194304

*.audit_file_dest='/u01/app/oracle/admin/orclasm/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='+DATA/orclasm/controlfile/current.260.850260253','+FRA/orclasm/controlfile/current.256.850260253'

*.db_block_size=8192

*.db_create_file_dest='+DATA'

*.db_domain='lhr.com'

*.db_name='orclasm'

*.db_recovery_file_dest='+FRA'

*.db_recovery_file_dest_size=8589934592

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclasmXDB)'

*.job_queue_processes=1000

*.local_listener='LISTENER_ORCLASM'

*.log_archive_format='%t_%s_%r.dbf'

*.memory_target=588251136

*.O7_DICTIONARY_ACCESSIBILITY=TRUE

*.open_cursors=300

*.optimizer_capture_sql_plan_baselines=TRUE

*.processes=500

*.remote_login_passwordfile='EXCLUSIVE'

*.sessions=500

*.undo_retention=60

*.undo_tablespace='UNDOTBS1'

[oracle@testdb dbs]$

應該修改的幾個引數我都用紅色標註出來了，修改後的引數為：

[oracle@testdb dbs]$ more initorcl.ora

orcl.__db_cache_size=96468992

orcl.__java_pool_size=4194304

orcl.__large_pool_size=4194304

orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

orcl.__pga_aggregate_target=209715200

orcl.__sga_target=381681664

orcl.__shared_io_pool_size=0

orcl.__shared_pool_size=260046848

orcl.__streams_pool_size=4194304

*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/u01/app/oracle/oradata/control01.ctl','/u01/app/oracle/oradata/control02.ctl'

*.db_block_size=8192

*.db_create_file_dest='/u01/app/oracle/oradata/'

*.db_domain='lhr.com'

*.db_name='orcl'

*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'

*.db_recovery_file_dest_size=8589934592

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.job_queue_processes=1000

*.log_archive_format='%t_%s_%r.dbf'

*.memory_target=588251136

*.O7_DICTIONARY_ACCESSIBILITY=TRUE

*.open_cursors=300

*.optimizer_capture_sql_plan_baselines=TRUE

*.processes=500

*.remote_login_passwordfile='EXCLUSIVE'

*.sessions=500

*.undo_retention=60

*.undo_tablespace='UNDOTBS1'

[oracle@testdb dbs]$

建立需要的路徑：

[oracle@testdb dbs]$ mkdir -p /u01/app/oracle/admin/orcl/adump

[oracle@testdb dbs]$ mkdir -p /u01/app/oracle/flash_recovery_area

仔細檢查，不能馬虎的。。。。。。。。。。。。。。。。

建立密碼檔案

[oracle@testdb dbs]$ orapwd file=?/dbs/orapworcl password=lhr

[oracle@testdb dbs]$ ll

total 8

-rw-r--r--. 1 oracle oinstall 1153 Jul 22 12:29 initocl.ora

-rw-r-----. 1 oracle oinstall 1536 Jul 22 12:31 orapworcl

[oracle@testdb dbs]$

實施資料庫的複製

--啟動auxiliary instance到nomount狀態

啟動Auxiliary 到nomout 狀態

[oracle@testdb dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 22 12:42:59 2014

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 588746752 bytes

Fixed Size 2230592 bytes

Variable Size 482346688 bytes

Database Buffers 96468992 bytes

Redo Buffers 7700480 bytes

SQL>

告警日誌：

[oracle@testdb trace]$ more alert_orcl.log

Tue Jul 22 12:43:01 2014

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on.

IMODE=BR

ILAT =84

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options.

ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1

System name: Linux

Node name: testdb

Release: 2.6.32-431.el6.x86_64

Version: #1 SMP Sun Nov 10 22:19:54 EST 2013

Machine: x86_64

VM name: VMWare Version: 6

Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora

System parameters with non-default values:

processes = 500

sessions = 772

memory_target = 564M

control_files = "/u01/app/oracle/oradata/control01.ctl"

control_files = "/u01/app/oracle/oradata/control02.ctl"

db_block_size = 8192

compatible = "11.2.0.0.0"

log_archive_format = "%t_%s_%r.dbf"

db_create_file_dest = "/u01/app/oracle/oradata/"

db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area"

db_recovery_file_dest_size= 8G

undo_tablespace = "UNDOTBS1"

undo_retention = 60

O7_DICTIONARY_ACCESSIBILITY= TRUE

remote_login_passwordfile= "EXCLUSIVE"

db_domain = "lhr.com"

dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"

job_queue_processes = 1000

audit_file_dest = "/u01/app/oracle/admin/orcl/adump"

audit_trail = "DB"

db_name = "orcl"

open_cursors = 300

optimizer_capture_sql_plan_baselines= TRUE

diagnostic_dest = "/u01/app/oracle"

Tue Jul 22 12:43:02 2014

PMON started with pid=2, OS id=7129

Tue Jul 22 12:43:02 2014

PSP0 started with pid=3, OS id=7131

Tue Jul 22 12:43:03 2014

VKTM started with pid=4, OS id=7133 at elevated priority

VKTM running at (1)millisec precision with DBRM quantum (100)ms

Tue Jul 22 12:43:03 2014

GEN0 started with pid=5, OS id=7137

Tue Jul 22 12:43:03 2014

DIAG started with pid=6, OS id=7139

Tue Jul 22 12:43:03 2014

DBRM started with pid=7, OS id=7141

Tue Jul 22 12:43:04 2014

DIA0 started with pid=8, OS id=7143

Tue Jul 22 12:43:04 2014

MMAN started with pid=9, OS id=7145

Tue Jul 22 12:43:04 2014

DBW0 started with pid=10, OS id=7147

Tue Jul 22 12:43:04 2014

LGWR started with pid=11, OS id=7149

Tue Jul 22 12:43:04 2014

CKPT started with pid=12, OS id=7151

Tue Jul 22 12:43:04 2014

SMON started with pid=13, OS id=7153

Tue Jul 22 12:43:04 2014

RECO started with pid=14, OS id=7155

Tue Jul 22 12:43:04 2014

MMON started with pid=15, OS id=7157

Tue Jul 22 12:43:04 2014

MMNL started with pid=16, OS id=7159

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

starting up 1 shared server(s) ...

ORACLE_BASE from environment = /u01/app/oracle

[oracle@testdb trace]$

連線到auxiliary instance並複製資料庫

先準備run塊，在source database上：

select 'set newname for datafile '||a.FILE#||' to "'||a.NAME||'";' from v$datafile a

union all

select 'set newname for tempfile '||a.FILE#||' to "'||a.NAME||'";' from v$tempfile a;

修改一下檔名，加入logfile，注意controlfile已經在pfile中指定了：

RUN{

set newname for datafile 1 to "/u01/app/oracle/oradata/system.dbf";

set newname for datafile 2 to "/u01/app/oracle/oradata/sysaux.dbf";

set newname for datafile 3 to "/u01/app/oracle/oradata/undotbs1.dbf";

set newname for datafile 4 to "/u01/app/oracle/oradata/users.dbf";

set newname for datafile 5 to "/u01/app/oracle/oradata/example.dbf";

set newname for datafile 6 to "/u01/app/oracle/oradata/undotbs2.dbf";

set newname for datafile 7 to "/u01/app/oracle/oradata/tbs_rc.dbf";

set newname for datafile 8 to "/u01/app/oracle/oradata/ts_lhr.dbf";

set newname for tempfile 1 to '/u01/app/oracle/oradata/TEMP01.DBF';

duplicate target database to orcl backup location '/home/oracle/ora_bk' nofilenamecheck

LOGFILE

'/u01/app/oracle/oradata/redo01.log' SIZE 20M,

'/u01/app/oracle/oradata/redo02.log' SIZE 20M,

'/u01/app/oracle/oradata/redo03.log' SIZE 20M;

}

在這裡也可以多分配幾個通道，加快恢復速度：

RUN{

ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;

ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;

set newname for datafile 1 to "/u01/app/oracle/oradata/system01.dbf";

set newname for datafile 2 to "/u01/app/oracle/oradata/sysaux01.dbf";

set newname for datafile 3 to "/u01/app/oracle/oradata/undotbs1.dbf";

set newname for datafile 4 to "/u01/app/oracle/oradata/users01.dbf";

set newname for datafile 5 to "/u01/app/oracle/oradata/example.dbf";

set newname for datafile 6 to "/u01/app/oracle/oradata/undotbs2.dbf";

set newname for datafile 7 to "/u01/app/oracle/oradata/tbs_rc.dbf";

set newname for datafile 8 to "/u01/app/oracle/oradata/ts_lhr.dbf";

set newname for tempfile 1 to '/u01/app/oracle/oradata/temp01.DBF';

duplicate target database to orcl backup location '/home/oracle/ora_bk' nofilenamecheck

LOGFILE

'/u01/app/oracle/oradata/redo01.log' SIZE 20M,

'/u01/app/oracle/oradata/redo02.log' SIZE 20M,

'/u01/app/oracle/oradata/redo03.log' SIZE 20M;

}

恢復的時候就是2個通道恢復：

開始：

[oracle@testdb trace]$ rman auxiliary /

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 22 12:45:25 2014

connected to auxiliary database: ORCL (not mounted)