OraFAQ Forum: Backup & Recovery » regarding old archive log files......

Home » RDBMS Server » Backup & Recovery » regarding old archive log files......

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

regarding old archive log files...... [message #113551]

Mon, 04 April 2005 10:30

balavignesh
Messages: 180
Registered: March 2005

Senior Member

hai,
see in our firm , they are unnecessarily maintaining the old archive log files of last year....is this needed..?if we can delete..,then we can have more free space.if to delete , is there any script to perform the same.
any help is appreciated.

regards
bala

Report message to a moderator

Re: regarding old archive log files...... [message #113552 is a reply to message #113551]

Mon, 04 April 2005 10:42

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Depending on your retention policy,after the backup, you can always delete the archived logs.
If you are using RMAN , there are options to delete the archivedlogs immediately after the backup and rman can sync the catalog.
else
you can manually JUST delete it and update the catalog.
IF not using RMAN , no catalog is involved.
so you can just remove the archivelogs once they are backed up.

Report message to a moderator

Re: regarding old archive log files...... [message #113563 is a reply to message #113552]

Mon, 04 April 2005 11:16

balavignesh
Messages: 180
Registered: March 2005

Senior Member

hai,
thank u for ur reply.can u give me RMAN commands for deleting the old log files being a beginner in DBA.

regards
bala

Report message to a moderator

Re: regarding old archive log files...... [message #113567 is a reply to message #113551]

Mon, 04 April 2005 11:38

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i suggest to read the docs first.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/toc.htm

Before doing anything with backups, be sure what you are doing.
the doc deals extensively about the maintainence of RMAN catalog.

Report message to a moderator

Re: regarding old archive log files...... [message #114702 is a reply to message #113551]

Tue, 05 April 2005 03:28

srinivenkat
Messages: 7
Registered: April 2005
Location: Bangalore

Junior Member

i am suggest u to read the http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmquick.htm

Here u can go through all the necessary things.

Thanks
srinivasan v

Report message to a moderator

Previous Topic:	Reg Exports..
Next Topic:	Media Recovery: Corrupted redo log block header

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 17:03:27 CDT 2024