release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
2. 增量备份脚本
每周的其它时间进行 level1 的增量备份,脚本如下:
[oracle@ptdb1 scripts]$ cat backup_level1.sh
rman target / <
备份计划,每周的周日和周一 23:00 备份全库 level0,每周的其它时间备份 level1 增量:
六、 数据库备份
1. 全量备份
每天的 23:00 执行备份脚本,level0 备份日志如下:
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Mar 6 11:33:56 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1524318178)
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=3791 instance=orcl1 device type=DISK
allocated channel: c2
channel c2: SID=4356 instance=orcl1 device type=DISK
allocated channel: c3
channel c3: SID=4736 instance=orcl1 device type=DISK
allocated channel: c4
channel c4: SID=4922 instance=orcl1 device type=DISK
Starting backup at 06-MAR-2019 11:34:01
channel c1: starting compressed incremental level 0 datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00017 name=+DATA/orcl/datafile/ek_tool.281.996540333
input datafile file number=00021 name=+DATA/orcl/datafile/cdr.285.996540349
input datafile file number=00004 name=+DATA/orcl/datafile/undotbs2.264.996537471
input datafile file number=00005 name=+DATA/orcl/datafile/users.265.996537473
input datafile file number=00009 name=+DATA/orcl/datafile/mq.273.996539359
channel c1: starting piece 1 at 06-MAR-2019 11:34:03
channel c2: starting compressed incremental level 0 datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00006 name=+DATA/orcl/datafile/ek_tool.270.996539355
input datafile file number=00020 name=+DATA/orcl/datafile/cdr.284.996540347
input datafile file number=00001 name=+DATA/orcl/datafile/system.260.996537457
input datafile file number=00015 name=+DATA/orcl/datafile/mq.279.996540321
input datafile file number=00011 name=+DATA/orcl/datafile/cdr.275.996539361
channel c2: starting piece 1 at 06-MAR-2019 11:34:03
channel c3: starting compressed incremental level 0 datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00018 name=+DATA/orcl/datafile/ek_tool.282.996540333
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.262.996537465
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.261.996537461