Tag Archives: Data Guard

Oracle DG：备库：RMAN-06094: datafile 463 must be restored

By Adamhuan | 2018年9月14日

在利用RMAN增量还原DG备库的差异数据的时候，我遇到了如题所示的问题，具体如下：

RMAN> recover database noredo;

Starting recover at 14-SEP-18
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/14/2018 11:05:41
RMAN-06094: datafile 463 must be restored

RMAN>

RMAN> recover database noredo;

Starting recover at 14-SEP-18

using channel ORA_DISK_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 09/14/2018 11:05:41

RMAN-06094: datafile 463 must be restored

RMAN>

打开数据库，查看一下数据文件的状态：

SQL> set linesize 400
SQL> col name for a50
SQL> 
SQL> select file#,name,bytes/1024/1024/1024 from v$datafile where file#>426;

（过多的输出，... ）

     FILE# NAME                                               BYTES/1024/1024/1024
---------- -------------------------------------------------- --------------------
       460 /oracle/MY_INSTANCE/mydata14/zen_424/zen.424.data                           30
       461 /oracle/MY_INSTANCE/mydata14/zen_425/zen.425.data                           30
       462 /oracle/MY_INSTANCE/mydata14/zen_426/zen.426.data                           30
       463 /oracle/MY_INSTANCE/mydata10/zen_427/zen.427.data                            0
       464 /oracle/MY_INSTANCE/mydata10/zen_428/zen.428.data                            0
       465 /oracle/MY_INSTANCE/mydata11/zen_429/zen.429.data                            0

39 rows selected.

SQL>

SQL> set linesize 400

SQL> col name for a50

SQL>

SQL> select file#,name,bytes/1024/1024/1024 from v$datafile where file#>426;

（过多的输出，... ）

FILE# NAME BYTES/1024/1024/1024

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

460 /oracle/MY_INSTANCE/mydata14/zen_424/zen.424.data 30

461 /oracle/MY_INSTANCE/mydata14/zen_425/zen.425.data 30

462 /oracle/MY_INSTANCE/mydata14/zen_426/zen.426.data 30

463 /oracle/MY_INSTANCE/mydata10/zen_427/zen.427.data 0

464 /oracle/MY_INSTANCE/mydata10/zen_428/zen.428.data 0

465 /oracle/MY_INSTANCE/mydata11/zen_429/zen.429.data 0

39 rows selected.

SQL>

可以看到，463开始的文件的大小为[……]

Oracle Data Guard 10g 10205：RAC –> Standby

By Adamhuan | 2018年7月5日

0 Comment

前提：
1. 主库：Oracle RAC 10g
2. 备库：Oracle DB 10g 10205

主库：

[root@rac2 ~]# su - grid
[grid@rac2 ~]$ 
[grid@rac2 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1        
ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac1        
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2        
ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2        
ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2        
ora.zona.db    application    0/1    0/1    ONLINE    ONLINE    rac2        
ora....a1.inst application    0/5    0/0    ONLINE    ONLINE    rac1        
ora....a2.inst application    0/5    0/0    ONLINE    ONLINE    rac2        
[grid@rac2 ~]$ 
[grid@rac2 ~]$ exit
logout
[root@rac2 ~]# su - oracle
[oracle@rac2 ~]$ 
[oracle@rac2 ~]$ ps -ef | grep pmon
oracle    3484     1  0 08:12 ?        00:00:00 asm_pmon_+ASM2
oracle   20559 20478  0 10:07 pts/4    00:00:00 grep pmon
oracle   26556     1  0 09:05 ?        00:00:00 ora_pmon_zona2
[oracle@rac2 ~]$ 
[oracle@rac2 ~]$ env | grep SID
ORACLE_SID=zona2
[oracle@rac2 ~]$ 
[oracle@rac2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 10:07:52 2018

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
zona2            OPEN

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@rac2 ~]$

[root@rac2 ~]# su - grid

[grid@rac2 ~]$

[grid@rac2 ~]$ crs_stat -t -v

Name Type R/RA F/FT Target State Host

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

ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1

ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1

ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1

ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1

ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1

ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2

ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2

ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2

ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2

ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2

ora.zona.db application 0/1 0/1 ONLINE ONLINE rac2

ora....a1.inst application 0/5 0/0 ONLINE ONLINE rac1

ora....a2.inst application 0/5 0/0 ONLINE ONLINE rac2

[grid@rac2 ~]$

[grid@rac2 ~]$ exit

logout

[root@rac2 ~]# su - oracle

[oracle@rac2 ~]$

[oracle@rac2 ~]$ ps -ef | grep pmon

oracle 3484 1 0 08:12 ? 00:00:00 asm_pmon_+ASM2

oracle 20559 20478 0 10:07 pts/4 00:00:00 grep pmon

oracle 26556 1 0 09:05 ? 00:00:00 ora_pmon_zona2

[oracle@rac2 ~]$

[oracle@rac2 ~]$ env | grep SID

ORACLE_SID=zona2

[oracle@rac2 ~]$

[oracle@rac2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 10:07:52 2018

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

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

zona2 OPEN

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

[oracle@rac2 ~]$

备库：

[oracle@standby-rac ~]$ sqlplus -V

SQL*Plus: Release 10.2.0.5.0 - Production

[oracle@standby-rac ~]$

[oracle@standby-rac ~]$ sqlplus -V

SQL*Plus: Release 10.2.0.5.0 - Production

[oracle@standby-rac ~]$

一、基础配置检查：[……]

DG error：【ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], []】 + 【FAL[client]: Failed to request gap sequence】

By Adamhuan | 2018年6月30日

0 Comment

问题如题所示，具体如下：

在DG的备库端的Alert日志中看到：

2018-06-30T09:10:35.167899+08:00
Media Recovery Log /home/app/oracle/arch_log/1_105_972571706.dbf
Errors in file /home/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_pr00_8582.trc  (incident=38786) (PDBNAME=CDB$ROOT):
ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], []
Incident details in: /home/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_38786/orcl_pr00_8582_i38786.trc
2018-06-30T09:10:38.251473+08:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2018-06-30T09:10:38.251783+08:00
Errors with log /home/app/oracle/arch_log/1_105_972571706.dbf
MRP0: Background Media Recovery terminated with error 600
2018-06-30T09:10:38.252159+08:00
Errors in file /home/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_pr00_8582.trc:
ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], []
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
2018-06-30T09:10:38.421449+08:00
Errors in file /home/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_pr00_8582.trc:
ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], []
2018-06-30T09:10:38.551930+08:00
Errors in file /home/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_mrp0_8576.trc  (incident=38466) (PDBNAME=CDB$ROOT):
ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], []
ORA-10877: error signaled in parallel recovery slave 
ORA-10877: error signaled in parallel recovery slave 
ORA-10877: error signaled in parallel recovery slave 
ORA-10877: error signaled in parallel recovery slave 
Incident details in: /home/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_38466/orcl_mrp0_8576_i38466.trc
2018-06-30T09:10:38.658930+08:00
Dumping diagnostic data in directory=[cdmp_20180630091038], requested by (instance=1, osid=8582 (PR00)), summary=[incident=38786].
2018-06-30T09:10:39.594280+08:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2018-06-30T09:10:39.594558+08:00
MRP0: Background Media Recovery process shutdown (orcl)

2018-06-30T09:10:35.167899+08:00

Media Recovery Log /home/app/oracle/arch_log/1_105_972571706.dbf

Errors in file /home/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_pr00_8582.trc (incident=38786) (PDBNAME=CDB$ROOT):

ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], []

Incident details in: /home/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_38786/orcl_pr00_8582_i38786.trc

2018-06-30T09:10:38.251473+08:00

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

2018-06-30T09:10:38.251783+08:00

Errors with log /home/app/oracle/arch_log/1_105_972571706.dbf

MRP0: Background Media Recovery terminated with error 600

2018-06-30T09:10:38.252159+08:00

Errors in file /home/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_pr00_8582.trc:

ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], []

Managed Standby Recovery not using Real Time Apply

Recovery interrupted!

2018-06-30T09:10:38.421449+08:00

Errors in file /home/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_pr00_8582.trc:

ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], []

2018-06-30T09:10:38.551930+08:00

Errors in file /home/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_mrp0_8576.trc (incident=38466) (PDBNAME=CDB$ROOT):

ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], []

ORA-10877: error signaled in parallel recovery slave

Incident details in: /home/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_38466/orcl_mrp0_8576_i38466.trc

2018-06-30T09:10:38.658930+08:00

Dumping diagnostic data in directory=[cdmp_20180630091038], requested by (instance=1, osid=8582 (PR00)), summary=[incident=38786].

2018-06-30T09:10:39.594280+08:00

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

2018-06-30T09:10:39.594558+08:00

MRP0: Background Media Recovery process shutdown (orcl)

检查DG备库端状态：

[oracle@oracleme ~]$ sh check_dg_2.sh orcl

SQL*Plus: Release 12.2.0.1.0 Production on Sat Jun 30 09:28:53 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> 
INSTANCE_NAME                    STATUS
-------------------------------- ------------------------
orcl                             MOUNTED

SQL> 
NAME               DATABASE_ROLE
------------------ --------------------------------
OPEN_MODE
----------------------------------------
ORCL               PHYSICAL STANDBY
MOUNTED


SQL> 
   THREAD#   Sequence
---------- ----------
         1        104

SQL> 
  COUNT(*)
----------
        11

SQL> 
NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
spfile                               string
/home/app/oracle/12c/release_2
/db_1/dbs/spfileorcl.ora
SQL> 
NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
control_files                        string
/home/app/oracle/oradata/ORCL/
controlfile/o1_mf_fd8x9qp0_.ct
l, /home/app/oracle/fast_recov
ery_area/orcl/ORCL/controlfile
/o1_mf_fd8x9qwm_.ctl
SQL> 
NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
background_core_dump                 string
partial
background_dump_dest                 string
/home/app/oracle/12c/release_2
/db_1/rdbms/log
SQL> 
NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
local_listener                       string
LISTENER_ORCL
SQL> SQL> 
Summary Size of GB
------------------
        3.97949219

SQL> SQL> SQL> SQL> 
PROCESS            PID                                              CLIENT_PID           STATUS                   DELAY_MINS KNOWN_AGENTS ACTIVE_AGENTS
------------------ ------------------------------------------------ -------------------- ------------------------ ---------- ------------ -------------
ARCH               8331                                             8331                 CONNECTED                         0            0             0
ARCH               8341                                             8341                 CONNECTED                         0            0             0
ARCH               8339                                             8339                 CLOSING                           0            0             0
ARCH               8337                                             8337                 CONNECTED                         0            0             0
DGRD               8335                                             N/A                  ALLOCATED                         0            0             0
DGRD               8333                                             N/A                  ALLOCATED                         0            0             0
RFS                8357                                             2314                 IDLE                              0            0             0
RFS                8360                                             2312                 IDLE                              0            0             0
RFS                8350                                             2304                 IDLE                              0            0             0
RFS                8355                                             2310                 IDLE                              0            0             0
RFS                8364                                             2322                 IDLE                              0            0             0

11 rows selected.

SQL> SQL> SQL> SQL> 
NAME                                                                 THREAD#  SEQUENCE# First                                  Next                                   APPLIED
----------------------------------------------------------------- ---------- ---------- -------------------------------------- -------------------------------------- ------------------
/home/app/oracle/arch_log/1_99_972571706.dbf                               1         99 2018-05-30 14:28:49                    2018-05-30 14:29:10                    YES
/home/app/oracle/arch_log/1_100_972571706.dbf                              1        100 2018-05-30 14:29:10                    2018-05-30 14:36:53                    YES
/home/app/oracle/arch_log/1_101_972571706.dbf                              1        101 2018-05-30 14:36:53                    2018-05-30 14:36:54                    YES
/home/app/oracle/arch_log/1_102_972571706.dbf                              1        102 2018-05-30 14:36:54                    2018-05-30 14:48:59                    YES
/home/app/oracle/arch_log/1_103_972571706.dbf                              1        103 2018-05-30 14:48:59                    2018-05-30 14:49:58                    YES
/home/app/oracle/arch_log/1_104_972571706.dbf                              1        104 2018-05-30 14:49:58                    2018-05-30 14:50:00                    YES
/home/app/oracle/arch_log/1_105_972571706.dbf                              1        105 2018-05-30 14:50:00                    2018-05-30 22:01:03                    NO
/home/app/oracle/arch_log/1_106_972571706.dbf                              1        106 2018-05-30 22:01:03                    2018-05-31 03:49:16                    NO
/home/app/oracle/arch_log/1_107_972571706.dbf                              1        107 2018-05-31 03:49:16                    2018-05-31 23:01:49                    NO
/home/app/oracle/arch_log/1_108_972571706.dbf                              1        108 2018-05-31 23:01:49                    2018-06-01 06:06:06                    NO
/home/app/oracle/arch_log/1_109_972571706.dbf                              1        109 2018-06-01 06:06:06                    2018-06-01 23:13:36                    NO

NAME                                                                 THREAD#  SEQUENCE# First                                  Next                                   APPLIED
----------------------------------------------------------------- ---------- ---------- -------------------------------------- -------------------------------------- ------------------
/home/app/oracle/arch_log/1_110_972571706.dbf                              1        110 2018-06-01 23:13:36                    2018-06-02 07:00:09                    NO
/home/app/oracle/arch_log/1_111_972571706.dbf                              1        111 2018-06-02 07:00:09                    2018-06-02 12:34:46                    NO
/home/app/oracle/arch_log/1_112_972571706.dbf                              1        112 2018-06-02 12:34:46                    2018-06-02 19:30:25                    NO
/home/app/oracle/arch_log/1_113_972571706.dbf                              1        113 2018-06-02 19:30:25                    2018-06-02 23:15:51                    NO

15 rows selected.

SQL> SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@oracleme ~]$

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

[oracle@oracleme ~]$ sh check_dg_2.sh orcl

SQL*Plus: Release 12.2.0.1.0 Production on Sat Jun 30 09:28:53 2018

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

INSTANCE_NAME STATUS

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

orcl MOUNTED

SQL>

NAME DATABASE_ROLE

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

OPEN_MODE

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

ORCL PHYSICAL STANDBY

MOUNTED

SQL>

THREAD# Sequence

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

1 104

SQL>

COUNT(*)

----------

SQL>

NAME TYPE

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

VALUE

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

spfile string

/home/app/oracle/12c/release_2

/db_1/dbs/spfileorcl.ora

SQL>

NAME TYPE

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

VALUE

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

control_files string

/home/app/oracle/oradata/ORCL/

controlfile/o1_mf_fd8x9qp0_.ct

l, /home/app/oracle/fast_recov

ery_area/orcl/ORCL/controlfile

/o1_mf_fd8x9qwm_.ctl

SQL>

NAME TYPE

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

VALUE

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

background_core_dump string

partial

background_dump_dest string

/home/app/oracle/12c/release_2

/db_1/rdbms/log

SQL>

NAME TYPE

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

VALUE

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

local_listener string

LISTENER_ORCL

SQL> SQL>

Summary Size of GB

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

3.97949219

SQL> SQL> SQL> SQL>

PROCESS PID CLIENT_PID STATUS DELAY_MINS KNOWN_AGENTS ACTIVE_AGENTS

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

ARCH 8331 8331 CONNECTED 0 0 0

ARCH 8341 8341 CONNECTED 0 0 0

ARCH 8339 8339 CLOSING 0 0 0

ARCH 8337 8337 CONNECTED 0 0 0

DGRD 8335 N/A ALLOCATED 0 0 0

DGRD 8333 N/A ALLOCATED 0 0 0

RFS 8357 2314 IDLE 0 0 0

RFS 8360 2312 IDLE 0 0 0

RFS 8350 2304 IDLE 0 0 0

RFS 8355 2310 IDLE 0 0 0

RFS 8364 2322 IDLE 0 0 0

11 rows selected.

SQL> SQL> SQL> SQL>

NAME THREAD# SEQUENCE# First Next APPLIED

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

/home/app/oracle/arch_log/1_99_972571706.dbf 1 99 2018-05-30 14:28:49 2018-05-30 14:29:10 YES

/home/app/oracle/arch_log/1_100_972571706.dbf 1 100 2018-05-30 14:29:10 2018-05-30 14:36:53 YES

/home/app/oracle/arch_log/1_101_972571706.dbf 1 101 2018-05-30 14:36:53 2018-05-30 14:36:54 YES

/home/app/oracle/arch_log/1_102_972571706.dbf 1 102 2018-05-30 14:36:54 2018-05-30 14:48:59 YES

/home/app/oracle/arch_log/1_103_972571706.dbf 1 103 2018-05-30 14:48:59 2018-05-30 14:49:58 YES

/home/app/oracle/arch_log/1_104_972571706.dbf 1 104 2018-05-30 14:49:58 2018-05-30 14:50:00 YES

/home/app/oracle/arch_log/1_105_972571706.dbf 1 105 2018-05-30 14:50:00 2018-05-30 22:01:03 NO

/home/app/oracle/arch_log/1_106_972571706.dbf 1 106 2018-05-30 22:01:03 2018-05-31 03:49:16 NO

/home/app/oracle/arch_log/1_107_972571706.dbf 1 107 2018-05-31 03:49:16 2018-05-31 23:01:49 NO

/home/app/oracle/arch_log/1_108_972571706.dbf 1 108 2018-05-31 23:01:49 2018-06-01 06:06:06 NO

/home/app/oracle/arch_log/1_109_972571706.dbf 1 109 2018-06-01 06:06:06 2018-06-01 23:13:36 NO

NAME THREAD# SEQUENCE# First Next APPLIED

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

/home/app/oracle/arch_log/1_110_972571706.dbf 1 110 2018-06-01 23:13:36 2018-06-02 07:00:09 NO

/home/app/oracle/arch_log/1_111_972571706.dbf 1 111 2018-06-02 07:00:09 2018-06-02 12:34:46 NO

/home/app/oracle/arch_log/1_112_972571706.dbf 1 112 2018-06-02 12:34:46 2018-06-02 19:30:25 NO

/home/app/oracle/arch_log/1_113_972571706.dbf 1 113 2018-06-02 19:30:25 2018-06-02 23:15:51 NO

15 rows selected.

SQL> SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

[oracle@oracleme ~]$

可以看到DG的应用（MRP）已经停止。

查看与DG有[……]

Oracle DG：GAP检查脚本

By Adamhuan | 2018年5月30日

0 Comment

没啥好说的，直接看代码：

[oracle@oracleme ~]$ cat check_alert.sh 
sid=$1

echo "---------"
echo "SID is: $sid"
echo "---------"

#cat /u01/app/oracle/admin/$sid/bdump/alert_$sid.log | grep "Fetching gap sequence" | tail -n 1
#cat /u01/app/oracle/admin/$sid/bdump/alert_$sid.log | grep "(in transit)" | tail -n 1
#cat /u01/app/oracle/admin/$sid/bdump/alert_$sid.log | grep "Media Recovery Waiting for" | tail -n 1
#cat /u01/app/oracle/admin/$sid/bdump/alert_$sid.log | grep "Media Recovery Log" | tail -n 1

cat /home/app/oracle/diag/rdbms/$sid/$sid/trace/alert_$sid.log | grep "Fetching gap sequence" | tail -n 1
cat /home/app/oracle/diag/rdbms/$sid/$sid/trace/alert_$sid.log | grep "(in transit)" | tail -n 1
cat /home/app/oracle/diag/rdbms/$sid/$sid/trace/alert_$sid.log | grep "Media Recovery Waiting for" | tail -n 1
cat /home/app/oracle/diag/rdbms/$sid/$sid/trace/alert_$sid.log | grep "Media Recovery Log" | tail -n 1

echo "---------"
echo "End."
[oracle@oracleme ~]$ 
[oracle@oracleme ~]$ sh check_alert.sh orcl
---------
SID is: orcl
---------
Fetching gap sequence in thread 1, gap sequence 71-71
Media Recovery Waiting for thread 1 sequence 71 (in transit)
Media Recovery Waiting for thread 1 sequence 71 (in transit)
Media Recovery Log /home/app/oracle/arch_log/1_70_972571706.dbf
---------
End.
[oracle@oracleme ~]$

[oracle@oracleme ~]$ cat check_alert.sh

sid=$1

echo "---------"

echo "SID is: $sid"

echo "---------"

#cat /u01/app/oracle/admin/$sid/bdump/alert_$sid.log | grep "Fetching gap sequence" | tail -n 1

#cat /u01/app/oracle/admin/$sid/bdump/alert_$sid.log | grep "(in transit)" | tail -n 1

#cat /u01/app/oracle/admin/$sid/bdump/alert_$sid.log | grep "Media Recovery Waiting for" | tail -n 1

#cat /u01/app/oracle/admin/$sid/bdump/alert_$sid.log | grep "Media Recovery Log" | tail -n 1

cat /home/app/oracle/diag/rdbms/$sid/$sid/trace/alert_$sid.log | grep "Fetching gap sequence" | tail -n 1

cat /home/app/oracle/diag/rdbms/$sid/$sid/trace/alert_$sid.log | grep "(in transit)" | tail -n 1

cat /home/app/oracle/diag/rdbms/$sid/$sid/trace/alert_$sid.log | grep "Media Recovery Waiting for" | tail -n 1

cat /home/app/oracle/diag/rdbms/$sid/$sid/trace/alert_$sid.log | grep "Media Recovery Log" | tail -n 1

echo "---------"

echo "End."

[oracle@oracleme ~]$

[oracle@oracleme ~]$ sh check_alert.sh orcl

---------

SID is: orcl

---------

Fetching gap sequence in thread 1, gap sequence 71-71

Media Recovery Waiting for thread 1 sequence 71 (in transit)

Media Recovery Log /home/app/oracle/arch_log/1_70_972571706.dbf

---------

End.

[oracle@oracleme ~]$

如果上面ALERT的日志位置和我的不一样，… 可以自行修改。
——————————————
Done。

Oracle Database 12c：Data Guard in CentOS 7.4.1708

By Adamhuan | 2018年4月10日

0 Comment

开始本文的前提：
1. CentOS Linux 7.4.1708:2台
2. 都安装了Oracle 12c database
3. 主节点已经建好了库

在我的环境里：
Primary – 10.158.1.97
Standby – 10.158.1.161

文件：/etc/h[……]