Monday, January 30, 2012

Arc-Log-Space/RMAN


This is a little script I used for checking archive log space usage:

connect / as sysdba
set linesize 132
set numf 999,999,999,999,999
column name format a32

archive log list;

show parameter db_recovery_file_dest;

SELECT * FROM V$RECOVERY_FILE_DEST;

connect /


Then for manual RMAN backup and removal of log files I use the following:

ORACLE_SID= export ORACLE_SID
rman
connect target /
BACKUP ARCHIVELOG ALL DELETE ALL INPUT;

Thx

No comments: