Configuring and Backing Up Oracle Databases Using RMAN - OCP: Oracle Database 12c Administrator Certified Professional - page 146

Online backups with RMAN are easy. You need to make sure the database and the
archived redo logs are backed up; thus you issue the command BACKUP DATABASE PLUS
ARCHIVELOG . That's it. That command will create a fully recoverable backup of the data-
base, as long as the physical backup set pieces are available to restore from.
Additionally, if you have used the RMAN command CONFIGURE CONTROLFILE AUTOBACKUP
ON to configure the automatic backup of control files and SPFILEs, then the database backup
is known as a whole database backup .
If you want to delete the archived redo logs after the backup, you append the DELETE INPUT
clause to the command. Other options are available depending on your needs.
In the following example, we perform an online backup of our database using the BACKUP
AS COMPRESSED BACKUP SET DATABASE PLUS ARCHIVELOG DELETE INPUT command. This
will create a compressed backup of the database, backing up the archived redo logs and then
deleting those backed-up archived redo logs after the backup is complete. Also note that we
have configured control-file autobackups.
RMAN> backup as compressed Backup Set database plus archivelog delete input;
Starting backup at 05-SEP-13
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=131 device type=DISK
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=41 RECID=40 STAMP=664583178
input archived log thread=1 sequence=42 RECID=41 STAMP=664621168
input archived log thread=1 sequence=43 RECID=42 STAMP=664650496
input archived log thread=1 sequence=44 RECID=43 STAMP=664655636
channel ORA_DISK_1: starting piece 1 at 05-SEP-13
channel ORA_DISK_1: finished piece 1 at 05-SEP-13
piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUP SET\2013_09_05\
O1_MF_ANNNN_TAG20080905T183357_4D3N085C_.BKP tag=TAG20080905T183357
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: deleting archived log(s)
archived log file name=C:\ORACLE\ARCH\ORCL\ARC00041_0662757171.001
RECID=40 STAMP=664583178
archived log file name=C:\ORACLE\ARCH\ORCL\ARC00042_0662757171.001
RECID=41 STAMP=664621168
archived log file name=C:\ORACLE\ARCH\ORCL\ARC00043_0662757171.001
RECID=42 STAMP=664650496
archived log file name=C:\ORACLE\ARCH\ORCL\ARC00044_0662757171.001
RECID=43 STAMP=664655636
Finished backup at 05-SEP-13