Re: recovery without restoring backup

niy38_at_hotmail.com wrote:
> version is: 10.2.0.1.0
>
> database is running normal until developer complain this error:
>
> ORA-01552: cannot use system rollback segment for non-system tablespace
> 'USERS'
I can't imagine getting ORA-01552 without doing some DBA type of task - what are your developers doing? DDL on the fly? Truncate table with too small undo?

>
>
> I check dba_rollback_segs where all status are "needs recovery", and
> status of
> v$datafile of datafiles for undo is "recovery".
>
> then I "shutdown immediate", and after I start, database can open and
> undo still
> in the same status.
>
> I shutdown again and startup mount, run "recever tablespace undo", and
> it's set.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20061201/news_1b1websense.html