Home » RDBMS Server » Backup & Recovery » delete obsolete true but archive logs didnt delete (9.2.0.6)  () 1 Vote
delete obsolete true but archive logs didnt delete [message #361474] Wed, 26 November 2008 09:58
Armour09
Messages: 2
Registered: June 2008
Junior Member
Hi DBA

I have a problem.
I have two database.first is real database, second is standby database.
I write bdf
51937280 15634960 36018880 94% /archive11
/dev/vg2arc1/lv2arc1
51937280 14818264 36830664 93% /archive12
rumelia:/archive22 51937280 14762056 36884904 93% /archive22
rumelia:/archive21 51937280 14762112 36884912 93% /archive21

and my archive disks are being full fastly.
I look at my backups

cd /backup/TTS/log
vi backup_database_sbt.log
and


I see that last log didn't delete.
but delete_obsolete is true.
everyday my log's delete automaticly

and I look at my standby database,
select count(*) from v$archived_log
where applied='NO';
result is 0.

finally
I delete my archive logs manuel.
delete archivelog until time sysdate-2

but this isn't a solution
even though delete_obsolete is yes ,why didn't archive logs delete on my database?

ps:last day disk was full so I backup to tape.



Previous Topic: ORA- 1427
Next Topic: Duplicate RMAN issue
Goto Forum:
  


Current Time: Sat May 04 21:42:15 CDT 2024