oracle数据库全备份和增量备份

文件与所有归档的重做日志，并删除旧的归档日志

)

备份表空间：

RMAN> backup tablespace system plus archivelog delete input;

(

备份指 定表空间及归档的

重做日志，并删除旧的归档日志

)_

备份归档日志：

RMAN> backup archivelog all delete input;

1.

全库备份

（备份数据文件中有数据的，

有数据文件，

控制文件，

归档日志文件，

spfile

文件，不备份联 机重做日志文件或临时文件）

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; --

控制文件自动备份

RMAN>

CONFIGURE DEVICE TYPE DISK PARALLELISM 2 backup type to compressed

backupset; --

压缩

RMAN> CONFIGURE channel DEVICE TYPE DISK format 'D:APPrmanfull_%'; --

备份的路径

RMAN>BACKUP DATABASE; --

全备份

RMAN>list backup of database; --

检查备份信息

RMAN>backup archivelog all delete input; --

备份归档日志并删除归档日志

RMAN> list backup of archivelog all; --

检查归档日志

2.

差异增量备份

RMAN> backup incremental level 0 database; --0

级全备份

RMAN> backup incremental level 2 database;--2

级备份

RMAN> list backup of database;

--

检查备份信息

3.

累积增量备份

（

2c

不做参照对象）

RMAN> backup incremental level 2 cumulative database;

中心数 据库

,RMAN

一周备份方案

==== ========================

0.

星期天晚上

-level 0 backup performed(

全备份

)

1.

星期一晚上

-level 2 backup performed

2.

星期二晚上

-level 2 backup performed

3.

星期三晚上

-level 1 backup performed

4.

星期四晚上

-level 2 backup performed

5.

星期五晚上

-level 2 backup performed

6.

星期六晚上

-level 2 backup performed

如果星期二需要恢复的话，只需要

0+1,

如果星期四需要恢复的话，只需要

0+3,

如果星期五需要恢复的话，只需要

0+3+4,

如果星期六需要恢复的话，只需要

0+3+4+5

具体步骤：

1.

创建

0 ,1,2

级备份脚本

D:rman_bak_script

run{

allocate channel c1 type disk;

allocate channel c2 type disk;

allocate channel c3 type disk;

backup

as

compressed

backupset

incremental

level

0

tag

'db_level0'

database

format 'H:RMAN_BAKlevel0_%u_%s_%';

sql 'alter system archive log current';

backup as compressed backupset archivelog all format

'H:ARCHIVELOG_BAKarch0_%u_%s_%p' delete input;

delete noprompt obsolete;

release channel c1;

release channel c2;

release channel c3;

}

run{

allocate channel c1 type disk;

allocate channel c2 type disk;

allocate channel c3 type disk;

backup

as

compressed

backupset

incremental

level

1

tag

'db_level1'

database

format 'H:RMAN_BAKlevel1_%u_%s_%';

sql 'alter system archive log current';

backup

as

compressed

backupset

archivelog

all

format

'H:ARCHIVELOG_BAKarch1_%u_%s_%p' delete input;