Oracle 11.2.0.1.0通过rman在win xp上创建物理standby(四)
ment='AUTO'
13> set log_archive_config='dg_config=(primary,standby)'
14> set log_archive_dest_1='service=primary ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=primary'
15> ;
16> }
启动 Duplicate Db 于 17-6月 -12
使用目标数据库控制文件替代恢复目录
分配的通道: ORA_AUX_DISK_1
通道 ORA_AUX_DISK_1: SID=96 设备类型=DISK
内存脚本的内容:
{ www.2cto.com
backup as copy reuse
targetfile 'c:\oracle\product\11.2.0\dbhome_1\DATABASE\PWDprimary.ORA' auxiliary format
'c:\oracle\product\11.2.0\dbhome_1\DATABASE\PWDstandby.ORA' targetfile
'C:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEPRIMARY.ORA' auxiliary format
'C:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILESTANDBY.ORA' ;
sql clone "alter system set spfile= ''C:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILESTANDBY.ORA''";
}
正在执行内存脚本
启动 backup 于 17-6月 -12
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID=146 设备类型=DISK
完成 backup 于 17-6月 -12
sql 语句: alter system set spfile= ''C:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILESTANDBY.ORA''
内存脚本的内容:
{
sql clone "alter system set audit_file_dest =
''c:\oracle\admin\standby\adump'' comment=
'''' scope=spfile";
sql clone "alter system set dispatchers =
''(PROTOCOL=TCP) (SERVICE=standbyXDB)'' comment=
'''' scope=spfile";
sql clone "alter system set db_unique_name =
''standby'' comment=
'''' scope=spfile";
sql clone "alter system set db_file_name_convert =
''\primary\'', ''\standby\'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''\primary\'', ''\standby\'' comment=
'''' scope=spfile";
sql clone "alter system set control_files =
''C:\oracle\oradata\standby\CONTROL01.CTL'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_max_processes =
5 comment=
'''' scope=spfile";
sql clone "alter system set fal_client =
''standby'' comment=
'''' scope=spfile";
sql clone "alter system set fal_server =
''primary'' comment=
'''' scope=spfile";
sql clone "alter system set standby_file_management =
''AUTO'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_config =
''dg_config=(primary,standby)'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_1 =
''service=primary ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=primary'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
正在执行内存脚本
www.2cto.com
sql 语句: alter system set audit_file_dest = ''c:\oracle\admin\standby\adump'' comment= '''' scope=spfile
sql 语句: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=standbyXDB)'' comment= '''' scope=spfile
sql 语句: alter system set db_unique_name = ''standby'' comment= '''' scope=spfile
sql 语句: alter system set db_file_name_convert = ''\primary\'', ''\standby\'' comment= '''' scope=spfile
sql 语句: alter system set log_file_name_convert = ''\primary\'', ''\standby\'' comment= '''' scope=spfile
sql 语句: alter system set control_files = ''C:\oracle\oradata\standby\CONTROL01.CTL'' comment= '''' scope=spfile
sql 语句: alter system set log_