Whole backups of a database include the complete contents of all data files of the database, plus the control file, archived redo log files, and server parameter file. With these files, you can perform a complete recovery.
While whole database backups can be an important element in your overall backup strategy, they are also a required step in some situations, such as when you enable or disable ARCHIVELOG
mode (see "Configuring Recovery Settings"). This section explains how to make whole database backups, both offline and online, to disk. Typically, you want to perform online backups to maximize database availability.
To perform a whole database backup when the database is open:
Connect RMAN to the target database as described in "Connecting to the Target Database Using RMAN."
Ensure that your database is in ARCHIVELOG
mode as described in "Enabling Archiving of Redo Log Files."
You can make online backups only if your database is running in ARCHIVELOG
mode.
Back up the database, along with archived redo logs by using the following command:
BACKUP DATABASE PLUS ARCHIVELOG;
This backup is created on the default device that you configured for storing backups. If you did not configure a default device, then the backup is created in the fast recovery area. RMAN uses a default format while naming the backup sets that comprise the backup.
To perform a whole database backup when the database is closed:
See Also:
Oracle Database Backup and Recovery User's Guide for information about performing backups of multitenant container databases (CDBs) and pluggable databases (PDBs)