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:
Post a Comment