[20160427]rman tag format标识.txt

[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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-2089074/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267265/viewspace-2089074/