Showing posts with label Create Global Script. Show all posts
Showing posts with label Create Global Script. Show all posts

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