oracle DG 修复 GAP 主库丢失归档.pdf
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
'+DATA/TLYWDGJJ/tempfile/temp03.dbf';
alter database rename file
'+DATA/TLYWDB/DATAFILE/tlzbx_data_tbs_01.289.1015178149' to
'+DATA/TLYWDGJJ/DATAFILE/tlzbx_data_tbs_01.309.1015178171';
alter database rename file
'+DATA/TLYWDB/DATAFILE/tlzbx_data_tbs_01.288.1015178171' to
'+DATA/TLYWDGJJ/DATAFILE/tlzbx_data_tbs_01.286.1015178207';
alter database rename file
'+DATA/TLYWDB/DATAFILE/tlzbx_data_tbs_01.287.1015178207' to
'+DATA/TLYWDGJJ/DATAFILE/tlzbx_data_tbs_01.296.1015178245';
alter database rename file
'+DATA/TLYWDB/DATAFILE/tlzbx_data_tbs_01.286.1015178245' to
'+DATA/TLYWDGJJ/DATAFILE/tlzbx_data_tbs_01.300.1015178281';
alter database rename file
'+DATA/TLYWDB/DATAFILE/tlzbx_data_tbs_01.285.1015178281' to
'+DATA/TLYWDGJJ/DATAFILE/tlzbx_data_tbs_01.293.1015178317';
alter database rename file
'+DATA/TLYWDB/DATAFILE/tlzbx_data_tbs_01.284.1015178317' to
'+DATA/TLYWDGJJ/DATAFILE/tlzbx_data_tbs_01.291.1015178353';
alter database rename file
of 7
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
相关文档
评论