Re: ORA_01001: invalid cursor Error on a CLONE Database

Thanks for the suggestion it 'sort of' helps.

I added a file to the temporary tablespace and am now getting error: ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMPX' From the description of ORA-01552
Cause: An attempt was made to use the system rollback segment for operations involving non-system tablespace. If this is a clone database then this will happen when attempting any data modification outside of the system tablespace. Only the system rollback segment can be online in a clone database.

I have followed the instructions in Ch. 7 of the 9i User-Managed Backup an dRecovery Guide which doesn't indicate that you need to add file for the default temporary tablespace or that there should be a problem with the undo when running transport_set_check.

Any other suggestions? It appears to me that the 'unbreakable database' is broken.

Thx Richard Kinread
"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F2964FA.DB104FF7_at_remove_spam.peasland.com...
> The following from the docs:
>
> Error: ORA-25153 Text: Temporary Tablespace is Empty
> --------------------------------------------------------------------------
-
> Cause: An attempt was made to use space in a temporary tablespace with
> no
> files.
> Action: Add files to the tablespace using ADD TEMPFILE command.
>
> Does this help?
>
> Brian
>
> Richard Kinread wrote:
> >
> > I am running Oracle 9i 9.2.0 on Red Hat 7.3 and am trying to do
user-managed
> > TSPITR and get the following errors when I execute transport_set_check:
(I
> > am disappointed that the error messages aren't clearer.
> >
> > SQL> execute dbms_tts.transport_set_check('users', true);
> > BEGIN dbms_tts.transport_set_check('users', true); END;
> >
> > *
> > ERROR at line 1:
> > ORA-01001: invalid cursor
> > ORA-06512: at "SYS.DBMS_SYS_SQL", line 819
> > ORA-06512: at "SYS.DBMS_SQL", line 19
> > ORA-06512: at "SYS.DBMS_TTS", line 774
> > ORA-25153: Temporary Tablespace is Empty
> > ORA-06512: at "SYS.DBMS_TTS", line 803
> > ORA-06512: at line 1
> >
> > I believe I have done all of the prereq steps correctly - copied backup
> > control file, backup datafiles and current logs, mounted a clone
database,
> > recovered to a point in time before failure, and opened the database and
> > reset the logs.
> >
> > I also received almost the same set of messages when I tried to export
the
> > users tablespace metadata. (Second last error message above is replaced
by:
> > ORA-06512: at "SYS.DBMS_PLUGTS", line 1093
> >
> > Any help would be much appreciated.
> >
> > Thanks,
> > Richard
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Fri Aug 01 2003 - 20:47:14 CDT