Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

0

好友

1

主题
1#
发表于 2011-12-9 15:45:07 | 查看: 10417| 回复: 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

怎么成这样了
3#
发表于 2011-12-9 18:06:17

回复 2# 的帖子

谢谢大师指点迷津, 问题已解决。

回复 只看该作者 道具 举报

2#
发表于 2011-12-9 16:35:27
*.log_file_name_convert 设置有误 或者说没有针对+FRA/orcl/的 路径做对应的 映射

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-24 00:14 , Processed in 0.046239 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569