Friday 10 January 2014

How to execute multiple commands at a time in rman?

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
How to execute multiple commands at a time in rman?
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
NOTE * : -Use "run" block to execute multiple commands

EXAMPLE * ;_
run
{
backup current controlfile;
backup datafile 1;
}



[oracle@wasiq ~]$ rman

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jan 1 12:11:13 2014

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

RMAN> connect target /;

connected to target database: ORCL (DBID=1362912542)

RMAN> run
{
backup current controlfile;
backup datafile 1;
}2> 3> 4> 5>

Starting backup at 01-JAN-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=63 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=5 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=70 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=135 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 01-JAN-14
channel ORA_DISK_1: finished piece 1 at 01-JAN-14
piece handle=/d02/oracle/flash_recovery_area/ORCL/backupset/2014_01_01/o1_mf_ncnnf_TAG20140101T121121_9d7g4lvb_.bkp tag=TAG20140101T121121 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 01-JAN-14

Starting backup at 01-JAN-14
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/d02/oracle/oradata/orcl/system01.dbf
channel ORA_DISK_1: starting piece 1 at 01-JAN-14
channel ORA_DISK_2: starting compressed full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
channel ORA_DISK_3: starting compressed full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_3: starting piece 1 at 01-JAN-14
including current control file in backup set
channel ORA_DISK_2: starting piece 1 at 01-JAN-14
channel ORA_DISK_3: finished piece 1 at 01-JAN-14
piece handle=/d02/oracle/flash_recovery_area/ORCL/backupset/2014_01_01/o1_mf_nnsnf_TAG20140101T121123_9d7g4n8p_.bkp tag=TAG20140101T121123 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_2: finished piece 1 at 01-JAN-14
piece handle=/d02/oracle/flash_recovery_area/ORCL/backupset/2014_01_01/o1_mf_ncnnf_TAG20140101T121123_9d7g4o5l_.bkp tag=TAG20140101T121123 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: finished piece 1 at 01-JAN-14
piece handle=/d02/oracle/flash_recovery_area/ORCL/backupset/2014_01_01/o1_mf_nnndf_TAG20140101T121123_9d7g4n8d_.bkp tag=TAG20140101T121123 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:36
Finished backup at 01-JAN-14

RMAN>

No comments:

Post a Comment