Thursday, May 15, 2014

Backing up only those files that needs backup using RMAN



1. Check which files need backup

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- ---------------------------------------------------
2    0     +DATA/cvrman/datafile/sysaux.257.847354793
6    0     +DATA/cvrman/datafile/tbs1.294.847433665

2. Backup the database that are not backed up using not backed up clause

RMAN> backup database not backed up;

Starting backup at 15-MAY-2014 07:17:22
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
skipping datafile 3; already backed up on 15-MAY-2014 06:30:14
skipping datafile 5; already backed up on 15-MAY-2014 06:30:14
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
channel ORA_DISK_1: starting piece 1 at 15-MAY-2014 07:17:25
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
channel ORA_DISK_2: starting piece 1 at 15-MAY-2014 07:17:26
channel ORA_DISK_3: starting full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00006 name=+DATA/cvrman/datafile/tbs1.294.847433665
channel ORA_DISK_3: starting piece 1 at 15-MAY-2014 07:17:26
channel ORA_DISK_4: starting full datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/cvrman/datafile/users.259.847354795
channel ORA_DISK_4: starting piece 1 at 15-MAY-2014 07:17:27
piece handle=+DATA/cvrman/backupset/2014_05_15/nnndf0_tag20140515t071723_0.316.847610273 tag=TAG20140515T071723 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:00:41
channel ORA_DISK_3: finished piece 1 at 15-MAY-2014 07:18:19
piece handle=+DATA/cvrman/backupset/2014_05_15/nnndf0_tag20140515t071723_0.296.847610269 tag=TAG20140515T071723 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:53
channel ORA_DISK_1: finished piece 1 at 15-MAY-2014 07:18:40
piece handle=+DATA/cvrman/backupset/2014_05_15/nnndf0_tag20140515t071723_0.288.847610251 tag=TAG20140515T071723 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
channel ORA_DISK_2: finished piece 1 at 15-MAY-2014 07:18:40
piece handle=+DATA/cvrman/backupset/2014_05_15/nnndf0_tag20140515t071723_0.315.847610269 tag=TAG20140515T071723 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:01:14
Finished backup at 15-MAY-2014 07:18:40

Starting Control File and SPFILE Autobackup at 15-MAY-2014 07:18:40
piece handle=+DATA/cvrman/autobackup/2014_05_15/s_847610320.272.847610323 comment=NONE
Finished Control File and SPFILE Autobackup at 15-MAY-2014 07:18:43

No comments: