oracle rman备份命令-备份恢复

核心提示： list backup--列出过期备份report obsolete;--删除过期的备份allocate channel for maintenance type disk;--allocate channel for delete type disk;change datafilecop

list backup

--列出过期备份

report obsolete;

--删除过期的备份

allocate channel for maintenance type disk;

--allocate channel for delete type disk;

change datafilecopy 44 delete;

release channel;

--如果目标数据库物理对象发生了变化，如添加了一个数据文件，需要用如下命令同步

resync catalog;

--如果目标数据库reset了数据库，需要用如下命令同步

reset database;

--当手工删除了数据库的归档文件后，要执行以下脚本同步

allocate channel for maintenance type disk;

--allocate channel for delete type disk;

change archivelog all crosscheck;

release channel;

--当手工删除了数据库的RMAN备份后，要执行以下脚本来同步

allocate channel for maintenance type disk;
crosscheck backup;
delete expire backup;
release channel;

/////////////////增量备份//////////////

Level 0 是增量备份策略的基础

run {
allocate channel c1 type disk;
backup incremental level 0 filesperset 4 format '/export/home/oracle/oradata/bak_db/sunday_level0_%t'
(database);
release channel c1;
}

==================Recovery 恢复==================

0.恢复控制文件(以前必须有过控制文件的备份)

startup nomount

rman target/

connect catalog rman/rman

(数据库在nomount的时候才能set DBID)

set DBID=3287725908　

1.Datafile recovery 数据文件恢复