window 2003+oracle11g，两台服务器
根据ORACLE官方文档《创建物理备用数据库》
http://www.oracle.com/technology ... sstby/physstdby.htm
C:\>rman target sys/admin auxiliary sys/admin@orclsby1 log=c:\log.log
run{
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'orcl','orclsby1'
set db_unique_name 'orclsby1'
set db_file_name_convert='z:\oracle\oradata\orcl','z:\oracle\oradata\orclsby1'
set log_file_name_convert='z:\oracle\oradata\orcl','z:\oracle\oradata\orclsby1'
set control_files='z:\oracle\oradata\orclsby1\orclsby1.ctl'
set log_archive_max_processes='5'
set FAL_CLIENT 'orclsby1'
set FAL_SERVER 'orcl'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(orcl,orclsby1)'
set log_archive_dest_1='service=orcl async
VALID_FOR=(ALL_LOGFILES,ALL_ROLES) db_unique_name=orcl'
;
}
恢复管理器: Release 11.1.0.6.0 - Production on 星期一 5月 18 21:26:10 2009
Copyright (c) 1982, 2007, Oracle.All rights reserved.
连接到目标数据库: ORCL (DBID=1214987113)
已连接到辅助数据库: ORCLSBY1 (未装载)
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22>
使用目标数据库控制文件替代恢复目录
分配的通道: prmy1
通道 prmy1: SID=134 设备类型=DISK
分配的通道: prmy2
通道 prmy2: SID=130 设备类型=DISK
分配的通道: prmy3
通道 prmy3: SID=127 设备类型=DISK
分配的通道: prmy4
通道 prmy4: SID=131 设备类型=DISK
分配的通道: stby
通道 stby: SID=98 设备类型=DISK
启动 Duplicate Db 于 18-5月 -09
内存脚本的内容:
{
backup as copy reuse
file'd:\oracle\db_1\DATABASE\PWDorcl.ORA' auxiliary format
'd:\oracle\db_1\DATABASE\PWDorclsby1.ORA' file
'D:\ORACLE\DB_1\DATABASE\SPFILEORCL.ORA' auxiliary format
'D:\ORACLE\DB_1\DATABASE\SPFILEORCLSBY1.ORA' ;
sql clone "alter system set spfile= ''D:\ORACLE\DB_1\DATABASE\SPFILEORCLSBY1.ORA''";
}
正在执行内存脚本
启动 backup 于 18-5月 -09
DBGANY: Mismatched message length! [21:29:45.843] (krmiduem)
DBGANY: Mismatched message length! [21:29:45.875] (krmiduem)
MAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: 执行命令期间出现严重错误
RMAN-00600: internal error, arguments [3045] [] [] [] []
RMAN-03009: backup 命令 (prmy1 通道上, 在 05/18/2009 21:29:45 上) 失败
ORA-17627: ORA-12577: Message 12577 not found;product=RDBMS; facility=ORA
|
