Re: ARCHIVE LOG QUESTION
- From: Denise Gwinn <denise@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 09 Nov 2011 20:01:31 -0500
Tim,
Thank you. That certainly gives me cleaner, shorter results. Now may I
physically delete those archive logs that are not listed? I get the job
of cleanup crew.
Denise Gwinn
DBA WVNET
On 11/9/2011 7:04 PM, Tim Gorman wrote:
> Denise,
> I'm assuming you want to change the results from the query and not
> remove the entries from V$ARCHIVED_LOG? Try...
>
> SQL> select thread#, dest_id, sequence#,
> decode(deleted,'YES','<deleted>',name) name
> 2 from (select thread#, dest_id, sequence#, name, deleted,
> row_number() over (partition by thread#, dest_id order by sequence#
> desc) rn
> 3 from v$archived_log)
> 4 where rn<= 3
> 5 order by 1, 2, 3 desc;
>
> THREAD# DEST_ID SEQUENCE# NAME
> ---------- ---------- ----------
>
> --------------------------------------------------------------------------------
> 1 1 64409
> /u99/oradata/PRD/archive/1_64409_677946855.arc
> 1 1 64408<deleted>
> 1 1 64407<deleted>
> 2 1 65132
> /u99/oradata/PRD/archive/2_65132_677946855.arc
> 2 1 65131
> /u99/oradata/PRD/archive/2_65131_677946855.arc
> 2 1 65130
> /u99/oradata/PRD/archive/2_65130_677946855.arc
>
>
> Not sure if that is "graceful" or not?
>
> Hope this helps? Thanks!
>
> -Tim
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
