使用RMAN Duplicate方法搭建异名数据库实验(一)

2014-11-24 17:24:47 · 作者: · 浏览: 2

target就是进行备份操作的源数据库,我们进行备份还原的对象都是在这个库上进行。默认情况下,备份集合信息是保存在controlfile,catalog是一个可选数据库,备份元数据可以单独放在catalog数据库中保存。auxiliary是作为辅助操作进行的,一些与备份还原相关的操作,都可以利用auxiliary上完成。

本篇从10g数据库入手,实验在相同host上构建不同名clone数据库。注意:在其他主机上进行clone操作完全相同。


推荐阅读:


1、环境介绍



我们选择Oracle 10gR2进行测试,Linux环境主机。



SQL> select * from v$version;


BANNER


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


Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod


PL/SQL Release 10.2.0.1.0 - Production


CORE 10.2.0.1.0 Production


TNS for Linux: Version 10.2.0.1.0 - Production


NLSRTL Version 10.2.0.1.0 – Production



2、Target数据库备份



当前数据库没有选择catalog,采用controlfile进行备份文件。数据库实例名称为oratest,作为数据源。此时备份信息如下:



RMAN> list backup;



List of Backup Sets


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


BS Key Type LV Size Device Type Elapsed Time Completion Time


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


13 Full 595.90M DISK 00:00:30 05-MAR-14


BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20140305T111526


Piece Name: /u01/app/oracle/flash_recovery_area/ORATEST/backupset/2014_03_05/o1_mf_nnndf_TAG20140305T111526_9kf5pgf2_.bkp


(篇幅原因,有省略……)


BS Key Size Device Type Elapsed Time Completion Time


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


15 15.07M DISK 00:00:02 05-MAR-14


BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20140305T112405


Piece Name: /u01/app/oracle/flash_recovery_area/ORATEST/backupset/2014_03_05/o1_mf_annnn_TAG20140305T112405_9kf66ppv_.bkp


List of Archived Logs in backup set 15


Thrd Seq Low SCN Low Time Next SCN Next Time


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


1 2 576174 04-MAR-14 578638 05-MAR-14


1 3 578638 05-MAR-14 578643 05-MAR-14


1 4 578643 05-MAR-14 578677 05-MAR-14



BS Key Type LV Size Device Type Elapsed Time Completion Time


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


16 Full 6.80M DISK 00:00:01 05-MAR-14


BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20140305T112407


Piece Name: /u01/app/oracle/flash_recovery_area/ORATEST/autobackup/2014_03_05/o1_mf_s_841404247_9kf66qvs_.bkp

Control File Included: Ckp SCN: 578684 Ckp time: 05-MAR-14


SPFILE Included: Modification time: 05-MAR-14



注意:在备份过程中,一定要有一个单独的backup archivelog all的过程,将归档日志作为单独备份集合保存。如果不进行这个操作,在进行duplicate过程中会出现错误。


RMAN> backup archivelog all;



Starting backup at 05-MAR-14


(篇幅原因,有省略……)


Starting Control File and SPFILE Autobackup at 05-MAR-14


piece handle=/u01/app/oracle/flash_recovery_area/ORATEST/autobackup/2014_03_05/o1_mf_s_841404247_9kf66qvs_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 05-MAR-14



在进行duplicate操作过程中,target数据库最好维持mount状态!



3、网络配置



无论是在本机还是异地进行duplicate构建,保证target和auxiliary互联是重要的。所以在TNS连接方面,要进行配置过程。


Oracle Net配置三个文件,listener.ora、tnsnames.ora和sqlnet.ora。起码要保证tnsnames.ora的互联配置。



[oracle@SimpleLinuxUp admin]$ cat tnsnames.ora


# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.



ORATEST = --target


(DESCRIPTION =


(ADDRESS_LIST =


(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))


)


(CONNECT_DATA =


(SERVICE_NAME = oratest)


)


)



ORAAUX = --目标auxiliary


(DESCRIPTION =


(ADDRESS_LIST