我的编程空间,编程开发者的网络收藏夹
学习永远不晚

Oracle dataguard failover 实战

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

北京

  • 北京
  • 上海
  • 天津
  • 重庆
  • 河北
  • 山东
  • 辽宁
  • 黑龙江
  • 吉林
  • 甘肃
  • 青海
  • 河南
  • 江苏
  • 湖北
  • 湖南
  • 江西
  • 浙江
  • 广东
  • 云南
  • 福建
  • 海南
  • 山西
  • 四川
  • 陕西
  • 贵州
  • 安徽
  • 广西
  • 内蒙
  • 西藏
  • 新疆
  • 宁夏
  • 兵团
手机号立即预约

请填写图片验证码后获取短信验证码

看不清楚,换张图片

免费获取短信验证码

Oracle dataguard  failover 实战

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

Oracle dataguard failover 实战

下载Word文档到电脑,方便收藏和打印~

下载Word文档

猜你喜欢

Oracle动态视图v$active_session_history实战示例

目录oracle动态视图实战之v$active_session_history先看下官方解释实际工作中主要应用结合我们的AWR报告关键点Oracle动态视图实战之v$active_session_history先看下官方解释Samples
2023-03-08

Oracle数据库性能调优实战技巧

标题:Oracle数据库性能调优实战技巧在当今信息时代,数据库已经成为企业数据存储和管理不可或缺的重要组成部分。而Oracle作为业界领先的关系数据库管理系统(RDBMS),在企业中应用广泛。然而,随着数据量的不断增加,数据库性能的优化变
Oracle数据库性能调优实战技巧
2024-03-02

编程热搜

目录