rman全备恢复实践.txt - 墨天轮文档

rman全备恢复实践.txt

Peng

2页

7次

2024-10-16

免费下载

oracle rman 全备恢复实践.

rman 恢复实践

设定参数:

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO

'/arch/rman/controlfile%F.ctnl';

CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/arch/rman/full%t.bak';

数据库 rman 全备

rman>backup database plus archivelog delete input;

备份产生的三个文件

-rw-r----- 1 oracle oinstall 7143424 Jan 28 18:05 controlfilec-2719028776-

20100128-01.ctnl

-rw-r----- 1 oracle oinstall 41074688 Jan 28 18:03 full709495428.bak

-rw-r----- 1 oracle oinstall 763379712 Jan 28 18:05 full709495432.bak

-rw-r----- 1 oracle oinstall 17920 Jan 28 18:05 full709495518.bak

rman 恢复

------------------

1、启动数据库到 nomount 状态

$sqlplus / as sysdba

SQL> startup nomount

2、spfile 恢复

$rman nocatalog

rman> connect target /

run {

allocate channel c1 DEVICE TYPE DISK format '/arch/rman/controlfile%F.ctnl';

restore spfile to pfile '/arch/pfile.ora' from '/arch/rman/controlfilec-

2719028776-20100128-01.ctnl';

release channel c1;

}

3、控制文件恢复

run {

allocate channel c1 DEVICE TYPE DISK format '/arch/rman/controlfile%F.ctnl';

restore controlfile from '/arch/rman/controlfilec-2719028776-20100128-01.ctnl';

release channel c1;

}

4、全库恢复

在恢复控制文件的情况下，可以修改数据到 mount 状态，进行全库的恢复

rman> alter database mount;

run {

allocate channel c1 device type disk format '/arch/rman/full%t.bak';

restore database;

release channel c1;

}

5、恢复 archivelog

run {

allocate channel c1 device type disk format '/arch/rman/full%t.bak';

restore archivelog all;

}

run {

allocate channel c1 device type disk format '/arch/rman/full%t.bak';

restore archivelog from logseq=72 until logseq=73;

}

6、redolog 恢复

SQL>recover database using backup controlfile until cancel;

SQL>alter database open resetlogs; //现在有 redolog 产生了，还有 temp 表空间文件也生成

了或者分开两步执行

SQL>select * from dual;

全库成功恢复

of 2

免费下载

oracle11g

关注

评论