Re: URGENT HELP WITH DATAFILE/ROLLBACK SEGEMENTS

From: NeilC <neilc-olops_at_nospambtinternet.com>
Date: Thu, 23 Dec 1999 09:18:54 +0000
Message-ID: <3861E8FE.7E1C4B8C@nospambtinternet.com>

Assuming you are running in archivelog mode, you will need to comment out the rollback segment name in the init.ora or config.ora file

svrmgrl>startup mount; the database
svrmgrl>alter database datafile '/oracle/sps6/rbs02.dbf' offline;
svrmgrl>alter database open;

restore a backup of the datafile and apply media recovery to this datafile

svrgmrl>recover tablespace RBS02;
svrmgrl>alter tablespace RBS02 online;
svrmgrl>alter rollback segment rbs01 online;

hth

Neilc

Garsen Subramoney wrote:
>
> Hi
>
> I have the following problem.
>
> The situation I have is the following:
>
> A datafile used to store rollback segments has been removed from the
> operating system of the server (AIX). I have worked around this by creating
> another set of rollbacks segs on a different datafile and in a different
> tablespace.
>
> However when I do a select count(*) from all_tables I get the error:
> ORA-00376: file 12 cannot be read at this time
> ORA-01110: data file 12: '/oracle/sps6/rbs02.dbf'
>
> This datafile no longer exits on the operating system.
>
> When i do a
> "drop tablespace RBS02 including contents"
> i get the error
> "ORA-01548: active rollback segment 'RBS01' found, terminate dropping
> tablespace"
>
> when i do a "drop rollback segement RBS01"
> i get the error
> "ORA-01545: rollback segment 'RBS01' specified not available"
>
> when i query dba_rollback_segements i see that the status of the rollback
> segment is in "NEEDS RECOVERY "
>
> Now the datafile for this rollback segement has been deleted so why is it
> giving me this error
>
> does anyone know how i can get around it.
>
> Thanks a million
Received on Thu Dec 23 1999 - 03:18:54 CST