SIMPLE RMAN BACKUP SCRIPT

run {
   shutdown immediate;
   startup mount;
   allocate channel ch1 type disk FORMAT '/rmanbkp/%d_TP_%I_%T_%s_%p' MAXPIECESIZE 500M;
   BACKUP DATABASE ;
sql "create pfile=''/rmanbkp/init.ora'' from spfile";
   release channel ch1;
     }


===========================


[oracle@rac1 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production

connected to target database: TESTDB (DBID=2579635974)

RMAN> run {
   son Wed Oct 10 15:04:42 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.hutdown immediate;
   startup mount;
   allocate channel ch1 type disk FORMAT '/rmanbkp/%d_TP_%I_%T_%s_%p' MAXPIECESIZE 500M;
   BACKUP DATABASE ;
sql "create pfile=''/rmanbkp/init.ora'' from spfile";
   release channel ch1;
     }
2> 3> 4> 5> 6> 7> 8>
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area    1023004672 bytes

Fixed Size                     2219752 bytes
Variable Size                591397144 bytes
Database Buffers             423624704 bytes
Redo Buffers                   5763072 bytes

allocated channel: ch1
channel ch1: SID=24 device type=DISK

Starting backup at 10-OCT-12
channel ch1: starting full datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/testdb/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/testdb/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/testdb/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/testdb/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/testdb/users01.dbf
channel ch1: starting piece 1 at 10-OCT-12
channel ch1: finished piece 1 at 10-OCT-12
piece handle=/rmanbkp/TESTDB_TP_2579635974_20121010_20_1 tag=TAG20121010T150521 comment=NONE
channel ch1: starting piece 2 at 10-OCT-12
channel ch1: finished piece 2 at 10-OCT-12
piece handle=/rmanbkp/TESTDB_TP_2579635974_20121010_20_2 tag=TAG20121010T150521 comment=NONE
channel ch1: starting piece 3 at 10-OCT-12
channel ch1: finished piece 3 at 10-OCT-12
piece handle=/rmanbkp/TESTDB_TP_2579635974_20121010_20_3 tag=TAG20121010T150521 comment=NONE
channel ch1: backup set complete, elapsed time: 00:02:19
channel ch1: starting full datafile backup set
channel ch1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ch1: starting piece 1 at 10-OCT-12
channel ch1: finished piece 1 at 10-OCT-12
piece handle=/rmanbkp/TESTDB_TP_2579635974_20121010_21_1 tag=TAG20121010T150521 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-OCT-12

sql statement: create pfile=''/rmanbkp/init.ora'' from spfile

released channel: ch1

RMAN>