1.Create global script in the catalog database
2.Print the global script
3.Run the script
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:
Post a Comment