This discussion is archived
5 Replies Latest reply: Jan 28, 2013 10:24 PM by ltomovski RSS

What does "completed" on standby means

ltomovski Newbie
Currently Being Moderated
I need to delete applied archive logs on the standby database .. So I have searched the web and I have found a lot of ways and scripts to make it happen so I do not need a solution to this .. but while I was looking I came acorss this one

delete noprompt archivelog all completed before 'sysdate-10';

In the context of standby database what does completed means .. Does it mean the completion_time of the archivelog or it means that it is applied to the standby



  • Correct Answers - 10 points
  • Helpful Answers - 5 points