OraFAQ Forum: Backup & Recovery » completed before clause

Home » RDBMS Server » Backup & Recovery » completed before clause

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

completed before clause [message #534607]

Wed, 07 December 2011 13:25

BeefStu
Messages: 208
Registered: October 2011

Senior Member

Is there a difference between the first set of commands
and the second? If so, can somebody give a scenario when each
should be used?

Typically, I just use the first set?


CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
DELETE NOPROMPT OBSOLETE;

and

CROSSCHECK ARCHIVELOG ALL completed before 'sysdate -30';
DELETE NOPROMPT OBSOLETE;

Report message to a moderator