Posted By

thescorpion on 09/29/12

Tagged

sql
Oracle

Versions (?)

Last Edited at 09/29/12 02:33am

Statistics

Viewed 1409 times

Favorited by 0 user(s)

Related snippets

Borra archivos LOG Oracle usando RMAN

/ Published in: SQL

Borrar archivos Log con Rman

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

---ver espacios qye se puede reciclar
SELECT space_limit/1024/1024 "Limit MB", space_used/1024/1024 "Used MB",
  space_reclaimable/1024/1024 "Reclaimable MB"
  FROM v$recovery_file_dest;
 
--Shell inicienado sentencia
  $ rman target /
 
--Una vez que tenemos prompt ejecutamos el comando DELETE con el periodo de un dÃa hacia atrÃ¡s.
 
RMAN> DELETE ARCHIVELOG UNTIL TIME 'sysdate -1';
 
--OTRA OPCION
RMAN> DELETE archivelog until TIME "to_date('2010-06-05 12:50:00','YYYY-MM-DD:HH24:MI:SS')";