Limitations

For cold backups, the database must be down for the time it takes to back up the entire database. For sites that have an availability requirement, this may not be viable. Unless you are in archivelog mode, the entire database must be backed up at the same time and restored as a whole. Oracle refers to this operation as a full backup .

Tip

In our discussion, the assumption is generally that you want to recover the entire database. However, it is possible to recover a subset of the tablespaces. A procedure for doing this is provided in the following sections.

Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.