Re: ARCHIVE LOG QUESTION
- From: Tim Gorman <tim@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 09 Nov 2011 17:04:33 -0700
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
On 11/9/2011 2:51 PM, Denise Gwinn wrote:
> I have set up rman using flash_recovery. I've run a couple of backups
> for testing. When I do the command:
> SQL> archive log list
>
> It returns oldest online sequence of 926; next log sequence to archive
> is 928.
>
> However when I do:
> SQL> select name from v$archived_log;
>
> It returns 664 rows.
>
> Is there a graceful way to get rid of the first 661 rows?
>
> Denise Gwinn
> DBA WVNET
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
