adg主库数据文件损坏恢复.docx

michaelliu

473

3页

0次

2023-04-20

10墨值下载

adg

主库数据文件损坏恢复

前言：主库数据文件损坏又没有做备份无法恢复，主库

open

不了，此时用备库的文件进行恢复。

把备库转换成主库，若无法转换可以进行备库强制启动，即

snapshot standby database

对备库进行数据备份：

RMAN>run {

allocate channel c1 device type disk;

allocate channel c2 device type disk;

allocate channel c3 device type disk;

backup datale 1,2,3,4,5,6,7 format '/home/oracle/orabak/ForStandby_%U' tag

'FORSTANDBY';----tag 'FORSTANDBY'

此只是个标记可以去掉

backup archivelog all format '/home/oracle/orabak/arch_%d_%T_%U';

backup current controlle format '/home/oracle/orabak/ctl_%d_%T_%U';

release channel c1;

release channel c2;

release channel c3;

}

把备份文件传到主库

Scp /home/oracle/orabak/* 192.168.3.111:/home/oracle/orabak

原主库控制文件数据文件路径更改：

控制文件还原

restore controlle from '/home/oracle/orabak/ctl_ORCLDBA_20230420_851q2irc_1_1';

RMAN> catalog start with '/home/oracle/orabak'; ---

注册备份集路径

RMAN>report schema

；

select * from v$logle;

此处显示的控制文件中数据文件的路径不是实际的

asm

路径，需更改

run

{

set newname for datale 1 to '+DATA/ORCLDBA/system01.dbf';

set newname for datale 2 to '+DATA/ORCLDBA/sysaux01.dbf';

set newname for datale 3 to '+DATA/ORCLDBA/undotbs01.dbf';

set newname for datale 4 to '+DATA/ORCLDBA/undotbs02.dbf';

set newname for datale 5 to '+DATA/ORCLDBA/users01.dbf';

set newname for datale 6 to '+DATA/ORCLDBA/tbs_test_1.dbf';

set newname for datale 7 to '+DATA/ORCLDBA/tbs_test_2.dbf';

switch datale all;

}

restore datale 1,2,3,4,5,6,7; ---

数据文件还原

redo log

路径更改为实际路径

alter database rename le '/u01/app/oracle/oradata/orcl_dgredo01.log' to '+DATA/ORCLDBA/orcl_dgredo01.log';

alter database rename le '/u01/app/oracle/oradata/orcl_dgredo02.log' to '+DATA/ORCLDBA/orcl_dgredo02.log';

alter database rename le '/u01/app/oracle/oradata/orcl_dgredo03.log' to '+DATA/ORCLDBA/orcl_dgredo03.log';

alter database rename le '/u01/app/oracle/oradata/orcl_dgredo04.log' to '+DATA/ORCLDBA/orcl_dgredo04.log';

alter database rename le '/u01/app/oracle/oradata/orcl_dgstandby_redo11.log' to

'+DATA/ORCLDBA/orcl_dgstandby_redo11.log';

alter database rename le '/u01/app/oracle/oradata/orcl_dgstandby_redo12.log' to

'+DATA/ORCLDBA/orcl_dgstandby_redo12.log';

alter database rename le '/u01/app/oracle/oradata/orcl_dgstandby_redo13.log' to

'+DATA/ORCLDBA/orcl_dgstandby_redo13.log';

清除

redo

组：

RMAN> ALTER DATABASE CLEAR LOGFILE GROUP 1;

RMAN> ALTER DATABASE CLEAR LOGFILE GROUP 2;

of 3

10墨值下载

oracle adg

关注

评论