RMAN: Backing UP Oracle Archive Redo Logs

RMAN: Backing Up Archive Redo Logs
Andrey Volkov

Andrey Volkov

System, network administration + DBA. And a little programmer!)) See Author profile.

I don’t usually back up the archive redo logs separately from the database backups. As mentioned earlier, I normally back up the database files and the archive redo log files by using the following command:

RMAN> backup incremental level=0 database plus archivelog;

However, you will occasionally find yourself in a situation in which you need to take a special, one-off backup of the archive redo logs. You can issue the following command to back up the archive redo logs files:

RMAN> backup archivelog all;

If you have a mount point that is nearly full, and you determine that you want to back up the archive redo logs (so that they exist in a backup file), but then you want to immediately delete the files (that were just backed up) from disk, you can use the following syntax to back up the archive redo logs and then have RMAN delete them from the storage media:

RMAN> backup archivelog all delete input;

Listed next are some other ways in which you can back up the archive redo log files:

RMAN> backup archivelog sequence 300;

RMAN> backup archivelog sequence between 300 and 400 thread 1;

RMAN> backup archivelog from time "sysdate-7" until time "sysdate-1";

If an archive redo log has been removed from disk manually via an OS delete command, RMAN will throw the following error when attempting to back up the nonexistent archive redo log file:

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

In this situation, first run a CROSSCHECK command to let RMAN know which files are physically available on disk:

RMAN> crosscheck archivelog all;

Вас заинтересует / Intresting for you:

RMAN: Using Online or Offline ...
RMAN: Using Online or Offline ... 819 views Андрей Волков Sat, 29 Feb 2020, 10:01:33
RMAN: Specifying the Backup Us...
RMAN: Specifying the Backup Us... 1468 views Андрей Волков Sat, 29 Feb 2020, 10:14:03
RMAN: Checking for Corruption ...
RMAN: Checking for Corruption ... 161 views Андрей Волков Thu, 30 Sep 2021, 11:57:27
RMAN: Backing UP Oracle Databa...
RMAN: Backing UP Oracle Databa... 112 views Андрей Волков Wed, 29 Sep 2021, 18:27:51
Log in to comment