Re: RMAN and datafile

Volker wrote:
> We have a somewhat strange situation on a production database. A
> datafile was added by accident to the INDX-tablespace. It was almost
> immediatly resized and put offline (another datafile was added to the
> right tablespace). The database is running fine and rman does an online
> backup fine (no error/warning). So far so good. Now we got space
> problems because rman does not consider anything as obsolete anymore
> because of this accidently added datafile ('report need backup days 7
> database' gives back the datafile - we have an redundancy of 1). The
> datafile can not be put online (Enterprise Manager says it needs
> recovery) and it cannot be recovered because its not in the backup. The
> datafile is empty (Enterprise Manager says 0.00% used) und could be
> deleted, but what i have read about this topic is not promising. So any
> suggestions on what can/should be done so i have a good backup again?
>
> [Oracle 9.2.0.1.0]
>
> Regards
>
> Volker
>

Create a new index tablespace and move all of your indexes to this new tablespace with the ALTER INDEX REBUILD command. Then drop this problem tablespace.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown