Perform noarchivelog rman backup.

How do you perform a backup in oracle with the Rman utility on a database in noarchivelog mode ?

The big question has got to be why perform a cold backup with Rman, however there is only one reason I can think of. Anyway………

Startup mount the database.

Why ? Because rman requires a consistent image of the database whilst performing the backup. Although designed to backup online, with no archive logs to perform recovery, the database contents cannot change during the backup.
Rman also requires to talk to the control file during the backup.

Backup the database without archivelogs.

run
{
backup database;
}

This will backup the database with the database currently unavailable to the users.

Why would you want a coldRman backup ?

The only gain in 10g is the compression available on backups.

run
{
backup as compressed backupset database;
}

Note that neither command can include the archive logs, because there are none.

Leave a Reply