<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/'><id>tag:blogger.com,1999:blog-6850817271941197798.post1284193094772349287..comments</id><updated>2010-07-20T15:35:13.356-07:00</updated><category term='Downloads/Tools'/><category term='UNIX'/><category term='Articles/Best Practices'/><category term='Transportable TBS'/><category term='SQL'/><category term='Certification'/><category term='Backup/Recovery'/><category term='RMAN Recovery'/><category term='Corruption/Recovery'/><category term='Oracle Agile'/><category term='Oracle Beta Program'/><category term='OCR - VOTE'/><category term='Migrate'/><category term='Patch/Bug Fix'/><category term='RAC-Errors'/><category term='TNS Errors'/><category term='ASM'/><category term='Administration'/><category term='UTL_MAIL'/><category term='Data Pump'/><category term='Upgrade 8i to 10g'/><category term='EM Grid Control'/><category term='Flash Recovery Area'/><category term='Upgrade to 10.2.0.4'/><category term='RAC Admin'/><category term='Oracle 11g New Feat'/><category term='RMAN Backup'/><category term='Ora-Errors'/><category term='Oracle 10g New Feat'/><category term='Export/Import'/><category term='Spfile and Pfile'/><category term='Installation'/><title type='text'>Comments on Oracle DBA and RAC DBA Expert: Delete archive logs using RMAN.</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://www.oracleracexpert.com/feeds/1284193094772349287/comments/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6850817271941197798/1284193094772349287/comments/default'/><link rel='alternate' type='text/html' href='http://www.oracleracexpert.com/2009/08/delete-archive-logs-using-rman.html'/><author><name>Satishbabu Gunukula</name><uri>http://www.blogger.com/profile/02630966486825083489</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='26' height='32' src='http://1.bp.blogspot.com/-6LVrTZp4FAc/TyuE2-poniI/AAAAAAAAAH8/LLuSIKxM0mU/s220/untitled2.bmp'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>3</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-6850817271941197798.post-3088712741788829859</id><published>2010-07-20T15:35:13.356-07:00</published><updated>2010-07-20T15:35:13.356-07:00</updated><title type='text'>delete noprompt force archivelog until time &amp;#39;s...</title><content type='html'>delete noprompt force archivelog until time &amp;#39;sysdate-1&amp;#39; like &amp;#39;/sv1/arch/RMANPRD/&lt;br /&gt;*&amp;#39;;&lt;br /&gt;&lt;br /&gt;Please note that there are no archivelogs to satisfy the above command that&amp;#39;s why you have received that message.</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6850817271941197798/1284193094772349287/comments/default/3088712741788829859'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6850817271941197798/1284193094772349287/comments/default/3088712741788829859'/><link rel='alternate' type='text/html' href='http://www.oracleracexpert.com/2009/08/delete-archive-logs-using-rman.html?showComment=1279665313356#c3088712741788829859' title=''/><author><name>Satishbabu Gunukula</name><uri>http://www.blogger.com/profile/02630966486825083489</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://www.oracleracexpert.com/2009/08/delete-archive-logs-using-rman.html' ref='tag:blogger.com,1999:blog-6850817271941197798.post-1284193094772349287' source='http://www.blogger.com/feeds/6850817271941197798/posts/default/1284193094772349287' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-1925255453'/></entry><entry><id>tag:blogger.com,1999:blog-6850817271941197798.post-2787759579731635338</id><published>2010-05-20T07:45:25.390-07:00</published><updated>2010-05-20T07:45:25.390-07:00</updated><title type='text'>Hi
I am using this same command and RMAN Process i...</title><content type='html'>Hi&lt;br /&gt;I am using this same command and RMAN Process is telling me &amp;quot;specification does not match any archived log in the recovery catalog&amp;quot;&lt;br /&gt;&lt;br /&gt;Any suggestions&lt;br /&gt;thanks&lt;br /&gt;Vikas&lt;br /&gt;&lt;br /&gt;my code:&lt;br /&gt;rman target / &amp;lt;&amp;lt; EOD&lt;br /&gt;run {&lt;br /&gt;allocate channel ch01 type disk;&lt;br /&gt;# delete noprompt force archivelog until time &amp;#39;SYSDATE-1&amp;#39;; # this works deletes&lt;br /&gt;all files from disk and asm.&lt;br /&gt;# delete noprompt force archivelog like &amp;#39;+COMMPRD_ARC/&amp;#39; completed before &amp;#39;SYSDAT&lt;br /&gt;E-1&amp;#39;;&lt;br /&gt;# delete noprompt force archivelog until time &amp;#39;SYSDATE-3&amp;#39; like &amp;#39;+COMMPRD_ARC/RMA&lt;br /&gt;NPRD/ARCHIVELOG/2010_05_20/thread_1_*&amp;#39;;&lt;br /&gt;delete noprompt force archivelog until time &amp;#39;sysdate-1&amp;#39; like &amp;#39;/sv1/arch/RMANPRD/&lt;br /&gt;*&amp;#39;;&lt;br /&gt;release channel ch01;&lt;br /&gt;}&lt;br /&gt;EOD</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6850817271941197798/1284193094772349287/comments/default/2787759579731635338'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6850817271941197798/1284193094772349287/comments/default/2787759579731635338'/><link rel='alternate' type='text/html' href='http://www.oracleracexpert.com/2009/08/delete-archive-logs-using-rman.html?showComment=1274366725390#c2787759579731635338' title=''/><author><name>BI_PM</name><uri>http://www.blogger.com/profile/11687839356252432343</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://www.oracleracexpert.com/2009/08/delete-archive-logs-using-rman.html' ref='tag:blogger.com,1999:blog-6850817271941197798.post-1284193094772349287' source='http://www.blogger.com/feeds/6850817271941197798/posts/default/1284193094772349287' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-1879271010'/></entry><entry><id>tag:blogger.com,1999:blog-6850817271941197798.post-3129994246951309573</id><published>2009-12-19T10:07:40.581-08:00</published><updated>2009-12-19T10:07:40.581-08:00</updated><title type='text'>Step Configuration :
The first thing to do is, fin...</title><content type='html'>Step Configuration :&lt;br /&gt;The first thing to do is, find where the archive log is put and after that you must use RMAN to delete the archive on command promt. type this command RMAN&lt;br /&gt;&lt;br /&gt;RMAN&amp;gt; run { allocate channel d1 type disk;&lt;br /&gt;delete archivelog all;&lt;br /&gt;release channel d1;&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;&lt;a href="http://www.zoombits.de/speicherkarten/sd-karte/memory-2-go-16gb-sdhc-speicherkarte-(klasse-4)/5970" rel="nofollow"&gt;16GB SD Karte&lt;/a&gt;</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6850817271941197798/1284193094772349287/comments/default/3129994246951309573'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6850817271941197798/1284193094772349287/comments/default/3129994246951309573'/><link rel='alternate' type='text/html' href='http://www.oracleracexpert.com/2009/08/delete-archive-logs-using-rman.html?showComment=1261246060581#c3129994246951309573' title=''/><author><name>Sara Reid</name><uri>http://www.blogger.com/profile/18373862159812719999</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://www.oracleracexpert.com/2009/08/delete-archive-logs-using-rman.html' ref='tag:blogger.com,1999:blog-6850817271941197798.post-1284193094772349287' source='http://www.blogger.com/feeds/6850817271941197798/posts/default/1284193094772349287' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-287667857'/></entry></feed>
