rman备份的问题

[复制链接]
查看11 | 回复9 | 2005-8-5 01:01:25 | 显示全部楼层 |阅读模式
rman备份遇到如下问题
RMAN> run
2> {
3>allocate channel c1 type disk;
4>backup database format 'db_%u_%d_%s';
5>backup format 'log_t%t_s%s_p%p'
6>(archivelog all);
7> }
提示错误:
Starting backup at 29-JUL-05
current log archived
archived log /home/oracle/archive/log1/arc61564594862.arc not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 6
archived log /home/oracle/archive/log2/arc61564594862.arc not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 6
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 07/29/2005 13:52:00
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /home/oracle/archive/log3/arc61564594862.arc
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

ERROR MESSAGE STACK 是说没有归档日至可以用,但是i我的数据库配置是自动归档了阿。高手帮忙看看!

SQL> archive log list
Database log mode
Archive Mode
Automatic archival
Enabled
Archive destination
/home/oracle/archive/log3
Oldest online log sequence 47
Next log sequence to archive 49
Current log sequence 49
回复

使用道具 举报

千问 | 2005-8-5 01:01:25 | 显示全部楼层
到该目录下,看看提示的归档日志是否真的存在,做不了吗?
回复

使用道具 举报

千问 | 2005-8-5 01:01:25 | 显示全部楼层
/home/oracle/archive/log3/arc61564594862.arc
这个归档日至确实没有,我也不知道这是为什么?
是不是我先要archive log stop 停止归档进程,还是别的什么原因呢
回复

使用道具 举报

千问 | 2005-8-5 01:01:25 | 显示全部楼层
crosscheck archivelog all;
回复

使用道具 举报

千问 | 2005-8-5 01:01:25 | 显示全部楼层
mugen
可以解释一下crosscheck archivelog all么,还有我的/home/oracle/archive/log3根本就没有arc61564594862.arc,为什么会报这个错误。
是不是要用change archivelog all crosscheck跳过这个日志呢?
回复

使用道具 举报

千问 | 2005-8-5 01:01:25 | 显示全部楼层
在RMAN下下一条指令即可:
rman>change achivelog all validate;
回复

使用道具 举报

千问 | 2005-8-5 01:01:25 | 显示全部楼层
crosscheck archivelog all is used to validate weatherthe archived log is exist or notby using the informaion in control file.if it is not exit ,rman will skip it.
maybe i am not quite right.but i am studing rman now.
回复

使用道具 举报

千问 | 2005-8-5 01:01:25 | 显示全部楼层
Bookmark Go to End
Doc ID:Note:279588.1
Subject:Rman Fails Looking For Non-Existing Archivelog Rman-06059
Type:PROBLEM
Status:MODERATED
Content Type:TEXT/X-HTML
Creation Date:29-JUL-2004
Last Revision Date:24-JUN-2005


The information in this article applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.5
This problem can occur on any platform.
Errors
RMAN-6059
ORA-27041 unable to open file
Symptoms
RMAN backup fails with error stack:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 07/27/2004 19:18:44
RMAN-06059: expected archived log not found, lost of archived log compromises
Changes
archived logs deleted from the OS and not by RMAN.
Cause
archived logs recorded in v$archived_log as available were deleted from disk via OS command
Fix
RMAN> crosscheck archivelog all;
You will see messages like 'validation failed' for those logs missing and 'validation succeeded'
for those that are found. Once this is done, the backup will not look for those that were
invalidated.
回复

使用道具 举报

千问 | 2005-8-5 01:01:25 | 显示全部楼层
执行change archivelog all crosscheck跳过丢失的归档好了,执行crosscheck archivelog all应该不可行
回复

使用道具 举报

千问 | 2005-8-5 01:01:25 | 显示全部楼层
/home/oracle/archive/log1/arc61564594862

是不是改了归挡陆军
回复

使用道具 举报

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

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行