Oracle 镜像化的REDO日志文件中一半出现破损时的修复方法

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638    QQ号:47079569    邮箱:service@parnassusdata.com

比如,有3 Redo logfile group ,各 group 中有2 member。每个 member 分别配置两台设备,其中一台发生故障时,该如何处理呢?

[对策]

上述案例的修复方法需要重新制成发生故障的logfile member(drop->add)。接下来是具体操作顺序

1.  执行如下所示的select语句,查看现在的「INACTIVEstatus logfile

     member(「*」为发生故障的 logfile)

SVRMGR> select l.group#, f.member, l.status from v$log l, v$logfile f

     2> where l.group#=f.group# order by group#;

GROUP#     MEMBER

            STATUS

———- ———————————————————————

———– —————-

         1 /home8/ora733/work/thasegaw/hase733/redoje73301.log

            INACTIVE

         1 /home8/ora733/work/thasegaw/hase733/redoje73301_1.log  <==

            INACTIVE

         2 /home8/ora733/work/thasegaw/hase733/redoje73302.log

            CURRENT

         2 /home8/ora733/work/thasegaw/hase733/redoje73302_1.log  <==

            CURRENT

         3 /home8/ora733/work/thasegaw/hase733/redoje73303.log

            INACTIVE

         3 /home8/ora733/work/thasegaw/hase733/redoje73303_1.log  <==

            INACTIVE

6 选择行。

drop 2. 1.中查看到的「INACTIVEstatus logfile member

SVRMGR> alter database drop logfile member

     2> ‘/home8/ora733/work/thasegaw/hase733/redoje73301_1.log’;

语句处理完成。

SVRMGR> alter database drop logfile member

     2> ‘/home8/ora733/work/thasegaw/hase733/redoje73303_1.log’;

语句处理完成。

注:「CURRENT」的 logfile member即使发生ORA-01609 也不会drop

  

追加3. 2.中删除掉的 logfile member

    (如果有相同名字的logfile 时,请用OS level 删除)

SVRMGR> alter database add logfile member

     2> ‘/home8/ora733/work/thasegaw/hase733/redoje73301_1.log’ to group 1;

语句处理完成。

SVRMGR> alter database add logfile member

     2> ‘/home8/ora733/work/thasegaw/hase733/redoje73303_1.log’ to group 3;

语句处理完成。

为了drop 4. 2.中没有drop logfile member switch logfile

SVRMGR> alter system switch logfile;

语句处理完成。

SVRMGR> select l.group#, f.member, l.status from v$log l, v$logfile f

     2> where l.group#=f.group# order by group#;

GROUP#     MEMBER

            STATUS

———- ———————————————————————

———– —————-

         1 /home8/ora733/work/thasegaw/hase733/redoje73301.log

            INACTIVE

         1 /home8/ora733/work/thasegaw/hase733/redoje73301_1.log

            INACTIVE

         2 /home8/ora733/work/thasegaw/hase733/redoje73302.log

            INACTIVE

         2 /home8/ora733/work/thasegaw/hase733/redoje73302_1.log

            INACTIVE

         3 /home8/ora733/work/thasegaw/hase733/redoje73303.log

            CURRENT

         3 /home8/ora733/work/thasegaw/hase733/redoje73303_1.log

            CURRENT

6 选择行。

SVRMGR>

5.同样地,以 2.->3.的顺序重新制成。

SVRMGR> alter database drop logfile member

     2> ‘/home8/ora733/work/thasegaw/hase733/redoje73302_1.log’;

语句处理完成。

SVRMGR> alter database add logfile member

     2> ‘/home8/ora733/work/thasegaw/hase733/redoje73302_1.log’ to group 2;

语句处理完成。

关注刘相兵的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

Speak Your Mind

沪公网安备 31010802001379号

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