adg的archive出现gap，使用增量恢复的方式进行恢复adg，RMAN-06094: datafile 1 must be restored

最新推荐文章于 2025-05-19 15:49:15 发布
最新推荐文章于 2025-05-19 15:49:15 发布
阅读量2.9k 收藏 2
点赞数
CC 4.0 BY-SA版权
分类专栏： oracle学习笔记
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m18994118189/article/details/82769773
本文介绍了一种在不重建物理DG的情况下恢复Oracle物理DG的方法。通过模拟归档文件丢失场景，详细展示了如何进行主库基于SCN的增量备份，并在备库恢复过程中解决数据文件名称和路径不匹配的问题。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

①　主库丢失归档文件，然后在不重建物理dg的情况下来恢复物理dg

一.4.2  实验过程

一.4.2.1  主备库环境

查看主库的信息：

 

SQL>select protection_mode,protection_level,database_role,force_logging,open_mode,switchover_status from v$database;

PROTECTION_MODE      PROTECTION_LEVEL     DATABASE_ROLE    FOR OPEN_MODE            SWITCHOVER_STATUS

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

MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  PRIMARY          YES READ WRITE           TO STANDBY

SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           /u01/arch/prod
Oldest online log sequence     153
Next log sequence to archive   0
Current log sequence           155

查看备库的信息：

SQL>select protection_mode,protection_level,database_role,force_logging,open_mode,switchover_status from v$database;

PROTECTION_MODE      PROTECTION_LEVEL     DATABASE_ROLE    FOR OPEN_MODE    SWITCHOVER_STATUS

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

MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  PHYSICAL STANDBY YES READ ONLY WITH APPLY NOT ALLOWED

已用时间:  00: 00: 00.06

20:40:44 SQL>

SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           /u01/arch/phy1
Oldest online log sequence     153
Next log sequence to archive   0
Current log sequence           155

20:43:23 SQL>

一.4.2.2  模拟归档丢失

备库操作，备库取消归档应用，让备库处于只读模式：

20:43:23 SQL> ALTER ATABASE recover managed standby DATABASE cancel;

 

数据库已更改。

SQL>select protection_mode,protection_level,database_role,open_mode,switchover_status from v$database;

 

 PROTECTION_MODE   PROTECTION_LEVEL   DATABASE_ROLE  FOR OPEN_MODE  SWITCHOVER_STATUS

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

MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  PHYSICAL STANDBY YES READ ONLY     NOT ALLOWED

 

主库配置归档2的状态为defer，目的是为了不把归档自动传递到备库,实际情况下往往是由于网络故障，备库挂掉等等情况导致，我们多次切换主库日志：

20:50:48 SQL>  ALTER system SET log_archive_dest_state_2 = 'defer';

SQL> alter system switch logfile;

、、、、、、、、、、

SQL> select count(*) from test.test;

  COUNT(*)
----------
    658944

SQL> 
SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           /u01/arch/prod
Oldest online log sequence     170
Next log sequence to archive   172
Current log sequence           172
SQL> col name for a100
set linesize 9999 pagesize 9999
SELECT dest_id,THREAD#,NAME,sequence#,archived,applied,a.NEXT_CHANGE# FROM v$archived_log a
WHERE a.sequence# >= 40
AND resetlogs_change# =(SELECT d.RESETLOGS_CHANGE# FROM v$database d)
ORDER BY a.THREAD#,a.sequence#,a.dest_id;SQL> SQL>   2    3    4  

   DEST_ID    THREAD# NAME                                                    SEQUENCE# ARC APPLIED   NEXT_CHANGE#
---------- ---------- ---------------------------------------------------------------------------------------------------- ---------- --- --------- ------------

     2        1 ogg1                                                                                          156 YES NO         1024803
     1        1 /u01/arch/prod/1_157_981738248.arc                                      157 YES NO         1024808
     1        1 /u01/arch/prod/1_158_981738248.arc                                      158 YES NO         1024814
     1        1 /u01/arch/prod/1_159_981738248.arc                                      159 YES NO         1024817
     1        1 /u01/arch/prod/1_160_981738248.arc                                      160 YES NO         1024820
     1        1 /u01/arch/prod/1_161_981738248.arc                                      161 YES NO         1024825
     1        1 /u01/arch/prod/1_162_981738248.arc                                      162 YES NO         1025156
     1        1 /u01/arch/prod/1_163_981738248.arc                                      163 YES NO         1025163
     1        1 /u01/arch/prod/1_164_981738248.arc                                      164 YES NO         1025171
     1        1 /u01/arch/prod/1_165_981738248.arc                                      165 YES NO         1025174
     1        1 /u01/arch/prod/1_166_981738248.arc                                      166 YES NO         1025177
     1        1 /u01/arch/prod/1_167_981738248.arc                                      167 YES NO         1025182
     1        1 /u01/arch/prod/1_168_981738248.arc                                      168 YES NO         1025185
     1        1 /u01/arch/prod/1_169_981738248.arc                                      169 YES NO         1025398
     1        1 /u01/arch/prod/1_170_981738248.arc                                      170 YES NO         1025405
     1        1 /u01/arch/prod/1_171_981738248.arc                                      171 YES NO         1025412

159 rows selected.

SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           /u01/arch/phy1
Oldest online log sequence     154
Next log sequence to archive   0
Current log sequence           156
SQL> col name for a100
set linesize 9999 pagesize 9999
SELECT dest_id,THREAD#,NAME,sequence#,archived,applied,a.NEXT_CHANGE# FROM v$archived_log a
WHERE a.sequence# >= 40
AND resetlogs_change# =(SELECT d.RESETLOGS_CHANGE# FROM v$database d)
ORDER BY a.THREAD#,aSQL> SQL>   2    3    4  .sequence#,a.dest_id;

   DEST_ID    THREAD# NAME                                                    SEQUENCE# ARC APPLIED   NEXT_CHANGE#
---------- ---------- ---------------------------------------------------------------------------------------------------- ---------- --- --------- ------------
     1        1 /u01/arch/phy1/1_152_981738248.arc                                      152 YES YES         1015367
     1        1 /u01/arch/phy1/1_153_981738248.arc                                      153 YES YES         1015455
     1        1 /u01/arch/phy1/1_154_981738248.arc                                      154 YES YES         1016001
     1        1 /u01/arch/phy1/1_155_981738248.arc                                      155 YES NO         1024646
     1        1 /u01/arch/phy1/1_156_981738248.arc                                      156 YES NO         1024803

40 rows selected.

 

可以看到，备库已经断档了，157到171都没有接收，接下来我们删除主库的归档日志，我们只删除54、55这2 个归档日志：

[oracle@primary prod]$ rm -rf 1_162_981738248.arc
[oracle@primary prod]$ rm -rf 1_163_981738248.arc
[oracle@primary prod]$ rm -rf 1_164_981738248.arc
[oracle@primary prod]$ rm -rf 1_165_981738248.arc
[oracle@primary prod]$ rm -rf 1_166_981738248.arc
[oracle@primary prod]$ rm -rf 1_167_981738248.arc
[oracle@primary prod]$ rm -rf 1_168_981738248.arc
[oracle@primary prod]$ rm -rf 1_169_981738248.arc

 

主库开启备库的归档：

SQL>  ALTER system SET log_archive_dest_state_2 = 'enable';

备库开启日志恢复模式：

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

Database altered.

SQL>  select thread#,low_sequence#,high_sequence# from v$archive_gap;

   THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
     1         162        169

可以看到备库已经产生gap 了。

 一.4.2.3  主库基于SCN备份

162-169号日志不见了，这个时候我们以162号的归档日志的next_change#即161号的first_change#为scn号来对主库基于scn的rman 增量备份。

SQL> 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 b.NEXT_CHANGE# FROM v$archived_log b WHERE b.SEQUENCE# = 161
AND resetlogs_change# = (SELECT d.RESETLOGS_CHANGE# FROM v$database d) AND rownum = 1) NEXT_CHANGE# FROM dual;  2    3    4    5    6  

DATAFILE_SCN DATAFILE_HEADER_SCN CURRENT_SCN NEXT_CHANGE#
------------ ------------------- ----------- ------------
     1024825         1024825     1024824

这几个值基本上差不多，我们可以以 2241214 或者2241213为基准来备份，若是数据文件和文件头的scn 不一致我们应该取这几个值中最小的一个。

在主库上进行增量备份：

RMAN> run
{
allocate channel d1 type disk;
allocate channel d2 type disk;
backup as compressed backupset incremental from SCN 1024824 database format '/u01/app/oracle/backup/standby_%d_%T_%U.bak' ;
release channel d1;
release channel d2;
} 

using target database control file instead of recovery catalog
allocated channel: d1
channel d1: SID=139 device type=DISK

allocated channel: d2
channel d2: SID=30 device type=DISK

Starting backup at 19-SEP-18
channel d1: starting compressed full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/ogg2/undotbs01.dbf
channel d1: starting piece 1 at 19-SEP-18
channel d2: starting compressed full datafile backup set
channel d2: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ogg2/system01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/ogg2/test03.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/ogg2/test05.dbf
input datafile file number=00010 name=/u01/app/oracle/oradata/ogg2/test031.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/ogg2/test032.dbf
channel d2: starting piece 1 at 19-SEP-18
channel d2: finished piece 1 at 19-SEP-18
piece handle=/u01/app/oracle/backup/standby_OGG2_20180919_1ctdg6a9_1_1.bak tag=FOR STANDBY comment=NONE
channel d2: backup set complete, elapsed time: 00:01:26
channel d2: starting compressed full datafile backup set
channel d2: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/ogg2/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ogg2/users01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ogg2/test01.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/ogg2/test02.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/ogg2/test04.dbf
channel d2: starting piece 1 at 19-SEP-18
channel d1: finished piece 1 at 19-SEP-18
piece handle=/u01/app/oracle/backup/standby_OGG2_20180919_1btdg6a9_1_1.bak tag=FOR STANDBY comment=NONE
channel d1: backup set complete, elapsed time: 00:01:34
channel d1: starting compressed full datafile backup set
channel d1: specifying datafile(s) in backup set
including standby control file in backup set
channel d1: starting piece 1 at 19-SEP-18
channel d1: finished piece 1 at 19-SEP-18
piece handle=/u01/app/oracle/backup/standby_OGG2_20180919_1etdg6d7_1_1.bak tag=FOR STANDBY comment=NONE
channel d1: backup set complete, elapsed time: 00:00:02
channel d2: finished piece 1 at 19-SEP-18
piece handle=/u01/app/oracle/backup/standby_OGG2_20180919_1dtdg6cv_1_1.bak tag=FOR STANDBY comment=NONE
channel d2: backup set complete, elapsed time: 00:00:30
Finished backup at 19-SEP-18

released channel: d1

released channel: d2

 

进行控制文件的备份：

RMAN>  run
{
allocate channel c1 type disk;
backup current controlfile for standby format '/u01/app/oracle/backup/db_%T_%d_%t_%s_%p.ctl';
}2> 3> 4> 5> 

released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=139 device type=DISK

Starting backup at 19-SEP-18
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including standby control file in backup set
channel c1: starting piece 1 at 19-SEP-18
channel c1: finished piece 1 at 19-SEP-18
piece handle=/u01/app/oracle/backup/db_20180919_OGG2_987241142_47_1.ctl tag=TAG20180919T093902 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 19-SEP-18
released channel: c1

将备份端数据启动该nomount进行恢复控制文件，然后启动到mount，在恢复数据文件

[oracle@standby backup]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Sep 19 09:55:15 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: OGG2 (not mounted)

RMAN> restore standby controlfile to '/u01/app/oracle/flash_recovery_area/ogg1/control02.ctl' from '/u01/app/oracle/backup/db_20180919_OGG2_987241142_47_1.ctl';

Starting restore at 19-SEP-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=125 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 19-SEP-18

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

二、 恢复备库，注意这个数据文件是主库中的数据文件名称，要先在数据库中将其修改成备库的数据库名称
RMAN> report schema
2> ;
RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name STANDBY

RMAN> report schema;

Starting implicit crosscheck backup at 19-SEP-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=139 device type=DISK
Finished implicit crosscheck backup at 19-SEP-18

Starting implicit crosscheck copy at 19-SEP-18
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 19-SEP-18

searching for all files in the recovery area
cataloging files...
no files cataloged

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name OGG1

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    0        SYSTEM               ***     /u01/app/oracle/oradata/ogg1/system01.dbf
2    0        SYSAUX               ***     /u01/app/oracle/oradata/ogg1/sysaux01.dbf
3    0        UNDOTBS1             ***     /u01/app/oracle/oradata/ogg1/undotbs01.dbf
4    0        USERS                ***     /u01/app/oracle/oradata/ogg1/users01.dbf
5    10       TEST                 ***     /u01/app/oracle/oradata/ogg1/test01.dbf
6    0        TEST                 ***     /u01/app/oracle/oradata/ogg1/test02.dbf
7    0        TEST                 ***     /u01/app/oracle/oradata/ogg1/test03.dbf
8    10       TEST2                ***     /u01/app/oracle/oradata/ogg1/test04.dbf
9    10       TEST2                ***     /u01/app/oracle/oradata/ogg1/test05.dbf
10   0        TEST                 ***     /u01/app/oracle/oradata/ogg1/test031.dbf
11   10       TEST                 ***     /u01/app/oracle/oradata/ogg1/test032.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/ogg1/temp01.dbf

但是备份端的数据文件名称和主库的数据文件名称和路径不一致：
[oracle@standby ogg1]$ ll
total 2549432
-rw-r----- 1 oracle oinstall  10043392 Sep 19 10:01 control01.ctl
-rw-r----- 1 oracle oinstall  52429312 Sep 14 13:44 redo01.log
-rw-r----- 1 oracle oinstall  52429312 Sep 14 13:44 redo02.log
-rw-r----- 1 oracle oinstall  52429312 Sep 14 13:44 redo03.log
-rw-r----- 1 oracle oinstall  52429312 Sep 19 10:01 standby01.log
-rw-r----- 1 oracle oinstall  52429312 Sep 19 09:29 standby02.log
-rw-r----- 1 oracle oinstall  52429312 Sep 14 13:25 standby03.log
-rw-r----- 1 oracle oinstall  52429312 Sep 14 13:25 standby04.log
-rw-r----- 1 oracle oinstall 629153792 Sep 19 09:29 sysaux.dbf
-rw-r----- 1 oracle oinstall 734011392 Sep 19 09:29 system.dbf
-rw-r----- 1 oracle oinstall  10493952 Sep 19 09:29 test01.dbf
-rw-r----- 1 oracle oinstall  10493952 Sep 19 09:29 test032.dbf
-rw-r----- 1 oracle oinstall  10493952 Sep 19 09:29 test04.dbf
-rw-r----- 1 oracle oinstall  10493952 Sep 19 09:29 test05.dbf
-rw-r----- 1 oracle oinstall 823140352 Sep 19 09:29 undotbs1.dbf
-rw-r----- 1 oracle oinstall   5251072 Sep 19 09:29 users.dbf
[oracle@standby ogg1]$ ls
control01.ctl  redo02.log  standby01.log  standby03.log  sysaux.dbf  test01.dbf   test04.dbf  undotbs1.dbf
redo01.log     redo03.log  standby02.log  standby04.log  system.dbf  test032.dbf  test05.dbf  users.dbf
[oracle@standby ogg2]$ ls
temp01.dbf  test02.dbf  test031.dbf  test03.dbf
所以要先进行：

#####如果想避免出现这种情况的话，在进行异地备份恢复的时候，在进行数据文件命名的时候严格按照主库的数据文件名称来定义######
[oracle@standby ogg2]$ mv * ../ogg1
[oracle@standby ogg2]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 19 11:09:48 2018

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


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

SQL> alter database rename file '/u01/app/oracle/oradata/ogg2/test02.dbf' to '/u01/app/oracle/oradata/ogg1/test02.dbf';

Database altered.

SQL> alter database rename file '/u01/app/oracle/oradata/ogg2/test03.dbf' to '/u01/app/oracle/oradata/ogg1/test03.dbf';

Database altered.

SQL> alter database rename file '/u01/app/oracle/oradata/ogg2/temp01.dbf' to '/u01/app/oracle/oradata/ogg1/temp01.dbf';

Database altered.

SQL> alter database rename file '/u01/app/oracle/oradata/ogg2/test031.dbf' to '/u01/app/oracle/oradata/ogg1/test031.dbf';

Database altered.

SQL> alter system set standby_file_management=auto scope=both sid='*';

System altered.

SQL> alter system set standby_file_management=manual scope=both;

System altered.

SQL> alter database rename file '/u01/app/oracle/oradata/ogg1/system01.dbf' to '/u01/app/oracle/oradata/ogg1/system.dbf';

Database altered.


SQL> alter database rename file '/u01/app/oracle/oradata/ogg1/sysaux01.dbf' to '/u01/app/oracle/oradata/ogg1/sysaux.dbf';

Database altered.


SQL> alter database rename file '/u01/app/oracle/oradata/ogg1/users01.dbf' to '/u01/app/oracle/oradata/ogg1/users.dbf';

Database altered.

SQL> alter database rename file '/u01/app/oracle/oradata/ogg1/undotbs01.dbf' to '/u01/app/oracle/oradata/ogg1/undotbs1.dbf';                

Database altered.

SQL>  alter system set standby_file_management=auto scope=both sid='*';

System altered.

RMAN> report schema;

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name STANDBY


List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    700      SYSTEM               ***     /u01/app/oracle/oradata/ogg1/system.dbf
2    600      SYSAUX               ***     /u01/app/oracle/oradata/ogg1/sysaux.dbf
3    785      UNDOTBS1             ***     /u01/app/oracle/oradata/ogg1/undotbs1.dbf
4    5        USERS                ***     /u01/app/oracle/oradata/ogg1/users.dbf
5    10       TEST                 ***     /u01/app/oracle/oradata/ogg1/test01.dbf
6    10       TEST                 ***     /u01/app/oracle/oradata/ogg1/test02.dbf
7    10       TEST                 ***     /u01/app/oracle/oradata/ogg1/test03.dbf
8    10       TEST2                ***     /u01/app/oracle/oradata/ogg1/test04.dbf
9    10       TEST2                ***     /u01/app/oracle/oradata/ogg1/test05.dbf
10   10       TEST                 ***     /u01/app/oracle/oradata/ogg1/test031.dbf
11   10       TEST                 ***     /u01/app/oracle/oradata/ogg1/test032.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/ogg1/temp01.dbf

RMAN> recover database noredo;

Starting recover at 19-SEP-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /u01/app/oracle/oradata/ogg1/system.dbf
destination for restore of datafile 00002: /u01/app/oracle/oradata/ogg1/sysaux.dbf
destination for restore of datafile 00004: /u01/app/oracle/oradata/ogg1/users.dbf
destination for restore of datafile 00006: /u01/app/oracle/oradata/ogg1/test02.dbf
destination for restore of datafile 00008: /u01/app/oracle/oradata/ogg1/test04.dbf
destination for restore of datafile 00010: /u01/app/oracle/oradata/ogg1/test031.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/backup/standby_OGG2_20180919_1gtdg6n4_1_1.bak
channel ORA_DISK_1: piece handle=/u01/app/oracle/backup/standby_OGG2_20180919_1gtdg6n4_1_1.bak tag=TAG20180919T093948
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /u01/app/oracle/oradata/ogg1/undotbs1.dbf
destination for restore of datafile 00005: /u01/app/oracle/oradata/ogg1/test01.dbf
destination for restore of datafile 00007: /u01/app/oracle/oradata/ogg1/test03.dbf
destination for restore of datafile 00009: /u01/app/oracle/oradata/ogg1/test05.dbf
destination for restore of datafile 00011: /u01/app/oracle/oradata/ogg1/test032.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/backup/standby_OGG2_20180919_1htdg6n4_1_1.bak
channel ORA_DISK_1: piece handle=/u01/app/oracle/backup/standby_OGG2_20180919_1htdg6n4_1_1.bak tag=TAG20180919T093948
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

Finished recover at 19-SEP-18

RMAN> exit


Recovery Manager complete.
[oracle@standby dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 19 11:21:20 2018

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


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

SQL> col name for a100
set linesize 9999 pagesize 9999
SELECT dest_id,THREAD#,NAME,sequence#,archived,applied,a.NEXT_CHANGE# FROM v$archived_log a
WHERE a.sequence# >= 40
AND resetlogs_change# =(SELECT d.RESETLOGS_CHANGE# FROM v$database d)
ORDER BY a.THREAD#,aSQL> SQL> .sequence#,a.dest_id;
  2    3    4  
   DEST_ID    THREAD# NAME                                                    SEQUENCE# ARC APPLIED   NEXT_CHANGE#
---------- ---------- ---------------------------------------------------------------------------------------------------- ---------- --- --------- ------------
     2        1 /u01/arch/phy1/1_173_981738248.arc                                      173 YES NO         1027491
     2        1 /u01/arch/phy1/1_174_981738248.arc                                      174 YES NO         1027693
     1        1 /u01/arch/phy1/1_175_981738248.arc                                      175 YES NO         1027993
     1        1 /u01/arch/phy1/1_176_981738248.arc                                      176 YES NO         1031524
     1        1 /u01/arch/phy1/1_177_981738248.arc                                      177 YES NO         1032805
     1        1 /u01/arch/phy1/1_178_981738248.arc                                      178 YES NO         1033214

6 rows selected.

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

Database altered.

SQL> col name for a100
set linesize 9999 pagesize 9999
SELECT dest_id,THREAD#,NAME,sequence#,archived,applied,a.NEXT_CHANGE# FROM v$archived_log a
WHERE a.sequence# >= 40
AND resetlogs_change# =(SELECT d.RESETLOGS_CHANGE# FROM v$database d)
ORDER BY a.THREAD#,aSQL> SQL>   2    3    4  .sequence#,a.dest_id;

   DEST_ID    THREAD# NAME                                                    SEQUENCE# ARC APPLIED   NEXT_CHANGE#
---------- ---------- ---------------------------------------------------------------------------------------------------- ---------- --- --------- ------------
     2        1 /u01/arch/phy1/1_173_981738248.arc                                      173 YES YES         1027491
     2        1 /u01/arch/phy1/1_174_981738248.arc                                      174 YES YES         1027693
     1        1 /u01/arch/phy1/1_175_981738248.arc                                      175 YES YES         1027993
     1        1 /u01/arch/phy1/1_176_981738248.arc                                      176 YES YES         1031524
     1        1 /u01/arch/phy1/1_177_981738248.arc                                      177 YES YES         1032805
     1        1 /u01/arch/phy1/1_178_981738248.arc                                      178 YES IN-MEMORY     1033214

6 rows selected.

SQL> select * from v$archive_gap;

no rows selected

四、 备库read only 模式打开

22:41:41 SQL> alter database recover managed standby database cancel;

数据库已更改。

已用时间:  00: 00: 01.00

22:43:40 SQL> alter database open;

数据库已更改

已用时间:  00: 00: 00.22

22:43:45 SQL> alter database recover managed standby database using current logfile disconnect from session;

数据库已更改。

Oracle DG复制中断：RMAN-03015和RMAN-06094
Sebastien23的博客
08-21 1189
⭐️。
ORA-01152: file 1 was not restored from a sufficiently old backup
weixin_34343000的博客
07-25 634
问题描述 我们在用rman恢复数据库时当执行到将数据库open阶段遇到ORA-01152错误。问题分析 由于controlfile里记录的SCN与datafile里的不一致导致。比如通过restore出来的controlfile的SCN比datafile记录的要小。解决方法有两条：A)以old controlfile的SCN为准，将datafile恢复到与其一致，...
oracle恢复失败,rman增量恢复失败RMAN-06094？？？？
weixin_39683172的博客
04-11 814
本帖最后由 刚在路 于 2015-5-14 23:24 编辑Oracle 11.2.0.4在做增量恢复时失败，实验 先restore 全备 再recover 增量备份：RMAN> shutdown immediate;database dismountedOracle instance shut downRMAN> startup nomount;connected to ta...
RMAN-06094: datafile 1 must be restored ID 1339439.1
热门推荐
u010692693的专栏
11-15 1万+
一次Data Guard断档，主端归档日志被删除，通过基于SCN在主端做增量备份，备端recover database时出现类似以下报错： RMAN> RECOVER DATABASE; Starting recover at 18 JUL 2011 18:12:10 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=267 devty
Oracle【容灾篇】02：Oracle19c ADG 搭建步骤
最新发布
weixin_40612128的博客
05-19 1728
Oracle19c ADG 搭建步骤
RMAN-06555: datafile 1 must be restored from backup created before ***
雅冰石的专栏
01-12 1770
recover指令只能再基于数据文件时间点往后恢复
RMAN-06094
喝醉酒的小白
01-13 2323
表空间为read only
oracle进行rman增量恢复时报错RMAN-06094
m0_46400195的博客
06-22 2151
rman恢复增量备份最后一步recover database noredo的时候报错RMAN-0057、RAMN00569、RMAN-00571、RMAN-03002、RMAN06094 解决办法： 发现主库增加了datafile，备库没有。 备份主库的这个文件，到备库rman执行run 执行完毕run后，在执行restore database noredo;成功。...
使用Rman增量备份修复Oracle11g adg传输Gap
gumengkai的博客
12-27 2283
场景：主库在传输之前被删除导致出现gap 数据库版本：Oracle11.2.0.4 此时，备库依然可以接收来自主库的归档，但不会应用 Wed Dec 27 09:07:27 2017 FAL[client]: Failed to request gap sequence GAP - thread 1 sequence 73-73 DBID 1485808053 branch
oracle adg 备份,Oracle Physical Dataguard环境使用RMAN备份和恢复
weixin_35326667的博客
04-08 1108
Oracle Physical Dataguard环境使用RMAN备份和恢复由于Physical Dataguard使用的是块恢复技术来保持和PRIMARY的一致性，因此可以在STANDBY上进行rman备份，从而减轻PRIMARY的压力.当PRIMARY出现数据库故障时，可以使用在STANDBY上的备份来进行恢复.先决条件：需要配置catalog.在PRIMARY上以catalog方式连接，并且...
RMAN-06094 Datafile does not exist
congfen5646的博客
05-08 469
RMAN-06094 Datafile does not exist Applies to:oracle server version 10.2.0.2 and later.Symptomeswhen trying t...
Oracle DG基于SCN的增量备份与恢复
12-14
说明：本文为Oracle DG中使用RMAN进行基于SCN的增量备份与恢复指导手册 标签：基于SCN的增量备份于恢复、DG备库恢复、DG断档恢复、Rman备份恢复 基础环境：对于DG（Oracle DATAGUARD）的安装配置本文不再指导，用户可以自行搜索相关文章 温馨提示：如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化 ※ 实验环境 系统  ：Linux 6.4 Oracle：11.2.0.3 单实例 源端  ：IP:1.1.1.7 DB_NAME:orcl SERVICE_NAME:orcl 目标端：IP:1.1.1.8 DB_NAME:orcl SERVICE_
使用RMAN复制活动数据库（文件路径不同）
12-14
OS：Oracle Linux 5u8 　　DB：11.2.0.4 　　路径相同的情况下，见：http://blog.itpub.net/22621861/viewspace-1431461/ 　　1. 为辅助数据库创建密码文件（文件名必须以orapw开头） 　　orapwd file=$ORACLE_HOME/dbs/orapwnewdb password=oracle1 entries=3 　　2. 为辅助数据库创建临时参数文件 　　好从目标数据库创建然后复制过去（前提是有相同的内存大小），以下参数有必要多确认 　　DB_NAME=jun 　　DB_BLOCK_SIZE=8
用rman恢复数据文件
Hody
02-18 899
[root@orahost ~]# su - oracle [oracle@orahost ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 5 01:19:46 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. C
模拟ADG主库归档文件丢失，备库出现gap（增量备份解决）
the_coco的博客
07-25 1256
我这里主库数据文件位置是’/u01/app/oracle/oradata/P9C/’，备库是’/u01/app/oracle/oradata/P9C/’，应该是需要此步骤的，但不知道为什么后面4.1.13查看重命名数据文件时会报错。由于备库关闭了归档日志实时同步，所以11,12号归档日志已经传到备库但没有应用。（这里备库打开日志实时应用还是查不到日志编号，后面主库切换日志后可以查到）由于主备库12号日志被删除，导致备库12号及以后的日志都无法应用。由于备库缺少12号日志，导致主备库测试表信息不一致。
Dataguard gap修复,增量恢复
sqlora的专栏
07-02 1327
Dataguard gap修复 https://blog.csdn.net/kiral07/article/details/87191787 https://www.2cto.com/database/201605/507685.html 1.首先来模拟Gap的产生 1.1.备库关闭： SYS@dgtest_s>shutdown immediate; 1.2.主库切...
dg中基于scn恢复RMAN-06094故障解决
Brent的专栏
02-05 1663
dataguard中出现gap后,采用基于scn的备份和恢复的方法进行恢复. 在恢复的过程中出现报错: RMAN> recover database noredo; Starting recover at 05-FEB-20 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 usin...
Oracle DG gap 手动同步
phantom in ORACLE
04-06 1953
oralce 11g 单节点主备同步环境，备库提供read（open状态）。实时同步方式。 主库重启后，没有按照正常顺序启动和关闭备库及日志应用。早上发现后，已经出现很多gap。1.在备库的日志里去查看，说是等待sequence 3362的日志，其实主库上的最小（最早的）的日志已经到3370了。。也就是主库已经没有3362的日志了。所以要恢复出来。2.当然可以通过sequence或者scn恢复，
adg搭建备库，归档缺失（GAP）
qq_45420945的博客
07-18 1143
Oracle DG (GAP)
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/01/2025 14:00:19 ORA-19504: ??????"/root/archivelog_ORCL_21_1.arc" ORA-27041: ?????? Linux-x86_64 Error: 2: No such file or directory Additional information: 9
04-02
对于 ADG 场景下的路径冲突，可通过 `SWITCH DATAFILE TO COPY` 命令重新定位副本文件[^4]。 --- ##### 4. 手动处理损坏块 当遇到 ORA-19566 提示超过允许的损坏块数时，应先识别具体的损坏块信息。以下是诊断和...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值