Archivelog backup and deletion


Hi,

Below steps will help you to backup and delete archives

1. BACKUP ARCHIVELOG ALL delete input;

This backups up and deletes archive







2. BACKUP ARCHIVELOG UNTIL TIME 'sysdate' NOT BACKED UP 1 times;.
This will backup archives not backed-up yet



DELETE NOPROMPT ARCHIVELOG UNTIL TIME 'sysdate' BACKED UP 1 times to device type disk;

This is amazing deletes archives backup ed one time till 'sysdate'.


Comments

Post a Comment

Welcome to the Oracle DBA Blog.

Stay Hungry Stay Foolish

Popular posts from this blog

ORACLE BACKUP AND RECOVERY

WHAT IS BACKUP AND RECOVERY IN ORACLE ·         Backup Strategy -           Whole DB backup -           Partial DB backup ·         Backup Type -           Full DB backup -           Incremental DB Backup ·         Backup Mode -           Online( Inconsistent ) DB backup -           Offline ( Closed/Consistent ) DB Backup Consistent and Inconsistent Backups A consistent backup is one in which the files being backed up contain all changes up to the same system change number (SCN) . This means that the files in the backup contain all the data taken from a same point in time. Unlike an inconsistent backup, a consistent whole database backup does not require recovery after it is restored. The only way to make a consistent whole database backup is to shut down the database with the NORMAL , IMMEDIATE , or TRANSACTIONAL options and make the backup while the database is closed. The important point is that you can open the database after restoring a consistent who
Read more