Home » RDBMS Server » Backup & Recovery » RMAN - Delete backed up archive logs (Oracle 9i, Solaris 9)
RMAN - Delete backed up archive logs [message #405644] Thu, 28 May 2009 20:28 Go to next message
Erdenejargal
Messages: 18
Registered: July 2008
Junior Member
Hi,

Following script can work normal. But I want to delete 5 days ago, archive input log.

How to do that?

run {
allocate channel d1 type disk;
setlimit channel d1 kbytes 2097150 maxopenfiles 32 readrate 200;
backup
incremental level 0 cumulative
skip inaccessible
tag wednesday_level_0
format '/backup/df_t%t_s%s_p%p_%c'
database;
copy current controlfile to '/backup/wednesday.ctl';
sql 'alter system archive log current';
backup
format '/backup/al_t%t_s%s_p%p_%c'
archivelog all;
release channel d1;
}
run {
allocate channel r1 type disk;
BACKUP ARCHIVELOG ALL DELETE ALL INPUT format '/backup/df_t%t_s%s_p%p_%c';
release channel r1;
}
run {
allocate channel v1 type disk;
restore database validate;
release channel v1;
}

BR,
Erdenejargal.B
Re: RMAN - Delete backed up archive logs [message #405645 is a reply to message #405644] Thu, 28 May 2009 20:32 Go to previous messageGo to next message
Erdenejargal
Messages: 18
Registered: July 2008
Junior Member
Or

How to change the RMAN configuration of archive log?

BR,
Erdenejargal.B
Re: RMAN - Delete backed up archive logs [message #405715 is a reply to message #405645] Fri, 29 May 2009 03:59 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Erdenejargal wrote on Thu, 28 May 2009 21:32

How to change the RMAN configuration of archive log?


What configuration do you want to change ?
Previous Topic: Please help me recover this database
Next Topic: alter tablespace begin backup
Goto Forum:
  


Current Time: Fri Nov 22 08:19:52 CST 2024