Re: How to bring rollback tablespace online?

PATRICK HUYNH wrote:
>
> I tried to rename the datafile of some of the tablespaces. First, i take
> the tablespaces offline and that including the rollback tablespace as
> well.
> After successfully rename the datafile of one of the tablespace, i tried
> to bring that tablespace back online, i get the following errors:
> SQLDBA> alter tablespace users online;
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00376: file 4 cannot be read at this time
> ORA-01110: data file 4: 'ORA_TDDE_DISK4:[DBS]TDDE_RBS_1.DBF'
>
> So, i thought i have to bring the rollback tablespace online first, but
> when i tried that i got the same error.
> Is there anyway that i can bring rollback tablespace online again?

  Recover the tablespace if you are using ARCHIVELOG mode.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841