OraFAQ Forum: Backup & Recovery » Cleaning of Old Archive Logs

Home » RDBMS Server » Backup & Recovery » Cleaning of Old Archive Logs (Windows Server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cleaning of Old Archive Logs [message #461584]

Sat, 19 June 2010 03:22

TRaj
Messages: 82
Registered: September 2006

Member

Hi,

I'm using Oracle 10g without RMAN Configuration.

Cold backup is taken every day.

A clarification .... When it's safe to delete old archive logs or do we need to retain all the old archive logs till a resetlog occurs in the db.

Tks.

Report message to a moderator

Re: Cleaning of Old Archive Logs [message #461585 is a reply to message #461584]

Sat, 19 June 2010 03:41

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

How do you know what's the old archivelog?
The daily cold backup was made by statement "backup ... plus archivelog ..." or not?

Report message to a moderator

Re: Cleaning of Old Archive Logs [message #461586 is a reply to message #461585]

Sat, 19 June 2010 03:52

TRaj
Messages: 82
Registered: September 2006

Member

Cold backup was made along with archive logs as well.

Report message to a moderator

Re: Cleaning of Old Archive Logs [message #461589 is a reply to message #461586]

Sat, 19 June 2010 05:37

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

You should use RMAN to define what are obsoleted, expired archivelog. Their information are located in RMAN repository

Report message to a moderator

Previous Topic:	How to make cold backup
Next Topic:	Why RMAN did not obtain the backupset?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 21:11:32 CST 2024