Wednesday, May 28, 2014

Create global rman script

1.Create global script in the catalog database
rman target / catalog="rcat_owner/rcat_owner@cvrcat"

Recovery Manager: Release 11.2.0.4.0 - Production on Wed May 28 03:56:51 2014

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

connected to target database: CVRMAN (DBID=657566608)
connected to recovery catalog database

RMAN> create global script g_bkp_database
2> {
3> backup database
4> tag="bkp_database";
5> }

created global script g_bkp_database

2.Print the global script
RMAN> print global script g_bkp_database;

printing stored global script: g_bkp_database
{
backup database
tag="bkp_database";
}

3.Run the script
RMAN> run
2> {
3> execute script g_bkp_database;
4> }

executing global script: g_bkp_database

Starting backup at 28-MAY-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=28 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=59 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=53 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=27 device type=DISK
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 28-MAY-14
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
input datafile file number=00004 name=+DATA/cvrman/datafile/users.259.847354795
channel ORA_DISK_2: starting piece 1 at 28-MAY-14
channel ORA_DISK_3: starting full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/cvrman/datafile/example_new.dbf
input datafile file number=00006 name=+DATA/cvrman/datafile/tbs1_new.dbf
channel ORA_DISK_3: starting piece 1 at 28-MAY-14
channel ORA_DISK_4: starting full datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/cvrman/datafile/undotbs1.318.848201233
input datafile file number=00007 name=+DATA/cvrman/datafile/tbs2.328.848469625
channel ORA_DISK_4: starting piece 1 at 28-MAY-14
channel ORA_DISK_4: finished piece 1 at 28-MAY-14
piece handle=+DATA/cvrman/backupset/2014_05_28/nnndf0_bkp_database_0.344.848723355 tag=BKP_DATABASE comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:00:26
channel ORA_DISK_3: finished piece 1 at 28-MAY-14
piece handle=+DATA/cvrman/backupset/2014_05_28/nnndf0_bkp_database_0.370.848723351 tag=BKP_DATABASE comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:01:17
channel ORA_DISK_1: finished piece 1 at 28-MAY-14
piece handle=+DATA/cvrman/backupset/2014_05_28/nnndf0_bkp_database_0.372.848723351 tag=BKP_DATABASE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:28
channel ORA_DISK_2: finished piece 1 at 28-MAY-14
piece handle=+DATA/cvrman/backupset/2014_05_28/nnndf0_bkp_database_0.371.848723351 tag=BKP_DATABASE comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:01:48
Finished backup at 28-MAY-14

Starting Control File and SPFILE Autobackup at 28-MAY-14
piece handle=+DATA/cvrman/autobackup/2014_05_28/s_848723459.308.848723461 comment=NONE
Finished Control File and SPFILE Autobackup at 28-MAY-14

No comments: