OracleDG备库修复 – Digeekao's blog

适用于DG关系已经建立，因为某些原因导致备库数据损坏的情况。

不适用于备库实例损坏、控制文件损坏、参数文件损坏、密码文件损坏等非数据损坏情况。

对主库进行全备份

rman target /

RMAN> backup database format '/backup/full_backup_%T_%t.bak';

将备份文件传输至备库

将备份文件传输至备库服务器/backup下

在备库进入rman

rman target /

恢复数据库

RMAN> alter database mount;
RMAN> catalog start with '/backup/full_backup_20210527_949796538.bak'
RMAN> restore database;

打开备库

SQL> alter database open;

备库开启日志应用

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

主库建表插入数据，切换日志进行测试。

常用验证语句

识别现有的归档redo log文件
在备库操作

SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME -
>  FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

 SEQUENCE# FIRST_TIME         NEXT_TIME
---------- ------------------ ------------------
         8 11-JUL-07 17:50:45 11-JUL-07 17:50:53
         9 11-JUL-07 17:50:53 11-JUL-07 17:50:58
        10 11-JUL-07 17:50:58 11-JUL-07 17:51:03

3 rows selected.

在主库强制切换并归档当前redo log文件

SQL> ALTER SYSTEM SWITCH LOGFILE;

验证新redo文件已经在备库归档

SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME -
> FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

 SEQUENCE# FIRST_TIME         NEXT_TIME
---------- ------------------ ------------------
         8 11-JUL-07 17:50:45 11-JUL-07 17:50:53
         9 11-JUL-07 17:50:53 11-JUL-07 17:50:58
        10 11-JUL-07 17:50:58 11-JUL-07 17:51:03
        11 11-JUL-07 17:51:03 11-JUL-07 18:34:11

4 rows selected.

验证备库上的redo已经被应用

SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG -
> ORDER BY SEQUENCE#;

SEQUENCE# APP
--------- ---
        8 YES
        9 YES
       10 YES
       11 IN-MEMORY

4 rows selected.