Oracle性能调优:在winxp上创建物理standby4
正在执行内存脚本启动 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";
Oracle性能调优:在winxp上创建物理standby4
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;
}
正在执行内存脚本
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_archive_max_processes = 5 comment= '''' scope=spfile
sql 语句: alter system set fal_client = ''standby'' comment= '''' scope=spfile
Oracle性能调优:在winxp上创建物理standby4
sql 语句: alter system set fal_server = ''primary'' comment= '''' scope=spfilesql 语句: alter system set standby_file_management = ''AUTO'' comment= '''' scope=spfile
sql 语句: alter system set log_archive_config = ''dg_config=(primary,standby)'' comment= '''' scope=spfile
sql 语句: alter system set log_archive_dest_1 = ''service=primary ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=primary'' comment= '''' scope=spfile
Oracle 实例已关闭
已连接到辅助数据库 (未启动)
Oracle 实例已启动
系统全局区域总计 313860096 字节
Fixed Size 1374304 字节
Variable Size 104859552 字节
Database Buffers 201326592 字节
Redo Buffers 6299648 字节
内存脚本的内容:
{
backup as copy current controlfile for standby auxiliary format 'C:\ORACLE\ORADATA\STANDBY\CONTROL01.CTL';
}
正在执行内存脚本
启动 backup 于 17-6月 -12
使用通道 ORA_DISK_1
通道 ORA_DISK_1: 启动数据文件副本
复制备用控制文件
输出文件名=C:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFPRIMARY.ORA 标记=TAG20120617T204715 RECID=2 STAMP=786228436
通道 ORA_DISK_1: 数据文件复制完毕, 经过时间: 00:00:03
完成 backup 于 17-6月 -12
页:
[1]