dataguard却少日志文件的处理过程

最新推荐文章于 2024-01-25 14:14:32 发布
最新推荐文章于 2024-01-25 14:14:32 发布
阅读量2.6k 收藏
点赞数
分类专栏： oracledataguard
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/heizistudio/article/details/8239403
版权

1、环境

主从oracle数据库运行在最高可用模式

数据一致

 

2、从库上，关闭数据库，使主库归档不能传送到备库

SQL> shutdown immediate
ORA-01109: database not open

 3、主库上创建新表、切换日志

SQL> insert into test0008 select * from dba_objects;                                                                      

49942 rows created.

SQL> commit;                                                                                                              

Commit complete.

SQL> alter system switch logfile;                                                                                         

System altered.

SQL> create table test0009 as select * from test0008;                                                                                                                 

Table created.

SQL> alter system switch logfile;                                                                                                                                     

System altered.

SQL> create table test0010 as select * from test0008;                                                                                                                 

Table created.

SQL> alter system switch logfile;                                                                                                                                     

System altered.

SQL> create table test0011 as select * from test0008;                                                                                                                 

Table created.

SQL> alter system switch logfile;                                                                                                                                     

System altered.

SQL> create table test0012 as select * from test0008;                                                                                                                 

Table created.

SQL> alter system switch logfile;                                                                                                                                     

System altered.

SQL> create table test0013 as select * from test0008;                                                                                                                 

Table created.

SQL> alter system switch logfile;                                                                                                                                     

System altered.

SQL> create table test0014 as select * from test0008;                                                                                                                 

Table created.

SQL> alter system switch logfile;    

                                                                                                                                 

-------------产生的新日志--------------------------------

-rw-r----- 1 oracle oinstall  2427904 11-29 14:58 1_326_777229099.dbf
-rw-r----- 1 oracle oinstall  5924864 11-29 14:58 1_327_777229099.dbf
-rw-r----- 1 oracle oinstall  5926912 11-29 14:59 1_328_777229099.dbf
-rw-r----- 1 oracle oinstall  5922816 11-29 14:59 1_329_777229099.dbf
-rw-r----- 1 oracle oinstall  5970944 11-29 14:59 1_330_777229099.dbf
-rw-r----- 1 oracle oinstall  5923328 11-29 14:59 1_331_777229099.dbf

 

--为避免备库启动数据库后同步日志，进行更名操作

[oracle@dd duxiulog]$ mv 1_326_777229099.dbf 1_326_777229099.dbf.bk
[oracle@dd duxiulog]$ mv 1_327_777229099.dbf 1_327_777229099.dbf.bk
[oracle@dd duxiulog]$ mv 1_328_777229099.dbf 1_328_777229099.dbf.bk
[oracle@dd duxiulog]$ mv 1_329_777229099.dbf 1_329_777229099.dbf.bk
[oracle@dd duxiulog]$ mv 1_330_777229099.dbf 1_330_777229099.dbf.bk
[oracle@dd duxiulog]$ mv 1_331_777229099.dbf 1_331_777229099.dbf.bk

 

4、备库启动到mount状态，开启接收日志

SQL> startup mount
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218992 bytes
Variable Size              92276304 bytes
Database Buffers          188743680 bytes
Redo Buffers                2973696 bytes
Database mounted.
SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

跟踪后台alert文件

tailf alert_duxiu.log

MRP0: Background Managed Standby Recovery process started (duxiu)
Managed Standby Recovery starting Real Time Apply
Media Recovery Waiting for thread 1 sequence 326
Fetching gap sequence in thread 1, gap sequence 326-331
FAL[client]: Error fetching gap sequence, no FAL server specified
Thu Nov 29 15:11:39 2012
Completed: alter database recover managed standby database using current logfile disconnect from session
Thu Nov 29 15:12:08 2012
FAL[client]: Failed to request gap sequence
 GAP - thread 1 sequence 326-331
 DBID 1418004073 branch 777229099
FAL[client]: All defined FAL servers have been attempted.
-------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that is sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.

查看数据库V$ARCHIVE_GAP视图

SQL>  SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;

   THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
         1           326            331

5、将缺失日志拷贝到备库（现实环境中可以rman恢复日志，拷贝到备库）

[oracle@dd duxiulog]$ scp *.bk 192.168.90.119:/media/duxiustandbylog/
oracle@192.168.90.119's password:
1_326_777229099.dbf.bk                                                                                                               100% 2371KB   2.3MB/s   00:00   
1_327_777229099.dbf.bk                                                                                                               100% 5786KB   5.7MB/s   00:00   
1_328_777229099.dbf.bk                                                                                                               100% 5788KB   5.7MB/s   00:01   
1_329_777229099.dbf.bk                                                                                                               100% 5784KB   5.7MB/s   00:00   
1_330_777229099.dbf.bk                                                                                                               100% 5831KB   5.7MB/s   00:00   
1_331_777229099.dbf.bk                                                                                                               100% 5785KB   5.7MB/s   00:00   

6、在备库上注册归档日志

SQL> ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_326_777229099.dbf';

Database altered.

SQL> ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_327_777229099.dbf';

Database altered.

SQL> ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_328_777229099.dbf';

Database altered.

SQL> ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_329_777229099.dbf';

Database altered.

SQL> ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_330_777229099.dbf';

Database altered.

SQL> ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_331_777229099.dbf';

Database altered.

7、跟踪后台alert文件

ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_326_777229099.dbf'
Thu Nov 29 15:13:34 2012
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Completed: ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_326_777229099.dbf'
Thu Nov 29 15:13:38 2012
Media Recovery Log /media/duxiustandbylog/1_326_777229099.dbf
Media Recovery Waiting for thread 1 sequence 327
Fetching gap sequence in thread 1, gap sequence 327-331
FAL[client]: Error fetching gap sequence, no FAL server specified
Thu Nov 29 15:13:56 2012
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_327_777229099.dbf'
Thu Nov 29 15:13:56 2012
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Completed: ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_327_777229099.dbf'
Thu Nov 29 15:14:01 2012
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_328_777229099.dbf'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Completed: ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_328_777229099.dbf'
Thu Nov 29 15:14:06 2012
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_329_777229099.dbf'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Completed: ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_329_777229099.dbf'
Thu Nov 29 15:14:08 2012
Media Recovery Log /media/duxiustandbylog/1_327_777229099.dbf
Media Recovery Log /media/duxiustandbylog/1_328_777229099.dbf
Media Recovery Log /media/duxiustandbylog/1_329_777229099.dbf
Media Recovery Waiting for thread 1 sequence 330
Fetching gap sequence in thread 1, gap sequence 330-331
FAL[client]: Error fetching gap sequence, no FAL server specified
Thu Nov 29 15:14:20 2012
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_330_777229099.dbf'
Thu Nov 29 15:14:20 2012
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Completed: ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_330_777229099.dbf'
Thu Nov 29 15:14:24 2012
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_331_777229099.dbf'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Completed: ALTER DATABASE REGISTER PHYSICAL LOGFILE '/media/duxiustandbylog/1_331_777229099.dbf'
Thu Nov 29 15:14:39 2012
Media Recovery Log /media/duxiustandbylog/1_330_777229099.dbf
Media Recovery Log /media/duxiustandbylog/1_331_777229099.dbf
Media Recovery Log /media/standby_redo/1_332_777229099.dbf
Media Recovery Waiting for thread 1 sequence 333 (in transit)
Thu Nov 29 15:14:40 2012
Recovery of Online Redo Log: Thread 1 Group 4 Seq 333 Reading mem 0
  Mem# 0 errs 0: /opt/oracle/oradata/duxiu/redostandby01.log
Thu Nov 29 15:15:18 2012
Primary database is in MAXIMUM AVAILABILITY mode
Changing standby controlfile to MAXIMUM AVAILABILITY level
RFS[2]: Successfully opened standby log 5: '/opt/oracle/oradata/duxiu/redostandby02.log'
Thu Nov 29 15:15:19 2012
Media Recovery Waiting for thread 1 sequence 334 (in transit)
Thu Nov 29 15:15:19 2012
Recovery of Online Redo Log: Thread 1 Group 5 Seq 334 Reading mem 0
  Mem# 0 errs 0: /opt/oracle/oradata/duxiu/redostandby02.log

已经运行在最高可用模式了

8、

查看数据库V$ARCHIVE_GAP视图

SQL> SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;

no rows selected

SQL>

9、切换到只读状态核实数据是否一致


SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open read only;

Database altered.

SQL> select count(*) from test0014;

  COUNT(*)
----------
     49942

SQL>

主库上同样查看：

SQL> select count(*) from test0014;                                                                                                                                   

  COUNT(*)
----------
     49942

SQL>

10、将备库切换到恢复日志状态

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

Database altered.

SQL>

 

ora600
关注
专栏目录
oracle dataguard 日志 很多no,Oracle DataGuard归档日志丢失处理方法
weixin_39805195的博客
04-03 247
问题描述9.3日dg备库异常关闭，9.17日主库磁盘空间满，删除了归档日志，导致备库丢失了9.3号到9.17号得归档日志，所以当9.24日启动备库时报错ORA-10458: standby database requires recoveryORA-01196: file 1 is inconsistent due to a failed media recovery sessionORA-011...
Oracle 11g Dataguard环境下数据文件、日志文件管理（下）
ciqu9915的博客
05-07 191
下面我们讨论redo log的情况。 3、online redo log情况——Primary端 相对于data file，online redo l...
Oracle物理DataGuard:增加或删除联机日志文件
Data & Analysis
01-07 441
Changingthe size and number of the online redo log files is sometimes done to tune the database. You can add or drop online redo log file groups or members to the primary database without affecting t...
oracle dataguard 环境下处理从库归档日志的缺失
一名数据库爱好者的专栏
06-10 850
1、在备库检查是否有日志缺失 SQL> select * from V$ARCHIVE_GAP; 2、在主库中查询缺失的日志的所在路径和名称 SQL> SELECT NAME FROM V$ARCHIVED_LOG WHERE 1=1 AND THREAD#=1 AND DEST_ID=1 AND SEQUENCE# BETWEEN 99 AND 109 ; ...
ORACLE DATA GUARD搭建时备库忘建redo日志处理
袁子建
06-22 896
搭建DATA GUARD，利用RMAN备份恢复备库时，由于RMAN不会备份REDO文件，还原后的备库缺少REDO日志文件，对于用归档日志 同步数据的备库，影响不是很大，依然可以应用日志同步主库的数据变更，但是如果主/备库切换的话，就不行了，对于这样 控制文件里记录了REDO的信息，但是在存储上却没有对应的文件的备库，此时删除控制文件中的REDO信息是不允许的。1 SQL> alter database drop logfile group 1; alter database drop logfile.
ORACLE DATAGUARD中手工处理日志v$archive_GAP的方法
09-10
在9i版本之后，DataGuard引入了Fast Application Notification (FAL)特性，该特性大大简化了日志传输和应用的过程，通常情况下，FAL会自动处理丢失的日志，确保备用数据库与主数据库保持同步。 然而，在某些特殊...
dataguard丢失日志处理方法 2
03-25
### Dataguard丢失日志处理方法详解 #### 一、问题背景及原因分析 在Oracle数据库的Dataguard环境中，可能会遇到数据丢失的情况，尤其是在主备切换或灾难恢复的过程中。当发现日志丢失时，首先需要确认日志丢失的...
关于Oracle Dataguard 日志传输状态监控问题
09-09
- **查询缺失日志**：在主库上通过`V$ARCHIVED_LOG`找出缺失的日志文件及其路径。 - **手动复制日志**：将缺失的日志文件从主库复制到备库的相应归档目录。 - **手动注册日志**：使用`ALTER DATABASE REGISTER LOG...
清理备库已经应用的归档日志
07-06
在Oracle数据库中，当redo log文件填满时，当前的redo log组会切换到下一个未使用的组，而旧的日志文件则被归档，生成归档日志文件。这些文件包含自上次归档以来的所有更改，对于备库来说，它们用于将变更应用到备用...
Dataguard丢失日志恢复与备份策略
总结来说，处理 Data Guard 日志丢失涉及到日志文件的定位、数据恢复操作以及控制文件的同步。这些步骤旨在确保数据完整性，减少数据丢失的风险，并恢复到一个可接受的状态。在整个过程中，RMAN 扮演着关键角色，...
Oracle DataGuard主库丢失archivelog，如何不重建备库完成同步？
Simple Life
12-06 2452
在Oracle DataGuard主从同步过程中可能出现主库archivelog丢失，备库出现gap错误。此时，除了重新完整搭建DataGuard之外呢，可以通过主库增量备份完成备份重新同步。   【主要步骤】 1.在备库上找出当前scn； 2.根据此scn，在主库上使用rman完成增量备份； 3.传输增量备份到备库，同时在备库上恢复； 4.重新启动备库同步。   【演示示例】
Oracle DG 手动备库应用缺失日志
03-18 539
'/u01/app/oracle/oradata/flash_recovery_area/ORCLST/archivelog/2023_03_18/o1_mf_1_17_l1cmd1wk_.arc'^C已经应用ID----------100200200300。
dataguard容灾归档缺失恢复(pr归档还在）
Du.的博客
10-21 686
容灾库恢复
Oracle DG日志丢失恢复
gaobudong1234的博客
02-22 1376
Oracle DG日志丢失恢复如何发现日志丢失？col name format a30col value format a30col time_computed format a30set linesize 200select name,value,time_computed from V$dataguard_stats;1. 检查日志应用情况：set linesize 200 pagesize ...
FAL_CLIENT和FAL_SERVER 不设置也能apply redo
jnrjian的博客
04-20 1482
FAL_CLIENT和FAL_SERVER是配置dataguard用到的两个参数,FAL指获取归档日志(Fetch Archived Log) 正常情况MRP进程负责FAL，出现GAP使用RFS进程读取FAL_SERVER=pri，设置FAL_CLIENT=dg 因为主库可能反向查询dg的信息，这两个值就是TNS中的，和rman duplicate时一样的。 在一定的条件下，或者因为网络失败，或者因为资源紧张，会在primary和standby之间产生裂隙，也就是有些归档日志没有及时的传输并应..
FAL[client]: Failed to request gap sequence
hpy1985的博客
01-04 1901
一：问题描述 主备库所在机器都重启后，rac（主库）开机自动启动，但备库（单实例）不是开机启动，现已手工启动到mount，并已在备库上alterdatabaserecoverstandbydatabasedisconnectfromsession;。 发现主库归档日志无法同步到备库： rac1： rac2： 备库： --奇怪的是，v$archive_gap竟然还为空。 查看报警日志： 二：解决办法 首先检查一下备库监听是否启动（当状态为‘rea...
oracle数据同步失败返回1,Oracle DG同步失败故障处理(二)
weixin_36336710的博客
04-03 772
环境：OS:AIX 7.1DB:主库：oracle RAC 11.2.0.4.0备库：Oracle RAC 11.2.0.4.0问题：备库节点一，关闭selinux，重启服务器生效，数据库启动后，发现备库端可以接收主库归档，但是无法应用归档。问题原因：之前备库mrp进程在节点一上，备库重启服务器前，并没有将mrp进程切换到节点二上，备库节点一重启服务器后，没有马上执行mrp进程，导致备库没有应用主...
74.ORA-16191问题修复&基于SCN增量修复DG
最新发布
weixin_43346403的博客
01-25 539
基于SCN的增量修复是快速修复DG的有效方法，其底层原理是基于块级别的复制，类似增量备份，然后量部分内容进行合并。3.使用增量备份恢复的方法修复从库。--查看备份的起点:最小的SCN;4.启动同步进程，检查同步状态等。3.主库端基于scn的增量备份。从库的ALERT日志。
oracle 10092,STANDBY数据库出ORA-1009错误
weixin_36060333的博客
04-05 292
在10.2.0.4DATA GUARD的STANDBY数据库中，出现了大量的ORA-1009错误。错误信息为：Thu May 31 14:11:16 2012FAL[client, MRP0]: Error 1009 fetching archived redo log from orclThu May 31 14:11:16 2012Errors in file /opt/app/oradir/...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值