文章详情

短信预约-IT技能 免费直播动态提醒

请输入下面的图形验证码

提交验证

短信预约提醒成功

Oracle dataguard failover 实战

2024-04-02 19:55

关注

Oracle dataguard  failover 实战

操作步骤

备库:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP;

添加临时文件,删除老的临时文件

 

附表

具体操作和alert日志如下:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;

Database altered.

备库alert

 

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE

Tue Apr  9 10:55:24 2013

Terminal Recovery: request posted (orcl) ---备库实例

Tue Apr  9 10:55:27 2013

Terminal Recovery timestamp is '04/09/2013 10:55:27'  ---恢复时间戳

Terminal Recovery: applying standby redo logs. 

Terminal Recovery: thread 1 seq# 29879 redo required

Terminal Recovery:  /opt/oracle/oradata/research/redo04.log ---standby redo log

Identified End-Of-Redo for thread 1 sequence 29879

Tue Apr  9 10:55:28 2013

Incomplete recovery applied all redo ever generated.

Recovery completed through change 1900634393

Tue Apr  9 10:55:28 2013

MRP0: Media Recovery Complete (orcl)

Terminal Recovery: successful completion

Begin: Standby Redo Logfile archival

End: Standby Redo Logfile archival

Resetting standby activation ID 2055592130 (0x7a85d8c2)

Tue Apr  9 10:55:32 2013

Waiting for MRP0 pid 1241 to terminate

Waiting for MRP0 pid 1241 to terminate

Waiting for MRP0 pid 1241 to terminate

Tue Apr  9 10:55:34 2013

MRP0: Background Media Recovery process shutdown (orcl)

Tue Apr  9 10:55:35 2013

Terminal Recovery: completion detected (orcl)

Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE

 

主库alert

ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113)

ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned

PING[ARC0]: Error 3113 when pinging standby orcl.

Tue Apr  9 10:36:23 2013

Errors in file /opt/oracle/admin/research/bdump/research_lns1_8489.trc:

ORA-03113: end-of-file on communication channel

Tue Apr  9 10:36:23 2013

LGWR: I/O error 3113 archiving log 1 to 'orcl'

主库

SQL> alter system set log_archive_dest_state_2='defer';

System altered

 

备库

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

Database altered.

 

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

Tue Apr  9 11:08:41 2013

ALTER DATABASE SWITCHOVER TO PRIMARY (orcl) ---orcl实例成为PRIMARY

Tue Apr  9 11:08:41 2013

If media recovery active, switchover will wait 900 seconds

Standby terminal recovery start SCN: 1900632860

SwitchOver after complete recovery through change 1900634393

Tue Apr  9 11:08:41 2013

Errors in file /opt/oracle/admin/research/udump/orcl_ora_4506.trc:

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: '/opt/oracle/oradata/research/redo01.log'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

Tue Apr  9 11:08:42 2013

Errors in file /opt/oracle/admin/research/udump/orcl_ora_4506.trc:

ORA-00313: open failed for members of log group 2 of thread 1

ORA-00312: online log 2 thread 1: '/opt/oracle/oradata/research/redo02.log'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

Tue Apr  9 11:08:43 2013

Errors in file /opt/oracle/admin/research/udump/orcl_ora_4506.trc:

ORA-00313: open failed for members of log group 3 of thread 1

ORA-00312: online log 3 thread 1: '/opt/oracle/oradata/research/redo03.log'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

Standby became primary SCN: 1900632859

Tue Apr  9 11:08:44 2013

Switchover: Complete - Database shutdown required (orcl)

Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

Tue Apr  9 11:09:12 2013

ARC1: Archival disabled due to instance shutdown

Shutting down archive processes

Archiving is disabled

Tue Apr  9 11:09:22 2013

ARCH shutting down

ARC0: Archival stopped

Tue Apr  9 11:09:27 2013

ARCH shutting down

ARC1: Archival stopped

 

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

 

Tue Apr  9 11:10:33 2013

Shutting down instance: further logons disabled

Tue Apr  9 11:10:33 2013

Stopping background process MMNL

Tue Apr  9 11:10:33 2013

Stopping background process MMON

Tue Apr  9 11:10:34 2013

Shutting down instance (immediate)

License high water mark = 10

Waiting for dispatcher 'D000' to shutdown

All dispatchers and shared servers shutdown

Tue Apr  9 11:10:36 2013

ALTER DATABASE CLOSE NORMAL

ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

 

SQL> startup

ORACLE instance started.

Total System Global Area 2147483648 bytes

Fixed Size                  2022144 bytes

Variable Size            1526727936 bytes

Database Buffers          603979776 bytes

Redo Buffers               14753792 bytes

Database mounted.

Database opened.

 

备库添加临时文件,删除老的临时文件

alter tablespace temp add tempfile xxxxx size 1G autoextend on maxsize 10G;

alter tablespace doudou add tempfile xxxbb size 1G autoextend on maxsize 10G;

shutdown immediate;

startup;

alter database tempfile '/xxxx/temp01.dbf' drop including datafiles;

alter database tempfile '/xxxx/doudou01.dbf' drop including datafiles;

 

 

阅读原文内容投诉

免责声明:

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

软考中级精品资料免费领

  • 历年真题答案解析
  • 备考技巧名师总结
  • 高频考点精准押题
  • 2024年上半年信息系统项目管理师第二批次真题及答案解析(完整版)

    难度     813人已做
    查看
  • 【考后总结】2024年5月26日信息系统项目管理师第2批次考情分析

    难度     354人已做
    查看
  • 【考后总结】2024年5月25日信息系统项目管理师第1批次考情分析

    难度     318人已做
    查看
  • 2024年上半年软考高项第一、二批次真题考点汇总(完整版)

    难度     435人已做
    查看
  • 2024年上半年系统架构设计师考试综合知识真题

    难度     224人已做
    查看

相关文章

发现更多好内容

猜你喜欢

AI推送时光机
位置:首页-资讯-数据库
咦!没有更多了?去看看其它编程学习网 内容吧
首页课程
资料下载
问答资讯