Current Position:Home > Why Backup database then backup archivelog from time...

Why Backup database then backup archivelog from time...

Update:11-30Source: network consolidation
Advertisement
Dear Experts,
I found in one of our rman scripts the 2 following statements:
backup database;
backup archivelog from time 'SYSDATE -8';
It seems to me that a "backup database plus archivelog;" is more simple/accurate instead of these 2 lines as the retention windows is defined (5 days) for this DB so rman will manage the retention of datafiles and archived log, isn't it ?
Why this separate statement for the archivelog ? I find it redondant but is it...
Any advice is as usual greatly appreciated.
Best Regards,
Guillaume

The Best Answer

Advertisement
You are right. The use of backup database plus archivelog; is much better and you are sure that you backup all archived log you need.
Probably that is an old script, previous version or the responsable of this script didn't know RMAN so good and the option you posted.
Bye, Aron
  • Why Backup database then backup archivelog from time... Update:11-30

    Dear Experts, I found in one of our rman scripts the 2 following statements: backup database; backup archivelog from time 'SYSDATE -8'; It seems to me that a "backup database plus archivelog;" is more simple/accurate instead of these 2 lines as

  • How can I backup archivelog generated in the last 5 minutes ? Update:10-11

    Version: 11.2.0.3 Platform : RHEL 6.2 How can I backup archivelog generated in the last 5 minutes ? Following is what I've attempted so far ? RMAN> backup archivelog all format '/rman_backups/Nov21Bkp/archiveTest_%U' UNTIL TIME 'sysdate-5/1440'; RMAN

  • Should we backup Archivelogs for ad-hoc Cold backups ? Update:11-30

    B version: 11.2 OS version : Solaris 5.10 Below is the script we use for ad-hoc cold backups. Is there a need to take the backup of archivelogs when we do the cold backup ? Sometimes archivelog backup piece's size is bigger than the backup piece cont

  • Backup archivelog Update:11-30

    Hi, When I execute below command first time on database: RMAN> backup database plus archivelog; It starts taking backup of old archivelogs generated in last 5 days. I have stopped that command execution. I have restarted database today& again fired

  • RMAN backup archivelog all delete input Update:11-30

    Hello DBAs, what does this command will do? RMAN> backup archivelog all delete input; DNI have set cron job for RMAN> backup archivelog all delete input; and its work. But I got following message in my log file. Please give ur feed back. Recovery Ma

  • Backup archivelogs from different location Update:11-30

    DB : 10.2.0.4 OS : HEHL5 due to space issue i moved the archived to different location from log_archive_dest_1. is it possible to backup the archivelogs from different location as i moved them? Thanks.My bad , it's not a must! Please see, bash-3.2$ l

  • Backup archivelog all and backup archivelog in rman back Update:11-30

    Hi, Whats the difference between backup archivelog all and backup archivelog in rman backup.Please find below explanation from the online documentation; +"+ +If you specify BACKUP ARCHIVELOG ALL, then RMAN backs up exactly one copy of each distinct l

  • Backup archivelog all Update:11-30

    Hi, Whats the difference between backup archivelog all and backup archivelog using rman.I think i have answered such question before, strange :) Anyway please find below link to read something about the backup command; http://download.oracle.com/docs

  • Backup archivelog all delete all input Update:11-30

    RMAN> backup archivelog all delete all input; i have backed up all my archivelogs using the above command, but after the backup archivelogs are not deleted from its default location .ie my default archive location is '/oracle/archive' . After executi

  • Backup archivelog all (RMAN) Update:11-30

    For the first time Rman archive log backup, say for example log sequence 100 through 200 was backed. After few days, log sequence has increased to 267, now if i run the same archive log backup command will rman backup 100 through 267 or 201 through 2