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
I am sorry I do not see how this is helpful
My scenario is this:
I got a standby database ... In this statement used against the standby database (not the primary) -> delete noprompt archivelog all completed before 'sysdate-10';
what does the COMPLETED stands for ?
Is this the completion time of the archvelog or it has some meaning in the context of the standby meaning that it is applied ?
Note this is an RMAN command ..
Edited by: ltomovski on Jan 28, 2013 2:47 AM
I do not think that "completed " refers to the date that archivelog has been (or "could be" ) applied in dataguard .
I think that "completed" refers the date on which the rman archivelog backup has been completed (just as rman command)
take a look at
Edited by: clementeOTN on 28-ene-2013 12:26