RAC环境下主库丢失归档,备库DG的恢复过程

0    152    1

Tags:

👉 本文共约17216个字,系统预计阅读时间或需65分钟。

【故障处理】DG归档丢失的恢复

前言部分

导读和注意事项

各位技术爱好者,看完本文后,你可以掌握如下的技能,也可以学到一些其它你所不知道的知识,~O(∩_∩)O~:

① 主库丢失归档,物理DG的恢复

② 其他常用SQL语句

故障分析及解决过程

故障环境介绍

项目source dbPHYSICAL STANDBY
db 类型RACRAC
db version11.2.0.311.2.0.3
db 存储ASMASM
OS版本及kernel版本AIX 64位 6.1.0.0AIX 64位 6.1.0.0

故障发生现象及报错信息

由于客户这边有N套库,我过来时间短,没有完全整理,昨天对一套rac执行健康检查的时候发现带有一套物理DG,但是DG库不同步,而且同步的日志号已经断档很久了,于是决定把这套DG恢复一下,下边简单记录一下。

数据库信息:

RAC环境下主库丢失归档,备库DG的恢复过程

DG库信息:

RAC环境下主库丢失归档,备库DG的恢复过程

本人提供Oracle、MySQL、PG等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!
THREAD#DEST_IDDEST_NAMETARGETDATABASE_MODEDB_UNIQUE_NAMEDESTINATIONCURRENT_SEQ#LAST_ARCHIVEDAPPLIED_SEQ#
11LOG_ARCHIVE_DEST_1LOCAL PRIMARYOPENNONE/archive/arch1431114310
12LOG_ARCHIVE_DEST_2PHYSICAL STANDBYOPEN_READ-ONLYoraNETRoraNETR1431114310968
21LOG_ARCHIVE_DEST_1LOCAL PRIMARYOPENNONE/archive/arch1340313402
22LOG_ARCHIVE_DEST_2PHYSICAL STANDBYOPEN_READ-ONLYoraNETRoraNETR1340313402644

可以看到实例一当前是14311,但是DG库才应用到968,而实例二当前是13403,DG应用到644,下边着手恢复备库,恢复的原理可以参考之前的文档 【DATAGUARD】物理dg在主库丢失归档文件的情况下的恢复(七): http://blog.itpub.net/26736162/viewspace-1780863/

故障分析及解决过程

在主库看了下,968、644的日志早都不见了,没办法只能对主库进行基于SCN号的增量备份:

先查找最小的scn号:

SELECT (SELECT MIN(d.CHECKPOINT_CHANGE#) FROM v$datafile d) datafile_scn,

(SELECT MIN(d.CHECKPOINT_CHANGE#)

FROM v$datafile_header d

WHERE rownum = 1) datafile_header_scn,

(SELECT current_scn FROM v$database) current_scn,

(SELECT min(b.NEXT_CHANGE#)

FROM v$archived_log b

WHERE b.SEQUENCE# in (968,644)

AND resetlogs_change# =

(SELECT d.RESETLOGS_CHANGE# FROM v$database d)) NEXT_CHANGE#

FROM dual;

RAC环境下主库丢失归档,备库DG的恢复过程

我们取12232942713886为备份的SCN号:

备份:

run

{

allocate channel d1 type disk;

allocate channel d2 type disk;

allocate channel d3 type disk;

allocate channel d4 type disk;

backup as compressed backupset incremental from SCN 12232942713886 database format '/archive/standbynew%d%T%U.bak' include current controlfile for standby filesperset=5 tag 'FOR STANDBY new';

release channel d1;

release channel d2;

release channel d3;

release channel d4;

}

将日志传递到备库:

root@ZHLHRDB7:/archive# l

total 478725456

drwxr-xr-x 2 oracle dba 524288 Apr 22 08:56 arch

-rw-r--r-- 1 oracle dba 2253 Apr 08 2015 initnetr.ora

-rwxr-xr-x 1 oracle dba 21708800 Apr 08 2015 standby.ctl

-rwxr-xr-x 1 oracle dba 22414245888 Apr 20 09:06 standby_ORANET_20160130_0bqsm476_1_1.bak

-rwxr-xr-x 1 oracle dba 22140502016 Apr 20 09:36 standby_ORANET_20160130_0cqsm477_1_1.bak

-rwxr-xr-x 1 oracle dba 13977583616 Apr 20 09:57 standby_ORANET_20160130_0dqsmdf6_1_1.bak

-rwxr-xr-x 1 oracle dba 14525480960 Apr 20 10:16 standby_ORANET_20160130_0eqsmdkv_1_1.bak

-rwxr-xr-x 1 oracle dba 14335983616 Apr 20 10:34 standby_ORANET_20160130_0fqsmkgt_1_1.bak

-rwxr-xr-x 1 oracle dba 16120840192 Apr 20 10:55 standby_ORANET_20160130_0gqsmkvf_1_1.bak

-rwxr-xr-x 1 oracle dba 16035766272 Apr 20 11:16 standby_ORANET_20160130_0hqsmrlg_1_1.bak

-rwxr-xr-x 1 oracle dba 16075489280 Apr 20 11:37 standby_ORANET_20160130_0iqsmspa_1_1.bak

-rwxr-xr-x 1 oracle dba 16070926336 Apr 20 11:58 standby_ORANET_20160130_0jqsn37g_1_1.bak

-rwxr-xr-x 1 oracle dba 16039673856 Apr 20 12:19 standby_ORANET_20160130_0kqsn4b0_1_1.bak

-rwxr-xr-x 1 oracle dba 15593078784 Apr 20 13:47 standby_ORANET_20160131_0lqsnadm_1_1.bak

-rwxr-xr-x 1 oracle dba 15463137280 Apr 20 14:07 standby_ORANET_20160131_0mqsnbfu_1_1.bak

-rwxr-xr-x 1 oracle dba 15369084928 Apr 20 14:27 standby_ORANET_20160131_0nqsnhb1_1_1.bak

-rwxr-xr-x 1 oracle dba 15504777216 Apr 20 14:47 standby_ORANET_20160131_0oqsnibd_1_1.bak

-rwxr-xr-x 1 oracle dba 15410495488 Apr 20 15:09 standby_ORANET_20160131_0pqsno4l_1_1.bak

-rwxr-xr-x 1 oracle dba 4063232 Apr 20 15:09 standby_ORANET_20160131_0qqsnp6t_1_1.bak

-rwxr-xr-x 1 oracle dba 4063232 Apr 20 15:09 standby_ORANET_20160131_0rqsnulk_1_1.bak

root@ZHLHRDB7:/archive#

备库恢复控制文件

RAC环境下主库丢失归档,备库DG的恢复过程

从健康检查中可以找到最新的控制文件备份集名称是/archive/standby_ORANET_20160131_0rqsnulk_1_1.bak,我们在备库首先启动到nomount状态,然后恢复控制文件:

SQL> show parameter cont

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

control_file_record_keep_time integer 31

control_files string +DATA/oranetr/controlfile/cont

rol01.ctl, +DATA/oranetr/contr

olfile/control02.ctl, +DATA/or

anetr/controlfile/control03.ct

l

control_management_pack_access string DIAGNOSTIC+TUNING

global_context_pool_size string

SQL>

col name format a60

set line 9999 pagesize 9999

SELECT a.FILE#, a.NAME,a.CHECKPOINT_CHANGE#,a.LAST_CHANGE#,status FROM v$datafile a;

FILE# NAME CHECKPOINT_CHANGE# LAST_CHANGE# STATUS

---------- ------------------------------------------------------------ ------------------ ------------ -------

1 +DATA/oranetr/datafile/system.293.876478571 12233018392104 SYSTEM

2 +DATA/oranetr/datafile/sysaux.291.876478569 12233018392104 ONLINE

3 +DATA/oranetr/datafile/undotbs1.292.876478569 12233018392104 ONLINE

4 +DATA/oranetr/datafile/undotbs2.288.876478511 12233018392104 ONLINE

5 +DATA/oranetr/datafile/users.290.876478513 12233018392104 ONLINE

6 +DATA/oranetr/datafile/bocnet_tbs.260.876478197 12233018392104 ONLINE

7 +DATA/oranetr/datafile/bocnet_tbs.280.876478353 12233018392104 ONLINE

8 +DATA/oranetr/datafile/bocnet_tbs.271.876478273 12233018392104 ONLINE

9 +DATA/oranetr/datafile/bocnet_tbs.283.876478429 12233018392104 ONLINE

10 +DATA/oranetr/datafile/bocnet_tbs.287.876478509 12233018392104 ONLINE

11 +DATA/oranetr/datafile/bocnet_tbs.284.876478431 12233018392104 ONLINE

12 +DATA/oranetr/datafile/bocnet_tbs.289.876478511 12233018392104 ONLINE

13 +DATA/oranetr/datafile/bocnet_tbs.276.876478349 12233018392104 ONLINE

14 +DATA/oranetr/datafile/bocnet_tbs.277.876478349 12233018392104 ONLINE

15 +DATA/oranetr/datafile/bocnet_tbs.272.876478273 12233018392104 ONLINE

16 +DATA/oranetr/datafile/bocnet_tbs.279.876478351 12233018392104 ONLINE

17 +DATA/oranetr/datafile/bocnet_tbs.278.876478351 12233018392104 ONLINE

18 +DATA/oranetr/datafile/bocnet_tbs.258.876478117 12233018392104 ONLINE

19 +DATA/oranetr/datafile/bocnet_tbs.267.876478039 12233018392104 ONLINE

20 +DATA/oranetr/datafile/bocnet_tbs.256.876478039 12233018392104 ONLINE

21 +DATA/oranetr/datafile/bocnet_tbs.266.876478115 12233018392104 ONLINE

22 +DATA/oranetr/datafile/bocnet_tbs.257.876478117 12233018392104 ONLINE

23 +DATA/oranetr/datafile/bocnet_tbs.268.876478039 12233018392104 ONLINE

24 +DATA/oranetr/datafile/bocnet_tbs.263.876478039 12233018392104 ONLINE

25 +DATA/oranetr/datafile/bocnet_tbs.269.876478039 12233018392104 ONLINE

26 +DATA/oranetr/datafile/bocnet_tbs.265.876478119 12233018392104 ONLINE

27 +DATA/oranetr/datafile/bocnet_tbs.259.876478117 12233018392104 ONLINE

28 +DATA/oranetr/datafile/bocnet_tbs.264.876478195 12233018392104 ONLINE

29 +DATA/oranetr/datafile/bocnet_tbs.281.876478427 12233018392104 ONLINE

30 +DATA/oranetr/datafile/bocnet_tbs.274.876478275 12233018392104 ONLINE

31 +DATA/oranetr/datafile/bocnet_tbs.261.876478195 12233018392104 ONLINE

32 +DATA/oranetr/datafile/bocnet_tbs.286.876478509 12233018392104 ONLINE

33 +DATA/oranetr/datafile/bocnet_tbs.282.876478427 12233018392104 ONLINE

34 +DATA/oranetr/datafile/bocnet_tbs.275.876478275 12233018392104 ONLINE

35 +DATA/oranetr/datafile/bocnet_tbs.270.876478197 12233018392104 ONLINE

36 +DATA/oranetr/datafile/bocnet_tbs.262.876478195 12233018392104 ONLINE

37 +DATA/oranetr/datafile/bocnet_tbs.273.876478273 12233018392104 ONLINE

38 +DATA/oranetr/datafile/bocnet_tbs.285.876478431 12233018392104 ONLINE

39 +DATA/oranetr/datafile/bocnet_tbs.313.876559505 12233018392104 ONLINE

40 +DATA/oranetr/datafile/bocnet_tbs.314.876559507 12233018392104 ONLINE

41 +DATA/oranetr/datafile/bocnet_tbs.315.876559509 12233018392104 ONLINE

42 +DATA/oranetr/datafile/bocnet_tbs.316.876559509 12233018392104 ONLINE

43 +DATA/oranetr/datafile/bocnet_tbs.317.876559511 12233018392104 ONLINE

44 +DATA/oranetr/datafile/bocnet_tbs.318.876559511 12233018392104 ONLINE

45 +DATA/oranetr/datafile/bocnet_tbs.319.876559513 12233018392104 ONLINE

46 +DATA/oranetr/datafile/bocnet_tbs.320.876559513 12233018392104 ONLINE

47 +DATA/oranetr/datafile/bocnet_tbs.321.876559515 12233018392104 ONLINE

48 +DATA/oranetr/datafile/bocnet_tbs.322.876559517 12233018392104 ONLINE

49 +DATA/oranetr/datafile/bocnet_tbs.323.876559517 12233018392104 ONLINE

50 +DATA/oranetr/datafile/bocnet_tbs.324.876559519 12233018392104 ONLINE

51 +DATA/oranetr/datafile/bocnet_tbs.325.876559521 12233018392104 ONLINE

52 +DATA/oranetr/datafile/bocnet_tbs.326.876559521 12233018392104 ONLINE

53 +DATA/oranetr/datafile/bocnet_tbs.327.876559523 12233018392104 ONLINE

54 +DATA/oranetr/datafile/bocnet_tbs.328.876559523 12233018392104 ONLINE

55 +DATA/oranetr/datafile/bocnet_tbs.329.876559525 12233018392104 ONLINE

56 +DATA/oranetr/datafile/bocnet_tbs.330.876559525 12233018392104 ONLINE

57 +DATA/oranetr/datafile/bocnet_tbs.331.876559527 12233018392104 ONLINE

58 +DATA/oranetr/datafile/bocnet_tbs.332.876559527 12233018392104 ONLINE

59 +DATA/oranetr/datafile/bocnet_tbs.333.876559529 12233018392104 ONLINE

60 +DATA/oranetr/datafile/bocnet_tbs.334.876559529 12233018392104 ONLINE

61 +DATA/oranetr/datafile/bocnet_tbs.335.876559531 12233018392104 ONLINE

62 +DATA/oranetr/datafile/bocnet_tbs.336.876559531 12233018392104 ONLINE

63 +DATA/oranetr/datafile/bocnet_tbs.337.876559533 12233018392104 ONLINE

64 +DATA/oranetr/datafile/bocnet_tbs.338.876559533 12233018392104 ONLINE

65 +DATA/oranetr/datafile/bocnet_tbs.339.876559535 12233018392104 ONLINE

66 +DATA/oranetr/datafile/bocnet_tbs.340.876559535 12233018392104 ONLINE

67 +DATA/oranetr/datafile/bocnet_tbs.341.876559537 12233018392104 ONLINE

68 +DATA/oranetr/datafile/bocnet_tbs.342.876559539 12233018392104 ONLINE

69 +DATA/oranetr/datafile/bocnet_tbs.343.876559539 12233018392104 ONLINE

70 +DATA/oranetr/datafile/bocnet_tbs.344.876559541 12233018392104 ONLINE

71 +DATA/oranetr/datafile/bocnet_tbs.345.876559541 12233018392104 ONLINE

72 +DATA/oranetr/datafile/bocnet_tbs.346.876559543 12233018392104 ONLINE

73 +DATA/oranetr/datafile/bocnet_tbs.347.876559543 12233018392104 ONLINE

74 +DATA/oranetr/datafile/bocnet_tbs.348.876559545 12233018392104 ONLINE

75 +DATA/oranetr/datafile/bocnet_tbs.349.876559545 12233018392104 ONLINE

rman恢复,恢复之前将原来的控制文件进行手工的冷备:

cp +DATA/oranetr/controlfile/control01.ctl +DATA/oranetr/controlfile/control01.ctl_bk

restore standby controlfile to '+DATA/oranetr/controlfile/control01.ctl' from '/archive/standby_ORANET_20160131_0rqsnulk_1_1.bak';

restore standby controlfile to '+DATA/oranetr/controlfile/control02.ctl' from '/archive/standby_ORANET_20160131_0rqsnulk_1_1.bak';

restore standby controlfile to '+DATA/oranetr/controlfile/control03.ctl' from '/archive/standby_ORANET_20160131_0rqsnulk_1_1.bak';

执行recover操作

alter database mount;

catalog start with '/archive/';

run

{

allocate channel d1 type disk;

allocate channel d2 type disk;

allocate channel d3 type disk;

allocate channel d4 type disk;

recover DATABASE noredo;

release channel d1;

release channel d2;

release channel d3;

release channel d4;

}

报错:

Thu Apr 21 17:08:13 2016

Errors in file /oracle/app/oracle/diag/rdbms/oranetr/oraNETR2/trace/oraNETR2_dbw0_15794356.trc:

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: '+DATA/oranetr/datafile/system.260.873307133'

ORA-17503: ksfdopn:2 Failed to open file +DATA/oranetr/datafile/system.260.873307133

ORA-15012: ASM file '+DATA/oranetr/datafile/system.260.873307133' does not exist

Errors in file /oracle/app/oracle/diag/rdbms/oranetr/oraNETR2/trace/oraNETR2_dbw0_15794356.trc:

ORA-01157: cannot identify/lock data file 2 - see DBWR trace file

ORA-01110: data file 2: '+DATA/oranetr/datafile/sysaux.261.873307151'

ORA-17503: ksfdopn:2 Failed to open file +DATA/oranetr/datafile/sysaux.261.873307151

ORA-15012: ASM file '+DATA/oranetr/datafile/sysaux.261.873307151' does not exist

很明显,控制文件是从主库恢复过来的,但是ASM的文件名是不一样的,所以报错,那么要做的就是重命名备库的数据文件名,用editplus或UE的列模式来编辑代码:

col name format a60

set line 9999 pagesize 9999

SELECT a.FILE#, a.NAME,a.CHECKPOINT_CHANGE#,a.LAST_CHANGE#,status FROM v$datafile a;

alter system set standby_file_management=manual;

alter database rename file '+DATA/oranetr/datafile/system.260.873307133' to '+DATA/oranetr/datafile/system.293.876478571' ;

alter database rename file '+DATA/oranetr/datafile/sysaux.261.873307151' to '+DATA/oranetr/datafile/sysaux.291.876478569' ;

。。。。。。。。。。。。。。。。。。。

alter database rename file '+DATA/oranetr/datafile/bocnet_tbs.338.1163840135' to '+DATA/oranetr/datafile/bocnet_tbs.347.876559543';

alter database rename file '+DATA/oranetr/datafile/bocnet_tbs.339.1163840135' to '+DATA/oranetr/datafile/bocnet_tbs.348.876559545';

alter database rename file '+DATA/oranetr/datafile/bocnet_tbs.340.116384013' to '+DATA/oranetr/datafile/bocnet_tbs.349.876559545';

重命名数据文件完成后再次执行恢复操作即可,恢复的过程中我们可以通过如下的SQL语句来查看恢复的进度:

SELECT a.USERNAME,

(SELECT upper(nb.OSUSER) FROM v$session nb WHERE nb.SID = a.sid) OSUSER,

(SELECT nb.sid || ',' || nb.SERIAL# || ',' || pr.SPID

FROM v$process pr, v$session nb

WHERE nb.PADDR = pr.ADDR

and nb.sid = a.SID

and nb.SERIAL# = a.SERIAL#) session_info,

a.target,

a.opname,

to_char(a.START_TIME, 'YYYY-MM-DD HH24:MI:SS') start_time,

round(a.SOFAR * 100 / a.TOTALWORK, 2) || '%' AS progress,

(a.TIME_REMAINING) TIME_REMAINING,

(a.sofar || ':' || a.TOTALWORK) sofar_TOTALWORK,

(a.elapsed_seconds) elapsed_seconds,

message message,

(SELECT nb.EVENT FROM V$session_Wait nb WHERE nb.SID = a.SID) wait_event,

(SELECT nb.STATUS FROM v$session nb WHERE nb.SID = a.SID) STATUS

FROM v$session_longops a

WHERE a.time_remaining \<> 0

ORDER BY status, a.TIME_REMAINING DESC, a.SQL_ID, a.sid;

RAC环境下主库丢失归档,备库DG的恢复过程

主备添加standby日志

SQL> alter database recover managed standby database using current logfile disconnect from session;

alter database recover managed standby database using current logfile disconnect from session

*

ERROR at line 1:

ORA-38500: USING CURRENT LOGFILE option not available without standby redo logs

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> set line 9999 pagesize 9999

SQL> col db_id format a15

SQL> select GROUP#, DBID db_id, THREAD#, SEQUENCE#, BYTES, USED, ARCHIVED, STATUS, FIRST_CHANGE#, NEXT_CHANGE#,LAST_CHANGE# from v$standby_log ;

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database add standby logfile thread 1 group 7 size 1073741824 ,group 8 size 1073741824 ,group 9 size 1073741824,group 10 size 1073741824 ;

Database altered.

SQL> alter database add standby logfile thread 2 group 11 size 1073741824 ,group 12 size 1073741824 ,group 13 size 1073741824,group 14 size 1073741824 ;

Database altered.

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

SQL> select GROUP#, DBID db_id, THREAD#, SEQUENCE#, BYTES, USED, ARCHIVED, STATUS, FIRST_CHANGE#, NEXT_CHANGE#,LAST_CHANGE# from v$standby_log ;

GROUP# DB_ID THREAD# SEQUENCE# BYTES USED ARC STATUS FIRST_CHANGE# NEXT_CHANGE# LAST_CHANGE#

---------- --------------- ---------- ---------- ---------- ---------- --- ---------- ------------- ------------ ------------

7 2420371020 1 14345 1073741824 159744 YES ACTIVE 1.2234E+13 1.2234E+13 1.2234E+13

8 UNASSIGNED 1 0 1073741824 0 YES UNASSIGNED

9 UNASSIGNED 1 0 1073741824 0 YES UNASSIGNED

10 UNASSIGNED 1 0 1073741824 0 YES UNASSIGNED

11 UNASSIGNED 2 0 1073741824 0 YES UNASSIGNED

12 UNASSIGNED 2 0 1073741824 0 YES UNASSIGNED

13 UNASSIGNED 2 0 1073741824 0 YES UNASSIGNED

14 UNASSIGNED 2 0 1073741824 0 YES UNASSIGNED

8 rows selected.

恢复完成后发现主备库都没有standby日志,然后添加一下日志:

alter database add standby logfile thread 1 group 7 size 1073741824 ,group 8 size 1073741824 ,group 9 size 1073741824,group 10 size 1073741824 ;

alter database add standby logfile thread 2 group 11 size 1073741824 ,group 12 size 1073741824 ,group 13 size 1073741824,group 14 size 1073741824 ;

再次健康检查

再次执行健康检查的时候发现DG库已经正常了。

DG库

DG库配置情况

参数名称实例名称参数值
db_file_name_convertoraNET1+DATA/oraNETR/datafile, +DATA/oraNET/datafile
oraNET2+DATA/oraNETR/datafile, +DATA/oraNET/datafile
fal_clientoraNET1oraNET
oraNET2oraNET
fal_serveroraNET1oraNETR
oraNET2oraNETR
log_archive_configoraNET1DG_CONFIG=(oraNET,oraNETR)
oraNET2DG_CONFIG=(oraNET,oraNETR)
log_archive_dest_1oraNET1LOCATION=/archive/arch
oraNET2LOCATION=/archive/arch
log_archive_dest_2oraNET1SERVICE=oraNETR LGWR ASYNC VALID_FOR=(ONLINE_LOGFI LES,PRIMARY_ROLE) DB_UNIQUE_NAME=oraNETR
oraNET2SERVICE=oraNETR LGWR ASYNC VALID_FOR=(ONLINE_LOGFI LES,PRIMARY_ROLE) DB_UNIQUE_NAME=oraNETR
log_archive_dest_state_2oraNET1ENABLE
oraNET2ENABLE
log_file_name_convertoraNET1+DATA/oraNETR/onlinelog, +DATA/oraNET/onlinelog
oraNET2+DATA/oraNETR/onlinelog, +DATA/oraNET/onlinelog
standby_file_managementoraNET1AUTO
oraNET2AUTO

DG库运行情况

INST_IDNAMELOG_MODEOPEN_MODEDATABASE_ROLESWITCHOVER_STATUSDB_UNIQUE_NAMEFLASHBACK_ONPROTECTION_MODEPROTECTION_LEVELREMOTE_ARCHIVESWITCHOVER#SWITCHOVER_STATUSDATAGUARD_BROKERGUARD_STATUSSUPPLEMENTAL_LOGSUPPLESUPPLEFORCE_SUPPLESUPPLESTANDBY_BECAME_PRIMARY_SCNFS_FAILOVER_STATUSFS_FAILOVER_CURRENT_TARGETFS_FAILOVER_THRESHOLDFS_FAILOVER_OBFS_FAILOVER_OBSERVER_HOST
2ORANETARCHIVELOGREAD WRITEPRIMARYTO STANDBYoraNETNOMAXIMUM PERFORMANCEMAXIMUM PERFORMANCEENABLED2420341836TO STANDBYDISABLEDNONENONONONONONO0DISABLED0
1ORANETARCHIVELOGREAD WRITEPRIMARYTO STANDBYoraNETNOMAXIMUM PERFORMANCEMAXIMUM PERFORMANCEENABLED2420341836TO STANDBYDISABLEDNONENONONONONONO0DISABLED0
THREAD#DEST_IDDEST_NAMETARGETDATABASE_MODESTATUSERRORRECOVERY_MODEDB_UNIQUE_NAMEDESTINATIONGAP_STATUSCURRENT_SEQ#LAST_ARCHIVEDAPPLIED_SEQ#APPLIED_SCN
11LOG_ARCHIVE_DEST_1LOCAL PRIMARYOPENVALIDIDLENONE/archive/arch14347143460
12LOG_ARCHIVE_DEST_2PHYSICAL STANDBYOPEN_READ-ONLYVALIDMANAGED REAL TIME APPLYoraNETRoraNETRNO GAP14347143461434512234221408001
21LOG_ARCHIVE_DEST_1LOCAL PRIMARYOPENVALIDIDLENONE/archive/arch13441134400
22LOG_ARCHIVE_DEST_2PHYSICAL STANDBYOPEN_READ-ONLYVALIDMANAGED REAL TIME APPLYoraNETRoraNETRNO GAP13441134401344012234221408001

主库DG进程

INSTANCE_NAMEPROCESSCLIENT_PROCESSCLIENT_PIDSTATUSGROUP_#THREAD#SEQUENCE#DELAY_MINSRESETLOG_IDSIDSERIAL#SPID
oraNET1ARCHARCH12320920CLOSING21143450873307084577312320920
oraNET1ARCHARCH11862152CLOSING11143460873307084768111862152
oraNET1ARCHARCH12255366CLOSINGN/A1143100873307084962112255366
oraNET1ARCHARCH12386452CLOSING311434408733070841152112386452
oraNET1LNSLNS12648578WRITING311434708733070845112648578
oraNET2ARCHARCH13697186CLOSING62134400873307084771313697186
oraNET2ARCHARCH13762724CLOSING62134340873307084961113762724
oraNET2ARCHARCH13828262CLOSINGN/A21342808733070841153113828262
oraNET2ARCHARCH13959338CLOSINGN/A21343908733070846113959338
oraNET2LNSLNS14155952WRITING52134410873307084198314155952

备库DG进程

INSTANCE_NAMEPROCESSCLIENT_PROCESSCLIENT_PIDSTATUSGROUP_#THREAD#SEQUENCE#DELAY_MINSRESETLOG_IDSIDSERIAL#SPID
oraNETR1ARCHARCH12910842CLOSING711434608733070841144912910842
oraNETR1ARCHARCH20906040CONNECTEDN/A000010120906040
oraNETR1ARCHARCH13959174CONNECTEDN/A0000392113959174
oraNETR1ARCHARCH19595368CLOSING71143450873307084773719595368
oraNETR1RFSUNKNOWN12386452IDLEN/A0000389920054214
oraNETR1RFSUNKNOWN13959338IDLEN/A0000771719464320
oraNETR1RFSLGWR12648578IDLE311434708733070843912920840536
oraNETR1RFSUNKNOWN12320920IDLEN/A0000775312583132
oraNETR1RFSLGWR14155952IDLE521344108733070841154121102682
oraNETR2ARCHARCH19333240CONNECTEDN/A000010319333240
oraNETR2ARCHARCH12845164CONNECTEDN/A0000392112845164
oraNETR2ARCHARCH14614690CONNECTEDN/A0000773114614690
oraNETR2ARCHARCH21495916CONNECTEDN/A00001152321495916
oraNETR2MRP0N/AN/AAPPLYING_LOGN/A114347087330708412515859922
oraNETR2RFSARCH12255366IDLEN/A0000779119988678
oraNETR2RFSARCH13828262IDLEN/A000077153997896

备库日志应用情况

INSTANCETHREAD#NAMESEQUENCE#ARCHIVAPPLIEDNEXT_CHANGE#
oraNET11/archive/arch/1_14344_873307084.dbf14344YESYES12234221306722
oraNET11/archive/arch/1_14345_873307084.dbf14345YESYES12234221316152
oraNET11/archive/arch/1_14346_873307084.dbf14346YESIN-MEMORY12234221316559
oraNET22/archive/arch/2_13438_873307084.dbf13438YESYES12234221214634
oraNET22/archive/arch/2_13439_873307084.dbf13439YESYES12234221246543
oraNET22/archive/arch/2_13440_873307084.dbf13440YESYES12234221316477

主库standby日志

GROUP#DB_IDTHREAD#SEQUENCE#BYTESUSEDARCHIVSTATUSFIRST_CHANGE#NEXT_CHANGE#LAST_CHANGE#
7UNASSIGNED1010737418240YESUNASSIGNED
8UNASSIGNED1010737418240YESUNASSIGNED
9UNASSIGNED1010737418240YESUNASSIGNED
10UNASSIGNED1010737418240YESUNASSIGNED
11UNASSIGNED2010737418240YESUNASSIGNED
12UNASSIGNED2010737418240YESUNASSIGNED
13UNASSIGNED2010737418240YESUNASSIGNED
14UNASSIGNED2010737418240YESUNASSIGNED

备库standby日志

INSTANCEGROUP#DB_IDTHREAD#SEQUENCE#BYTESUSEDARCHIVSTATUSFIRST_CHANGE#LAST_CHANGE#
oraNET17UNASSIGNED1010737418240NOUNASSIGNED
oraNET182420371020114347107374182425055744YESACTIVE1223422131655912234221411988
oraNET19UNASSIGNED1010737418240YESUNASSIGNED
oraNET110UNASSIGNED1010737418240YESUNASSIGNED
oraNET2112420371020213441107374182436782592YESACTIVE1223422131647712234221411986
oraNET212UNASSIGNED2010737418240YESUNASSIGNED
oraNET213UNASSIGNED2010737418240YESUNASSIGNED
oraNET214UNASSIGNED2010737418240YESUNASSIGNED

一切正常,测试一下实时同步的功能也是可以的。

故障处理总结

文章写的比较简单,主要是因为之前有过类似的文章,但这篇是基于RAC环境的,对控制文件的处理稍有不同而已,详细可以参考:http://blog.itpub.net/26736162/viewspace-1780863/

标签:

头像

小麦苗

学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

您可能还喜欢...

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

5 + 9 =

 

嘿,我是小麦,需要帮助随时找我哦
  • 18509239930
  • 个人微信

  • 麦老师QQ聊天
  • 个人邮箱
  • 点击加入QQ群
  • 个人微店

  • 回到顶部
返回顶部