RMAN question

From: mek s <sidi.bouzid.meknessy@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx, oracle-rac@xxxxxxxxxxxxx
Date: Wed, 13 Jul 2011 09:41:49 +0200
About RMAN incremental updated backup, what 's the difference between using
the “until time” clause in RECOVER COPY OF DATABASE and not including this
clause?
As a requirement, the customer is asking the ability to recover the database
to any time within the past 31 days.

We are backing up the fast recovery area to tape every week.

I have read that in the case I am NOT using tape, I have to include the the
“until time” clause in RECOVER COPY OF DATABASE.

Someone can explain me the difference, please?

Here, you can find my backup scripts:

*1- Including the UNTIL TIME clause:*

CONNECT TARGET /

CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;

# Incrementally updated backup.
RECOVER COPY OF DATABASE WITH TAG 'LVL0_MERGE_INCR' UNTIL TIME 'SYSDATE-7';
BACKUP CHECK LOGICAL INCREMENTAL LEVEL 1 CUMULATIVE COPIES=1 FOR RECOVER OF
COPY WITH TAG 'LVL0_MERGE_INCR' DATABASE;

# Switch current logfile to archive
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

# Backup archivelogs
BACKUP CHECK LOGICAL AS COMPRESSED BACKUPSET FILESPERSET 10 ARCHIVELOG ALL
DELETE INPUT;

# delete obsolete backups
CROSSCHECK BACKUP;
DELETE NOPROMPT OBSOLETE;
DELETE NOPROMPT EXPIRED BACKUP;

exit;
*
2- NOT Including the UNTIL TIME clause:*

CONNECT TARGET /

CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;

# Incrementally updated backup.
RECOVER COPY OF DATABASE WITH TAG 'LVL0_MERGE_INCR';
BACKUP CHECK LOGICAL INCREMENTAL LEVEL 1 CUMULATIVE COPIES=1 FOR RECOVER OF
COPY WITH TAG 'LVL0_MERGE_INCR' DATABASE;

# Switch current logfile to archive
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

# Backup archivelogs
BACKUP CHECK LOGICAL AS COMPRESSED BACKUPSET FILESPERSET 10 ARCHIVELOG ALL
DELETE INPUT;

# delete obsolete backups
CROSSCHECK BACKUP;
DELETE NOPROMPT OBSOLETE;
DELETE NOPROMPT EXPIRED BACKUP;

exit;
RMAN question

Other related posts:
