I thought there was a rollback segment in system that would be there. It should be enough to get things started. After all, there isn't a separate one when you create a database, until you create it.
DENNIS WILLIAMS wrote: > Scott - I think that Rachel offered better advice, and I'm sure you've read > her note by now. I have some experience with missing files when cloning a > database :-), but I haven't had the rollback tablespace missing, and that > would be different. One thought would be to create an extra rollback > tablespace on production, so that when you perform the clone operation, > Oracle still has some rollback segments available. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Thursday, May 09, 2002 12:03 PM > To: Multiple recipients of list ORACLE-L > > Dennis, > No. I did a create controlfile set database... I commented out the > rollback_segments line in the init.ora and removed the reference to the file > in > the create controlfile statement. With no reference (that I know of) to the > rollback segments or tablespace, I thought that the database should have > come > up, then I could create a new one. I must have missed something, but I > don't > know what that was. > > DENNIS WILLIAMS wrote: > > > Scott - Let's see if I understand specifically what you did. You ran the > > CREATE DATABASE script that was generated from your production system. > Now, > > since the datafile for rollback tablespace isn't there, Oracle will come > up > > without it. Once your new instance was up, then you did a DROP TABLESPACE > on > > the rollback tablespace, followed by a CREATE TABLESPACE. I've done that > > scenario quite a few times on Oracle 8.1.6, just yesterday, as a matter of > > fact (that was a temp tablespace). If those weren't your steps, then > provide > > more details. > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -----Original Message----- > > Sent: Thursday, May 09, 2002 8:48 AM > > To: Multiple recipients of list ORACLE-L > > > > I spent a long time trying to clone our production data warehouse > > into test, to refresh it. I do this frequently, as both a way to > > refresh test instances and to test the backups. After fighting through > > 2 bad backups, I finally got a good one. However, the problem I had was > > that the production rollback tablespace is larger than the disk on test. > > > > My thought was that I could restore everything except the rollback > > tablespace, which is not the way I usually do it. I commented out the > > rollback_segments line in the init.ora and created a script that would > > create a new rollback tablespace and rollback segments, smaller than > > those in production. This didn't work, even though Oracle support said > > it should have. When I did the clone, the database would not open. I > > kept getting the following error: > > > > ORA-00600: internal error code, arguments: [25012], [1], [2], [], [], > > [], [], [] > > > > Does anyone know what I was doing wrong? I can't figure it out, and > > Oracle support couldn't figure it out, either. I was able to get the > > database up by getting more disk added, so that there was enough space > > to restore the rollback tablespace file. > > > > Thank you. > > > > -- > > Scott Canaan ([EMAIL PROTECTED]) > > (585) 475-7886 > > "Life is like a sewer, what you get out of it depends on what you put > > into it" - Tom Lehrer > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Scott Canaan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Scott Canaan ([EMAIL PROTECTED]) > (585) 475-7886 > "Life is like a sewer, what you get out of it depends on what you put into > it" - > Tom Lehrer > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Scott Canaan > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
