RMAN Whole database backup

1. Check the controlfile autobackup is set to on ; else set it to on


RMAN> show controlfile autobackup
2> ;

RMAN configuration parameters for database with db_unique_name CVRMAN are:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;

RMAN> configure controlfile autobackup on;

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

2.Take full backup of database

RMAN> backup database
2> tag="whole_database_bkp";

Starting backup at 15-MAY-14

using channel ORA_DISK_1

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=+DATA/cvrman/datafile/system.256.847354793

input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793

input datafile file number=00005 name=+DATA/cvrman/datafile/example.308.847525493

input datafile file number=00003 name=+DATA/cvrman/datafile/undotbs1.258.847354795

input datafile file number=00006 name=+DATA/cvrman/datafile/tbs1.294.847433665

input datafile file number=00004 name=+DATA/cvrman/datafile/users.259.847354795

channel ORA_DISK_1: starting piece 1 at 15-MAY-14

channel ORA_DISK_1: finished piece 1 at 15-MAY-14

piece handle=+DATA/cvrman/backupset/2014_05_15/nnndf0_whole_database_bkp_0.311.847589259 tag=WHOLE_DATABASE_BKP comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:05:16

Finished backup at 15-MAY-14

Starting Control File and SPFILE Autobackup at 15-MAY-14

piece handle=+DATA/cvrman/autobackup/2014_05_15/s_847589575.309.847589577 comment=NONE

Finished Control File and SPFILE Autobackup at 15-MAY-14

3.Archive the current redo log file

RMAN> sql "alter system archive log current";

sql statement: alter system archive log current