- 最后登录
- 2013-6-24
- 在线时间
- 8 小时
- 威望
- 0
- 金钱
- 50
- 注册时间
- 2011-11-4
- 阅读权限
- 10
- 帖子
- 12
- 精华
- 0
- 积分
- 0
- UID
- 90
|
1#
发表于 2011-12-9 15:45:07
|
查看: 10359 |
回复: 2
原贴是:http://www.itpub.net/thread-1506500-1-1.html
确实 我也遇到这样的问题了,坛子没人处理,贴过来 请高人判断。
主库为linux+11g r2 rac+asm,两个节点,备库是linux+11g r2+local disk
在主库上执行
RMAN>run{
allocate channel prmy1 type disk;
allocate auxiliary channel stby type disk;
set newname for tempfile 1 to '/oradata/orasby1/temp01.dbf';
duplicate target database for standby from active database;
}
......
input datafile copy RECID=19 STAMP=765872188 file name=/oradata/orasby1/sp_is.269.765760195
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-03114: not connected to ORACLE
Process ID: 20174
Session ID: 571 Serial number: 7
RMAN-05535: WARNING: All redo log files were not defined properly.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/29/2011 08:08:20
RMAN-06136: ORACLE error from auxiliary database: ORA-03114: not connected to ORACLE
查看备机日志:
Switch of datafile 7 complete to datafile copy
checkpoint is 1553988
alter database clear logfile group 1
Clearing online log 1 of thread 1 sequence number 103
ERROR: slave communication error with ASM; terminating process 7708
Errors in file /u01/app/oracle/diag/rdbms/orasby1/orasby1/trace/orasby1_ora_7708.trc:
ORA-00312: online log 1 thread 1: '/oradata/orasby1//group_1.261.765713687'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
备库的spfile
*.audit_file_dest='/u01/app/oracle/admin/orasby1/adump'
*.compatible='11.2.0.0.0'
*.control_files='/oradata/orasby1/control01.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_unique_name='orasby1'
*.service_names='orcl'
*.diagnostic_dest='/u01/app/oracle'
*.memory_target=2194304000
*.open_cursors=300
*.processes=1500
*.sessions=1655
*.db_file_name_convert='+DATA/orcl/datafile','/oradata/orasby1/'
*.log_file_name_convert='+DATA/orcl/onlinelog','/oradata/orasby1/'
*.log_archive_max_processes='5'
*.FAL_CLIENT ='orasby1'
*.FAL_SERVER ='orcl'
*.standby_file_management='AUTO'
*.log_archive_config='dg_config=(orcl,orasby1)'
*.log_archive_dest_1='location=/oradata/archive/'
*.undo_tablespace='UNDOTBS1'
备机上
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/oradata/orasby1//group_2.262.765713687
+FRA/orcl/onlinelog/group_2.258.765713687
/oradata/orasby1//group_1.261.765713687
+FRA/orcl/onlinelog/group_1.257.765713687
/oradata/orasby1//group_3.265.765713887
+FRA/orcl/onlinelog/group_3.259.765713887
/oradata/orasby1//group_4.266.765713887
+FRA/orcl/onlinelog/group_4.260.765713887
怎么成这样了 |
|