[20160427]rman tag format标识.txt
--昨天别人问一个关于rman很奇怪的问题,就是能否实现给全备以及archive加不同的tag.
--当然最简单的方法就是分开执行,这样就没有问题.
--我们生产系统就是分开写的,例子:
backup as compressed backupset full database filesperset=1
tag="full $current"
include current controlfile
format "$BACKUP_HOME/fulls/${DB_NAME}_%d_%T_%s_full" ;
sql 'alter system archive log current ';
backup as compressed backupset archivelog all
tag="archivelog $current"
not backed up 1 times
format '$BACKUP_HOME/archives/${DB_NAME}_%d_%T_%s_archive' ;
--实际上可以写成:
RMAN> backup as compressed backupset full database tag='full 20160427' plus archivelog tag="archivelog 20160427" ;
...
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
159 B A A DISK 2016-04-27 09:33:49 1 1 YES ARCHIVELOG 20160427
160 B A A DISK 2016-04-27 09:33:49 1 1 YES ARCHIVELOG 20160427
161 B A A DISK 2016-04-27 09:33:49 1 1 YES ARCHIVELOG 20160427
162 B A A DISK 2016-04-27 09:33:49 1 1 YES ARCHIVELOG 20160427
163 B F A DISK 2016-04-27 09:33:52 1 1 YES FULL 20160427
164 B F A DISK 2016-04-27 09:33:54 1 1 YES FULL 20160427
165 B F A DISK 2016-04-27 09:33:55 1 1 YES FULL 20160427
166 B F A DISK 2016-04-27 09:34:01 1 1 YES FULL 20160427
167 B F A DISK 2016-04-27 09:34:05 1 1 YES FULL 20160427
168 B A A DISK 2016-04-27 09:34:11 1 1 YES ARCHIVELOG 20160427
--也可以分别执行format格式.
RMAN> backup as compressed backupset full database tag='full 20160427' format '/home/oracle/backup/full20160427_%U' plus archivelog tag="archivelog 20160427" format '/home/oracle/backup/arch20160427_%U';
..
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
169 B A A DISK 2016-04-27 09:36:54 1 1 YES ARCHIVELOG 20160427
170 B A A DISK 2016-04-27 09:36:55 1 1 YES ARCHIVELOG 20160427
171 B A A DISK 2016-04-27 09:36:55 1 1 YES ARCHIVELOG 20160427
172 B A A DISK 2016-04-27 09:36:55 1 1 YES ARCHIVELOG 20160427
173 B F A DISK 2016-04-27 09:36:58 1 1 YES FULL 20160427
174 B F A DISK 2016-04-27 09:37:00 1 1 YES FULL 20160427
175 B F A DISK 2016-04-27 09:37:01 1 1 YES FULL 20160427
176 B F A DISK 2016-04-27 09:37:07 1 1 YES FULL 20160427
177 B F A DISK 2016-04-27 09:37:11 1 1 YES FULL 20160427
178 B A A DISK 2016-04-27 09:37:16 1 1 YES ARCHIVELOG 20160427
179 B A A DISK 2016-04-27 09:38:38 1 1 YES ARCHIVELOG 20160427
180 B A A DISK 2016-04-27 09:38:38 1 1 YES ARCHIVELOG 20160427
181 B A A DISK 2016-04-27 09:38:38 1 1 YES ARCHIVELOG 20160427
182 B A A DISK 2016-04-27 09:38:38 1 1 YES ARCHIVELOG 20160427
183 B F A DISK 2016-04-27 09:38:41 1 1 YES FULL 20160427
184 B F A DISK 2016-04-27 09:38:43 1 1 YES FULL 20160427
185 B F A DISK 2016-04-27 09:38:44 1 1 YES FULL 20160427
186 B F A DISK 2016-04-27 09:38:50 1 1 YES FULL 20160427
187 B F A DISK 2016-04-27 09:38:55 1 1 YES FULL 20160427
188 B A A DISK 2016-04-27 09:39:00 1 1 YES ARCHIVELOG 20160427
$ ll -ltr /home/oracle/backup
total 1161728
-rw-r----- 1 oracle oinstall 14631424 2016-04-27 09:36:54 full20160427_bmr42sdm_1_1
-rw-r----- 1 oracle oinstall 205312 2016-04-27 09:36:55 full20160427_bnr42sdn_1_1
-rw-r----- 1 oracle oinstall 23883776 2016-04-27 09:36:55 full20160427_blr42sdm_1_1
-rw-r----- 1 oracle oinstall 22379520 2016-04-27 09:36:55 full20160427_bkr42sdm_1_1
-rw-r----- 1 oracle oinstall 26255360 2016-04-27 09:36:58 full20160427_bor42sdo_1_1
-rw-r----- 1 oracle oinstall 1196032 2016-04-27 09:37:00 full20160427_brr42sdr_1_1
-rw-r----- 1 oracle oinstall 98304 2016-04-27 09:37:01 full20160427_bsr42sdt_1_1
-rw-r----- 1 oracle oinstall 219553792 2016-04-27 09:37:07 full20160427_bqr42sdo_1_1
-rw-r----- 1 oracle oinstall 285958144 2016-04-27 09:37:11 full20160427_bpr42sdo_1_1
-rw-r----- 1 oracle oinstall 4096 2016-04-27 09:37:16 full20160427_btr42sec_1_1
-rw-r----- 1 oracle oinstall 208896 2016-04-27 09:38:38 arch20160427_c1r42sgu_1_1
-rw-r----- 1 oracle oinstall 14631424 2016-04-27 09:38:38 arch20160427_c0r42sgt_1_1
-rw-r----- 1 oracle oinstall 23883776 2016-04-27 09:38:38 arch20160427_bvr42sgt_1_1
-rw-r----- 1 oracle oinstall 22379520 2016-04-27 09:38:38 arch20160427_bur42sgt_1_1
-rw-r----- 1 oracle oinstall 26247168 2016-04-27 09:38:41 full20160427_c2r42sgv_1_1
-rw-r----- 1 oracle oinstall 1196032 2016-04-27 09:38:43 full20160427_c5r42sh2_1_1
-rw-r----- 1 oracle oinstall 98304 2016-04-27 09:38:44 full20160427_c6r42sh4_1_1
-rw-r----- 1 oracle oinstall 219553792 2016-04-27 09:38:50 full20160427_c4r42sgv_1_1
-rw-r----- 1 oracle oinstall 285966336 2016-04-27 09:38:55 full20160427_c3r42sgv_1_1
-rw-r----- 1 oracle oinstall 2560 2016-04-27 09:39:00 arch20160427_c7r42shk_1_1
