oracle DG 修复 GAP 主库丢失归档.pdf

111

7页

1次

2024-03-12

5墨值下载

参考官方文档：Steps to perform for Rolling forward a standby database using

RMAN incremental backup when datafile is added to primary (文档 ID 1531031.1)

描述：主库删除归档导致备库异常，之后主库添加了数据文件。

1、记录备库最小的 scn 值

SELECT CURRENT_SCN FROM V$DATABASE;

select min(checkpoint_change#) from v$datafile_header;

取上面两个语句查询出来较小的 SCN 号

2、备份后面添加的数据文件

backup datafile 45,46 format '/db_bk/backup/datafile.%U';

3、基于备库最小 scn 进行增量备份

backup device type disk incremental from scn 3865344500 database format

'/db_bk/backup/%U_for_stb_stb.bk';

4、备份主库控制文件

backup current controlfile for standby format '/db_bk/backup/inc.ctl'

5、备库恢复控制文件

rman target /

startup nomount

restore standby controlfile from '/db_bk/backup/inc.ctl';

alter database mount

6、主备库数据文件路径不一致需要修改数据文件名

先设置 alter system set standby_file_management=manual;

alter database rename file '+DATA/TLYWDGJJ/system01.dbf' to

'+DATA/TLYWDGJJ/datafile/system01.dbf';

alter database rename file '+DATA/TLYWDGJJ/sysaux01.dbf' to

'+DATA/TLYWDGJJ/datafile/sysaux01.dbf';

alter database rename file '+DATA/TLYWDGJJ/undotbs101.dbf' to

'+DATA/TLYWDGJJ/datafile/undotbs101.dbf';

alter database rename file '+DATA/TLYWDGJJ/users01.dbf' to

'+DATA/TLYWDGJJ/datafile/users01.dbf';

alter database rename file '+DATA/TLYWDGJJ/temp01.dbf' to

'+DATA/TLYWDGJJ/tempfile/temp01.dbf';

alter database rename file '+DATA/TLYWDGJJ/temp02.dbf' to

'+DATA/TLYWDGJJ/tempfile/temp02.dbf';

alter database rename file '+DATA/TLYWDGJJ/temp03.dbf' to

of 7

5墨值下载

关注