OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » archivelog file?

Mon, 27 August 2007 23:42

rtskrajan
Messages: 43
Registered: March 2007

Member

Hi experts,
how can i delete archive log files?

thanks in advance

Mon, 27 August 2007 23:56

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
which backup method your using.

1. RMAN

set retention policy
and

 backup archivelog all delete all input

2. user managed backup

after taking valid database backup.

Tue, 28 August 2007 00:05

rtskrajan
Messages: 43
Registered: March 2007

Member

Hi thanks,

I am using RMAN...

i made retention policy 31 days.

Is it enough or not?

give some valuable advice

thanks in advance

Tue, 28 August 2007 00:44

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

http://download.oracle.com/docs/cd/B14117_01/server.101/b10734/rcmconc1.htm#1017203

Go through above link for compete details about retention policy.

Tue, 28 August 2007 01:24

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

i made retention policy 31 days.

If you have sufficient disk space you can make it. Its up to you.

Previous Topic:	Instance Recovery......
Next Topic:	RMAN Tag parameter

Goto Forum:

]

Current Time: Fri May 17 03:27:09 CDT 2024