将IBS库复制为orcl1库。
在两个库上创建密码文件：
orapwd file=F:\BBCLDB\ORCL1\PWDibs1.ora password=system entries=30
set oracle_sid=orcl1
orapwd file=F:\BBCLDB\ORCL1\PWDorcl1.ora password=system entries=30
创建一个新的服务
oradim -NEW -SID orcl1
修改主库、辅助数据库的监听 tnsname.ora文件
IBS 的参数文件：
ibs.__db_cache_size=18253611008
ibs.__java_pool_size=134217728
ibs.__large_pool_size=134217728
ibs.__oracle_base='e:\app\Administrator'#ORACLE_BASE set from environment
ibs.__pga_aggregate_target=15971909632
ibs.__sga_target=22951231488
ibs.__shared_io_pool_size=0
ibs.__shared_pool_size=4026531840
ibs.__streams_pool_size=134217728
*.audit_file_dest='e:\app\Administrator\admin\IBS\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='F:\BBCLDB\IBS\IBS\control01.ctl','e:\app\Administrator\flash_recovery_area\IBS\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='IBS'
*.db_recovery_file_dest='e:\app\Administrator\flash_recovery_area'
*.db_recovery_file_dest_size=536870912000
*.diagnostic_dest='e:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=IBSXDB)'
*.memory_target=8848692224
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
*.log_archive_format='ARC%S_%R.%T'
*.log_file_name_convert='F:\BBCLDB\IBS\IBS','F:\BBCLDB\ORCL1'
*.db_file_name_convert='F:\BBCLDB\IBS\IBS','F:\BBCLDB\ORCL1'
orcl1的参数文件：
orcl1.__db_cache_size=25769803776
orcl1.__java_pool_size=134217728
orcl1.__large_pool_size=134217728
orcl1.__oracle_base='e:\app\Administrator'#ORACLE_BASE set from environment
orcl1.__pga_aggregate_target=31406948352
orcl1.__sga_target=30467424256
orcl1.__shared_io_pool_size=0
orcl1.__shared_pool_size=3758096384
orcl1.__streams_pool_size=268435456
*.audit_file_dest='e:\app\Administrator\admin\ORCL1\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='e:\app\Administrator\oradata\ORCL1\control01.ctl','e:\app\Administrator\flash_recovery_area\ORCL1\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='ORCL1'
*.db_recovery_file_dest='e:\app\Administrator\flash_recovery_area'
*.db_recovery_file_dest_size=4102029312
*.diagnostic_dest='e:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCL1XDB)'
*.memory_target=9842915328
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sec_case_sensitive_logon=FALSE
*.undo_tablespace='UNDOTBS1'
*.log_archive_format='ARC%S_%R.%T'
*.log_file_name_convert='F:\BBCLDB\IBS\IBS','F:\BBCLDB\ORCL1'
*.db_file_name_convert='F:\BBCLDB\IBS\IBS','F:\BBCLDB\ORCL1'
两个文件中主要是这三行要加上。
set oracle_sid=ibs
C:\Users\Administrator>rman target sys/system auxiliary sys/system@orcl1
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Dec 30 18:09:41 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: IBS (DBID=623540487)
connected to auxiliary database: ORCL1 (not mounted)
RMAN> DUPLICATE TARGET DATABASE TO orcl1 from active database nofilenamecheck;
Starting Duplicate Db at 30-DEC-11
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=201 device type=DISK
contents of Memory Script: