Home » RDBMS Server » Backup & Recovery » Cleaning of Old Archive Logs (Windows Server)
Cleaning of Old Archive Logs [message #461584] Sat, 19 June 2010 03:22 Go to next message
TRaj
Messages: 80
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.
Re: Cleaning of Old Archive Logs [message #461585 is a reply to message #461584] Sat, 19 June 2010 03:41 Go to previous messageGo to next message
trantuananh24hg
Messages: 605
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?
Re: Cleaning of Old Archive Logs [message #461586 is a reply to message #461585] Sat, 19 June 2010 03:52 Go to previous messageGo to next message
TRaj
Messages: 80
Registered: September 2006
Member

Cold backup was made along with archive logs as well.
Re: Cleaning of Old Archive Logs [message #461589 is a reply to message #461586] Sat, 19 June 2010 05:37 Go to previous message
trantuananh24hg
Messages: 605
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
Previous Topic: How to make cold backup
Next Topic: Why RMAN did not obtain the backupset?
Goto Forum:
  


Current Time: Sat Aug 23 08:38:43 CDT 2014

Total time taken to generate the page: 0.10813 seconds