Database Backup and Recovery (MOSC)

MOSC Banner

delete VERY old archivelog

edited Jun 12, 2017 10:53AM in Database Backup and Recovery (MOSC) 3 commentsAnswered ✓

I just start to taking care of a database that has been around for a long time ( 10.2.0.4).

I just found out that there are lots of old archivelog inside ASM DISKGROUP. From 2009 all the way to 2015.

ASMCMD> ls

2009_06_02/

2009_06_03/

2009_06_04/

2009_06_05/

until...

2015_01_13/

2015_01_14/

2015_01_15/

2015_01_16/

2015_01_17/

and there is none until very recently. this is of course due to backup + archivelog delete input.

2017_05_16/

2017_05_17/

2017_05_18/

2017_05_19/

2017_05_20/

when i list all archivelog via RMAN, this is what I get.

List of Archived Log Copies

Key     Thrd Seq     S Low Time  Name

------- ---- ------- - --------- ----

24937   1    7955    A 16-MAY-17 +DATA/xyz/archivelog/2017_05_16/thread_1_seq_7955.redacted

24943   1    7956    A 16-MAY-17 +DATA/xyz/archivelog/2017_05_16/thread_1_seq_7956.redacted

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center