• Arun Kumar

RMAN Archivelog Backups

In this article we will understand how to take archivelog backups using RMAN.

Taking Archivelog Backup

RMAN> list archivelog all; --> Archivelog known to controlfile
RMAN> backup archivelog all; --> Backup all the archivelog
RMAN> backup archivelog all not backed up 1 times;
RMAN> backup archivelog all delete input; --> Backup and delete from disk
RMAN> list archivelog all backed up 1 times to DISK; --> list backed up archives

Deleting Archivelog Backup

RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
RMAN> delete archivelog all backed up 1 times to DISK;
RMAN> crosscheck archivelog sequence 24;
RMAN> crosscheck backup of archivelog sequence 24;


Recent Posts

See All

MySQL Installation on Linux

This article demonstrates MySQL installation on Oracle Enterprise Linux 6.5 version. Installation of MySQL Make sure you are able to connect internet via virtual machine. Try to ping google.com and pr

Add ISO image storage repository on XenServer

If you have used VMware ESXI, its very easy to upload ISO files to the data store and create VMs. With XenServer, you must create your own ISO repository to upload ISO files. Create ISO directory Acce

Automate RMAN Backup using Shell Script

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au