Oracle dataguard failover實(shí)戰(zhàn)

成都創(chuàng)新互聯(lián)是專業(yè)的晉中網(wǎng)站建設(shè)公司，晉中接單;提供網(wǎng)站建設(shè)、成都網(wǎng)站建設(shè),網(wǎng)頁(yè)設(shè)計(jì),網(wǎng)站設(shè)計(jì),建網(wǎng)站,PHP網(wǎng)站建設(shè)等專業(yè)做網(wǎng)站服務(wù);采用PHP框架,可快速的進(jìn)行晉中網(wǎng)站開(kāi)發(fā)網(wǎng)頁(yè)制作和功能擴(kuò)展;專業(yè)做搜索引擎喜愛(ài)的網(wǎng)站,專業(yè)的做網(wǎng)站團(tuán)隊(duì),希望更多企業(yè)前來(lái)合作!

操作步驟

備庫(kù)：

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP;

添加臨時(shí)文件，刪除老的臨時(shí)文件

 

附表

具體操作和alert日志如下：

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;

Database altered.

備庫(kù)alert

 

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE

Tue Apr 9 10:55:24 2013

Terminal Recovery: request posted (orcl) ---備庫(kù)實(shí)例

Tue Apr 9 10:55:27 2013

Terminal Recovery timestamp is '04/09/2013 10:55:27' ---恢復(fù)時(shí)間戳

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

 

主庫(kù)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'

主庫(kù)

SQL> alter system set log_archive_dest_state_2='defer';

System altered

 

備庫(kù)

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實(shí)例成為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.

 

備庫(kù)添加臨時(shí)文件，刪除老的臨時(shí)文件

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;

 

 

網(wǎng)站標(biāo)題：Oracledataguardfailover實(shí)戰(zhàn)
網(wǎng)站地址：http://jinyejixie.com/article38/gpgdsp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站導(dǎo)航、App開(kāi)發(fā)、外貿(mào)建站、品牌網(wǎng)站設(shè)計(jì)、響應(yīng)式網(wǎng)站、網(wǎng)站收錄

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)