免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1747 | 回复: 1

关于oracle归档异常 [复制链接]

论坛徽章:
0
发表于 2011-12-15 11:08 |显示全部楼层
环境:oracle10204 aix5308
rman脚本:
bash-3.2$ cat /oracle/rmanscript/rman_arch.sh
rman target / nocatalog msglog /oracle/rmanscript/rman_arch.log append << EOF
run
{
allocate channel c1 type disk;
sql 'alter system archive log current';
backup format '/orabak/15_settle/arch_%s_%p_%t' archivelog from logseq=5608 delete input;
release channel c1;
}
exit;

发现归档异常:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/20/2011 05:00:16
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /arch1/1_18121_679488888.dbf
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


之后再rman模式下运行:
RMAN> change archivelog all crosscheck ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 12/15/2011 10:15:37
RMAN-12010: automatic channel allocation initialization failed
RMAN-06171: not connected to target database
RMAN> show all
2> ;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 12/15/2011 10:18:05
RMAN-06171: not connected to target database

连不上目标数据库,我们是在线系统,有没有在线解决方法?

论坛徽章:
0
发表于 2011-12-15 11:43 |显示全部楼层
执行第二条命令时RMAN没有连接到数据库
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP