Database Backup and Recovery (MOSC)

MOSC Banner

Drop offline tablespace

edited Nov 8, 2010 5:16AM in Database Backup and Recovery (MOSC) 7 commentsAnswered ✓
 Hi, hope i dont sound too paranoid but...I am administering a db version 10.2.0.4 on Windows Server 2003 and have a tablespace offline which has only one dbf. This is showing in OEM as size 0.00 and 0.00 used.  I want to drop the tablespace and the datafile.

Currently Rman backups are failing with "RMAN-00571:could not read file header for datafile 7 error reason 4", and datafile 7 is the one offline:

The query:

SELECT FILE#, STATUS, ERROR, RECOVER, TABLESPACE_NAME, NAME
FROM   V$DATAFILE_HEADER
WHERE  RECOVER = 'YES'
OR     (RECOVER IS NULL AND ERROR IS NOT NULL);

Returns:

"FILE#","STATUS","ERROR",                    "RECOVER","TABLESPACE_NAME","NAME"

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