基于RMAN的异机数据库克隆(rman duplicate)(二)
atabase/sybo3/adump/'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/database/sybo3/controlf/control01.ctl','/u01/database/sybo3/controlf/control02.ctl'
*.db_block_size=8192
*.db_domain='orasrv.com'
*.db_name='sybo3'
*.db_recovery_file_dest='/u01/database/sybo3/fra'
*.db_recovery_file_dest_size=4039114752
*.dg_broker_config_file1='/u01/database/sybo3/db_broker/dr1sybo3.dat'
*.dg_broker_config_file2='/u01/database/sybo3/db_broker/dr2sybo3.dat'
*.dg_broker_start=FALSE
*.diagnostic_dest='/u01/database/sybo3'
*.log_archive_dest_1=''
*.memory_target=374341632
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
d、生成辅助实例密码文件
--直接使用orapwd命令完成
$ orapwd file=/u01/oracle/db_1/dbs/orapwsybo3 password=oracle entries=10
e、实施数据库克隆
--由于此次测试无需连接到target及catalog，因此可以跳过配置监听，可在克隆完毕后再配置
[oracle@linux4 ~]$ export ORACLE_SID=sybo3
[oracle@linux4 ~]$ sqlplus / as sysdba
SQL> startup nomount; -->启动辅助实例到nomount状态
[oracle@linux4 ~]$ rman auxiliary / -->直接使用auxiliary / 方式连接到辅助数据库
connected to auxiliary database: SYBO3 (not mounted)
RMAN> duplicate target database to sybo3 spfile
2> backup location '/u01/database/sybo3/fra/SYBO3'
3> nofilenamecheck;
Starting Duplicate Db at 31-JUL-13
contents of Memory Script:
{
restore clone spfile to '/u01/oracle/db_1/dbs/spfilesybo3.ora' from --->从自动备份还原spfile文件
'/u01/database/sybo3/fra/SYBO3/autobackup/2013_07_31/o1_mf_s_822220850_8zjy9lp8_.bkp';
sql clone "alter system set spfile= ''/u01/oracle/db_1/dbs/spfilesybo3.ora''";
}
executing Memory Script
Starting restore at 31-JUL-13
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=134 device type=DISK
channel ORA_AUX_DISK_1: restoring spfile from AUTOBACKUP /u01/database/sybo3/fra/SYBO3/autobackup/2013_07_31/o1_mf_s_822220850_8zjy9lp8_.bkp
channel ORA_AUX_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 31-JUL-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 = --->
修改spfile并重启辅助实例
''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 -->下面的命令用于还原控制文件
restore clone primary controlfile from '/u01/database/sybo3/fra/SYBO3/autobackup/2013_07_31/o1_mf_s_822220850_8zjy9lp8_.bkp';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''SYBO3'' c