Oracle Database Discussions

Hi,

I am trying to figure out the archive names generated after a certain time.
But for few of them it just shows the stdby tns entry name instead of the actual archive name.

i am using v$archived_log.

Is there any other better view to figure out...


select name,first_change#,next_change#,to_char(first_time,'dd-mon-yyyy hh24:mi:ss') from v$archived_log where first_time >to_date('10-JAN-2012','dd-mon-yyyy hh24:mi:ss') order by first_time asc;

Thanks
sunil