RMAN question
Date: Wed, 13 Jul 2011 09:41:49 +0200
Message-ID: <CAJX5RkQ3AJjWia2FkS7_s-FdbvGiRzvSu0M9Jn5MNtK=S+L6zw_at_mail.gmail.com>
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;
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 13 2011 - 02:41:49 CDT