Showing posts with label backup of backupset. Show all posts
Showing posts with label backup of backupset. Show all posts

Wednesday, May 14, 2014

Backing Up the Backupset



1. Script to backup  the backupset

cat rman_9.cmd
run
 {
  allocate channel c1 device type disk format '+DATA';
  backup
 as backupset
 channel c1
 tag="bkpset_backup"
 backupset completed before "to_date('15-MAY-2014 01:32:47','dd-Mon-yyyy hh24:mi:ss')";
 release channel c1;
 }

2.Calling the script in the rman command line
$ rman target="/" @rman_9.cmd | tee -a rman_9.log

Recovery Manager: Release 11.2.0.4.0 - Production on Thu May 15 02:40:05 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CVRMAN (DBID=657566608)

RMAN>  run
2>  {
3>   allocate channel c1 device type disk format '+DATA';
4>   allocate channel c2 device type disk format '/SHARED/backup1/%U';
5>   backup
6>  as backupset
7>  channel c1
8>  tag="bkpset_backup"
9>  backupset completed before "to_date('15-MAY-2014 01:32:47','dd-Mon-yyyy hh24:mi:ss')";
10>  release channel c1;
11>  }
12>
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=30 device type=DISK

allocated channel: c2
channel c2: SID=1 device type=DISK

Starting backup at 15-MAY-2014 02:40:16
channel c1: input backup set: count=117, stamp=847589258, piece=1
channel c1: starting piece 1 at 15-MAY-2014 02:40:17
channel c1: backup piece +DATA/cvrman/backupset/2014_05_15/nnndf0_whole_database_bkp_0.311.847589259
piece handle=+DATA/cvrman/backupset/2014_05_15/nnndf0_bkpset_backup_0.314.847593617 comment=NONE
channel c1: finished piece 1 at 15-MAY-2014 02:40:42
channel c1: backup piece complete, elapsed time: 00:00:25
Finished backup at 15-MAY-2014 02:40:42

Starting Control File and SPFILE Autobackup at 15-MAY-2014 02:40:42
piece handle=+DATA/cvrman/autobackup/2014_05_15/s_847593643.313.847593643 comment=NONE
Finished Control File and SPFILE Autobackup at 15-MAY-2014 02:40:46

released channel: c1
released channel: c2

Recovery Manager complete.