Oracle RMAN增量备份

最新推荐文章于 2024-09-27 04:04:39 发布

ThinkerFuther

最新推荐文章于 2024-09-27 04:04:39 发布

阅读量526

点赞数 3

文章标签： oracle 数据库

本文链接：https://blog.csdn.net/lc547913923/article/details/140331732

版权

1、查询哪部分的增量

sql>set line 500 pages 0
sql>select sequence#,applied,first_change#||'',next_change#||'',to_char(completion_time,'yyyy-mm-dd hh24:MI:SS') from v$archived_log where completion_time>sysdate-1;

2、rman备份(并行保存到指定路径)

run{
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
allocate channel d5 type disk;
allocate channel d6 type disk;
allocate channel d7 type disk;
allocate channel d8 type disk;
allocate channel d9 type disk;
allocate channel d10 type disk;
backup incremental from scn 10187368204 database format '/backup/inc_%T_%U.bak' include current controlfile for standby;
}

3、注册备份集（备份文件路径）
RMAN> catalog st