RMAN：全备 & 增备
看代码吧：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
[oracle@oracleyou orabackup]$ pwd /orabackup [oracle@oracleyou orabackup]$ [oracle@oracleyou orabackup]$ ls -ltr total 36 -rw-r--r-- 1 oracle oinstall 424 May 30 14:33 inc.sh -rw-r--r-- 1 oracle oinstall 423 May 30 14:33 full.sh -rw-r--r-- 1 oracle oinstall 10799 May 30 14:41 full.log drwxr-xr-x 2 oracle oinstall 4096 May 30 14:52 data -rw-r--r-- 1 oracle oinstall 8613 May 30 14:54 inc.log [oracle@oracleyou orabackup]$ [oracle@oracleyou orabackup]$ cat full.sh rman target / << EOF run{ allocate channel c1 device type disk; allocate channel c2 device type disk; backup incremental level 0 tag 'db0' format '/orabackup/data/db_level0_%d_%T_%s' database include current controlfile; sql 'alter system archive log current'; backup filesperset 5 format '/orabackup/data/arc_level0_%d_%T_%s' archivelog all; #delete noprompt obsolete; release channel c1; release channel c2; } exit EOF [oracle@oracleyou orabackup]$ [oracle@oracleyou orabackup]$ cat inc.sh rman target / << EOF run{ allocate channel c1 device type disk; allocate channel c2 device type disk; backup incremental level 1 tag 'db0' format '/orabackup/data/db_level1_%d_%T_%s' database include current controlfile; sql 'alter system archive log current'; backup filesperset 20 format '/orabackup/data/arc_level1_%d_%T_%s' archivelog all; #delete noprompt obsolete; release channel c1; release channel c2; } exit EOF [oracle@oracleyou orabackup]$ |
调用的时候这么做：
|
1 2 |
[oracle@oracleyou orabackup]$ sh full.sh > full.log [oracle@oracleyou orabackup]$ sh inc.sh > inc.log |
操作完成后，看看备份出来的数据：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
[oracle@oracleyou orabackup]$ ls -ltr /orabackup/data/ total 18430296 -rw-r----- 1 oracle oinstall 1014128640 May 30 14:35 db_level0_ORCL_20180530_59 -rw-r----- 1 oracle oinstall 1251164160 May 30 14:35 db_level0_ORCL_20180530_58 -rw-r----- 1 oracle oinstall 357171200 May 30 14:36 db_level0_ORCL_20180530_60 -rw-r----- 1 oracle oinstall 235225088 May 30 14:36 db_level0_ORCL_20180530_61 -rw-r----- 1 oracle oinstall 247734272 May 30 14:36 db_level0_ORCL_20180530_62 -rw-r----- 1 oracle oinstall 290045952 May 30 14:36 db_level0_ORCL_20180530_63 -rw-r----- 1 oracle oinstall 18825216 May 30 14:36 db_level0_ORCL_20180530_64 -rw-r----- 1 oracle oinstall 906182144 May 30 14:37 arc_level0_ORCL_20180530_66 -rw-r----- 1 oracle oinstall 900440064 May 30 14:37 arc_level0_ORCL_20180530_67 -rw-r----- 1 oracle oinstall 896037888 May 30 14:38 arc_level0_ORCL_20180530_68 -rw-r----- 1 oracle oinstall 890945536 May 30 14:38 arc_level0_ORCL_20180530_69 -rw-r----- 1 oracle oinstall 888024064 May 30 14:39 arc_level0_ORCL_20180530_70 -rw-r----- 1 oracle oinstall 884795392 May 30 14:39 arc_level0_ORCL_20180530_71 -rw-r----- 1 oracle oinstall 884208640 May 30 14:40 arc_level0_ORCL_20180530_72 -rw-r----- 1 oracle oinstall 884126208 May 30 14:40 arc_level0_ORCL_20180530_73 -rw-r----- 1 oracle oinstall 455808512 May 30 14:40 arc_level0_ORCL_20180530_74 -rw-r----- 1 oracle oinstall 91594752 May 30 14:49 db_level1_ORCL_20180530_76 -rw-r----- 1 oracle oinstall 18825216 May 30 14:49 db_level1_ORCL_20180530_82 -rw-r----- 1 oracle oinstall 179322880 May 30 14:49 db_level1_ORCL_20180530_77 -rw-r----- 1 oracle oinstall 2680711680 May 30 14:52 arc_level1_ORCL_20180530_84 -rw-r----- 1 oracle oinstall 2658379776 May 30 14:52 arc_level1_ORCL_20180530_85 -rw-r----- 1 oracle oinstall 2238903808 May 30 14:53 arc_level1_ORCL_20180530_86 [oracle@oracleyou orabackup]$ [oracle@oracleyou orabackup]$ du -sh /orabackup/data/ 18G /orabackup/data/ [oracle@oracleyou orabackup]$ |
执行时[……]
- 发表于：
-
作者：
Adamhuan
- 分类： Recovery Manager（RMAN）
- 标签： backup, Oracle, Rman, 全备, 增备, 数据库
- 发表评论: RMAN：全备 & 增备