Oracle RMAN Backupset – Understanding and Management

backuporaclerestorerman

I feel a bit confused when I read about RMAN!

what are the differences between:

RMAN> backup as backupset

RMAN> backup database;

RMAN> backup database plus archivelog;

RMAN> backup as backupset database include current controlfile;

what is the difference between backup database and backup as backupset

also how to backup the database + needed archivelog + controlfile + spfile in one command for a full restore when needed?

is there any site explains this stuff in details with examples?

Best Answer

RMAN uses backupsets by default. The following commands will create a backup to a backupset:

RMAN> backup database;

RMAN> backup database plus archivelog;

This is assuming that you haven't changed the default RMAN parameters:

RMAN> SHOW ALL;
...
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

"Backup as backupset" is not a valid command and will return a syntax error.

"Backup as backupset database include current controlfile" might be useful if you changed the default backup type to something other than a backupset (e.g. "BACKUP TO COPY").

Source: Database Backup and Recovery Basics

Related Question