RMAN增量恢复DataGuard备库
前言
在生产环境中有时候会出现由于网络或者人为删除等原因，导致主库的archivelog文件还没有传到备库，产生Gaps。那么我们有没有办法不重建备库来恢复DataGuard环境那？答案是当然的，Oracle官网的Oracle Data Guard Concepts and Administration文档中记录着在这种情况下，您可以使用RMAN的增量备份前滚物理备用数据库。下面我们就来演练一下
环境准备
准备两台已经配置好DataGuard环境的虚拟机
| 主机名 | IP地址 | 操作系统 | 数据库版本 | SID |
|---|---|---|---|---|
| 11g-primary | 192.168.17.91 | CentOS 7.9 | Oracle 11.2.0.4 | orcl |
| 11g-standby | 192.168.17.92 | CentOS 7.9 | Oracle 11.2.0.4 | orcldg |
主库
[oracle@11g-primary ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 23 22:56:11 2023
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> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /arch/
Oldest online log sequence 85
Next log sequence to archive 87
Current log sequence 87
SQL> select database_role,protection_mode,open_mode from v$database;
DATABASE_ROLE PROTECTION_MODE OPEN_MODE
---------------- -------------------- --------------------
PRIMARY MAXIMUM PERFORMANCE READ WRITE
SQL> select count(1) from sunying.t;
COUNT(1)
----------
1280000
SQL>
