网站首页
JSP空间
动态资讯
开源项目
技术文档
资源下载
J2EE资源
客户论坛
在线支付
 
  技术文档>>数据库技术>>Oracle技术>>Oracle开发>查看文档  
  深入讲解redo log file损坏的处理过程 (1)     
  文章作者:未知  文章来源:赛迪网技术社区  
  查看:75次  录入:管理员--2008-03-07  
 

redo log file 损坏的处理过程;

一、查看日志 style="text-indent:2em">

thu mar 29 09:15:21 2007
errors in file d:oracleadmings12366bdumpgs12366_lgwr_2052.trc:
ora-00313: open failed for members of log group 1 of thread 1
ora-00312: online log 1 thread 1: 'd:oracleoradatags12366redo01.log'
ora-27041: unable to open file
osd-04002: unable to open file
o/s-error: (os 2) 系统找不到指定的文件。

thu mar 29 09:15:21 2007
errors in file d:oracleadmings12366bdumpgs12366_lgwr_2052.trc:
ora-00313: open failed for members of log group 1 of thread 1
ora-00312: online log 1 thread 1: 'd:oracleoradatags12366redo01.log'
ora-27041: unable to open file
osd-04002: unable to open file
o/s-error: (os 2) 系统找不到指定的文件。

thu mar 29 09:15:21 2007
ora-313 signalled during: alter database open
...
thu mar 29 09:16:38 2007
alter database open
thu mar 29 09:16:38 2007
errors in file d:oracleadmings12366bdumpgs12366_lgwr_2052.trc:
ora-00341: log 1 of thread 1, wrong log # 2 in header
ora-00312: online log 1 thread 1: 'd:oracleoradatags12366redo01.log'

thu mar 29 09:16:38 2007
errors in file d:oracleadmings12366bdumpgs12366_lgwr_2052.trc:
ora-00341: log 1 of thread 1, wrong log # 2 in header
ora-00312: online log 1 thread 1: 'd:oracleoradatags12366redo01.log'

thu mar 29 09:16:38 2007
ora-341 signalled during: alter database open...

二、查看日志当前状态

c:documents and settingsgs12366>sqlplus /nolog

sql*plus: release 9.2.0.1.0 - production on fri mar 30 09:39:42 2007

copyright (c) 1982, 2002, oracle corporation. all rights reserved.

sql> conn / as sysdba
connected.
sql> archive log list
database log mode no archive mode
automatic archival disabled
archive destination d:oracleora92rdbms
oldest online log sequence 0
current log sequence 531
sql> select * from v$logfile;

group# status type
---------- ------- -------
member
---------------------------------------

1 online
d:oracleoradatags12366redo01.log

2 online
d:oracleoradatags12366redo02.log

3 stale online
d:oracleoradatags12366redo03.log


sql> select * from v$log;

group# thread# sequence# bytes members arc status
---------- ---------- ---------- ---------- 
first_change# first_tim
------------- ---------
1 1 0 104857600 1 no unused
0 27-mar-07

2 1 530 104857600 1 no inactive
47709153 27-mar-07

3 1 531 104857600 1 no invalidated
48070450 28-mar-07


sql>


sql> alter system switch logfile;
alter system switch logfile
*
error at line 1:
ora-01109: database not open

注:确定丢失了d:oracleoradatags12366redo01.log

解决过程如下:

sql> shutdown immediate
ora-01109: database not open
database dismounted.
oracle instance shut down.

sql> startup mount
oracle instance started.

total system global area 1670457484 bytes
fixed size 456844 bytes
variable size 595591168 bytes
database buffers 1073741824 bytes
redo buffers 667648 bytes
database mounted.
sql> select group#,archived,status from v$log;

group# arc status
---------- --- ----------------
1 no unused
2 no inactive
3 no invalidated

sql> alter database drop logfile group 1;

database altered.

sql> select group#,archived,status from v$log;

group# arc status
---------- --- ----------------
2 no inactive
3 no invalidated

sql> alter database open;

database altered.

sql> select group#,archived,status from v$log;

group# arc status
---------- --- ----------------
2 no current
3 no inactive

sql> alter database add logfile group 1 'd:oracleoradatags12366redo01.log' s
ize 104857600 reuse;

database altered.

sql> select group#,archived,status from v$log;

group# arc status
---------- --- ----------------
1 yes unused
2 no current
3 no inactive

sql> alter system switch logfile;

system altered.

sql> alter system switch logfile;

system altered.

sql> select group#,archived,status from v$log;

group# arc status
---------- --- ----------------
1 no inactive
2 no inactive
3 no current

sql> alter system switch logfile;

system altered.

sql> select group#,archived,status from v$log;

group# arc status
---------- --- ----------------
1 no inactive
2 no current
3 no active

sql> alter system switch logfile;

system altered.

sql> select group#,archived,status from v$log;

group# arc status
---------- --- ----------------
1 no current
2 no active
3 no inactive

 
 
上一篇: 快速掌握解决ora-00844错误的实用方法    下一篇: 轻松解决oracle 10g 的em中文乱码问题
  相关文档
如何通过触发器实现数据库的即时同步 04-10
如何使用备份的控制文件来恢复数据库? 01-31
客户端不安装 Oracle 也可以连接数据库 08-05
Oracle 与 DB2 数据类型分类对应说明 05-13
使用t-sql强制所有用户退出当前数据库 07-17
讲解Oracle数据库之中数据安全完全分析 07-07
比较部分联机备份和常规操作生成的redo 03-05
教你在不同数据库环境下读取前n条记录数 07-14
实例讲解ora-12514和ora-12514解决方法 04-15
拨云见日 正确认识password file的作用 (1) 04-24
oracle安装后配置和启动企业管理器的过程 08-15
灵活应用oracle数据查询时经常用到的关联 03-03
教你在windows环境下kill掉oracle的线程 06-04
详细讲解oracle数据库sys密码的找回方法 08-01
了解国外公司的Oracle DBA面试试题 05-13
教你轻松掌握数据库和实例的启动和关闭 09-29
oracle数据库中使用rman建立data guard (1) 05-14
解析:job的interval输入参数过长的问题 11-15
查看本用户下的各种对象的SQL脚本 01-15
for loop读取游标和open close的区别 04-15
返回首页 | 关于我们 | J网章程 | JSP空间合租 | 客服中心 | 免责声明 | 常见问题 | 参观机房
本站主机空间代理至厦门市华众网络科技有限公司
《中华人民共和国增值电信业务经营许可证》
编号:闽B2-20050079
@2005-2008福建JSP技术网 版权所有 闽ICP备05000928号
厦门(总部):13616026886 福州:0591-87655121
邮箱:admin@fjjsp.com 站长QQ,点击这里给我发消息