Enterprise Manager Generic (MOSC)

MOSC Banner

RMAN reclaimable space

edited Jan 17, 2011 10:31PM in Enterprise Manager Generic (MOSC) 5 commentsAnswered
Hello all,

 

I'm making a RMAN backup to the FRA (on SAN) and later to tape (backup recovery area).

Looking at the space available is see:

SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE                 ,08                         0               1
ONLINELOG                     0                         0               0
ARCHIVELOG                 2,58                      2,58              12
BACKUPPIECE                93,3                     62,03              37
IMAGECOPY                     0                         0               0
FLASHBACKLOG                  0                         0               0

6 rijen zijn geselecteerd.

In my opinion there a lot of reclaimable space available.

..

..

When I make a backup of a datafile:

RMAN> backup device type disk tag 'BACKUP_TWINDBT_WEE_011011120003' datafile '+TWINTGRP01/twindbt/datafile/ts_cwzmdb_i.ora';

Starting backup at 14-JAN-11
released channel: ORA_SBT_TAPE_1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center