How to Assign Backup TAG Name for
Quick Identification in RMAN
If you are taking lot of backups, it will be easier
to assign a tag to a particular backup, which we’ll later use during Oracle
recovery (or while using list command to view it).
The following example assign a backup tag called “PRD01_TBLS_BK_ONLY”
to this particular backup.
RMAN> BACKUP AS BACKUPSET TAG 'PRD01_TBLS_BK_ONLY'
TABLESPACE PRD01;
Starting backup at 12-AUG-17
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting full datafile
backupset
channel ORA_DISK_1: specifying datafile(s) in
backupset
input datafile fno=00002
name=/u03/oradata/devdb/PRD01_1.dbf
channel ORA_DISK_1: starting piece 1 at 12-AUG-17
channel ORA_DISK_1: finished piece 1 at 12-AUG-17
piece handle=/backup/rman/full_4fogpdb3_4239_1
tag=WEEEKLY_PRD01_TBLS_BK_ONLY comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:01
Finished backup at 12-AUG-17
Starting Control File and SPFILE Autobackup at
10-AUG-13
piece
handle=/backup/rman/ctl_c-758818131-20130808-01 comment=NONE
Finished Control File and SPFILE Autobackup at
12-AUG-17
Once the backup is finished, if you view the files
from rman directory, you’ll not see the tag name here. Tag name is used only
from RMAN repositories to view and restore backups. So, now you see there are
more files in this directory, as we’ve taken couple of backups.
$ ls -l /backup/rman/
total 29176
-rw-r----- 1 oracle dba 14585856 Aug 8 11:48 ctl_c-758818131-20130808-00
-rw-r----- 1 oracle dba 14585856 Aug 8 11:54 ctl_c-758818131-20130808-01
-rw-r----- 1 oracle dba 327680 Aug
8 11:48 full_4dogpd0u_4237_1
-rw-r----- 1 oracle dba 327680 Aug
8 11:54 full_4fogpdb3_4239_1
For all
RMAN Backup Command visit Below Link:
Ref.: http://www.thegeekstuff.com
Comments
Post a Comment