12-04 rman解决备库归档缺失(1)

郭鑫

716

5页

7次

2020-03-05

5墨值下载

Using RMAN Incremental Backups to Roll Forward a Physical Standby Database（官方

文档有）

使用 rman 增量备份解决备库缺失大量归档问题：

1. 备库停止日志应用

alter database recover managed standby database cancel;

2. 备库取当前 scn

select MIN(scn) Min_Scn from

(SELECT to_char(CURRENT_SCN) scn

FROM V$DATABASE

union

select to_char(min(fhscn))

from x$kcvfh

union

select to_char(min(f.fhscn))

from x$kcvfh f, v$datafile d

where f.hxfil = d.file#

and d.enabled != 'READ ONLY'

);

--10938190983557

cp 备份备库控制文件

3. 主库 rman 做基于 scn 的增量备份

RMAN> BACKUP INCREMENTAL FROM SCN 10938190983557 DATABASE FORMAT

'/tmp/ForStandby_%U' tag 'FORSTANDBY';

--开并行速度更快

run {

ALLOCATE CHANNEL ch_disk_1 DEVICE TYPE DISK MAXPIECESIZE 100G FORMAT

'/home/oracle/bku_%d_scn1_%T_%s_%U_%t.file';

ALLOCATE CHANNEL ch_disk_2 DEVICE TYPE DISK MAXPIECESIZE 100G FORMAT

'/home/oracle/bku_%d_scn1_%T_%s_%U_%t.file';

BACKUP as compressed backupset INCREMENTAL FROM SCN 10938190983557 DATABASE tag

'forstandby';

release channel ch_disk_1;

release channel ch_disk_2;

}

4.将备份片传输到备库

scp ... standby:/ ...

5.备库记录备份片信息，重启数据库到 MOUNT

RMAN> CATALOG START WITH '/data/oracle/backdir';

RMAN> SHUTDOWN IMMEDIATE

RMAN> STARTUP MOUNT

6.recover database（恢复数据库）

RMAN> RECOVER DATABASE NOREDO;

--开并行

run{

ALLOCATE CHANNEL ch_disk_1 DEVICE TYPE DISK;

ALLOCATE CHANNEL ch_disk_2 DEVICE TYPE DISK;

recover database noredo;

switch datafile all;

release channel ch_disk_1;

release channel ch_disk_2;

}

7.主库备份控制文件

RMAN> BACKUP CURRENT CONTROLFILE FOR STANDBY FORMAT

'/home/oracle/ForStandbyktss.bck';

8.将控制文件备份片传到远程，备库记录备份片信息

scp bku* oracle@10.80.16.21:/data/oracle/backdir

RMAN> CATALOG START WITH '/data/oracle/backdir';

9.重启实例到 nomount 状态

RMAN> SHUTDOWN;

RMAN> STARTUP NOMOUNT;

10.恢复控制文件

RMAN> RESTORE STANDBY CONTROLFILE FROM

'/data/oracle/backdir/ForStandbyktss.bck';

11.启动数据库到 mount 状态

RMAN> ALTER DATABASE MOUNT;

11. 重新记录文件位置到控制文件

RMAN> CATALOG START WITH '+data/ktssdg/datafile/';

select 'set newname for datafile '||file_id||' to ''/tpexp/prod/oradata'||

substr(file_name,22,100)||''';'

from dba_data_files

union all

select 'set newname for tempfile '||file_id||' to ''/tpexp/prod/oradata'||

substr(file_name,22,100)||''';'

from dba_temp_files ;

run{

allocate channel ch00 type disk;

set newname for datafile 514 to '/tpdata/oradata/tpl22/tplife_l18.dbf';

set newname for datafile 515 to '/tpdata/oradata/tpl22/tplife_l19.dbf';

set newname for datafile 516 to '/tpdata/oradata/tpl22/tplife_l20.dbf';

set newname for datafile 517 to '/tpdata/oradata/tpl2/tpapp05.dbf';

set newname for datafile 518 to '/tpdata/oradata/tpl2/tpapp06.dbf';

set newname for datafile 519 to '/tpdata/oradata/tpl22/taipinglifelob_03.dbf';

set newname for tempfile 5 to '/tpdata/oradata/tpl2/tempuser02.dbf';

set newname for tempfile 1 to '/tpdata/oradata/tpl2/tempapp03.dbf';

set newname for tempfile 8 to '/tpdata/oradata/tpl2/tempapp01.dbf';

set newname for tempfile 9 to '/tpdata/oradata/tpl2/tempapp02.dbf';

set newname for tempfile 13 to '/tpdata/oradata/tpl2/temp_sys01.dbf';

set newname for tempfile 16 to '/tpdata/oradata/tpl2/tempuser01.dbf'

switch datafile all;

release channel ch00;

}

RMAN> SWITCH DATABASE TO COPY;

12.open 数据库，恢复日志应用

RMAN> alter database open;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

alter database recover managed standby database using current logfile disconnect