Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g49GFnV17347 for ; Thu, 9 May 2002 12:15:49 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id JAA13701; Thu, 9 May 2002 09:23:47 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 0045CE9A; Thu, 09 May 2002 09:03:26 -0800 Message-ID: Date: Thu, 09 May 2002 09:03:26 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Scott Canaan Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Scott Canaan Subject: Re: Cloning Question Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT 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. > dwilliams@lifetouch.com > > -----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 (srcdco@rit.edu) > (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: srcdco@ritvax.rit.edu > > 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: ListGuru@fatcity.com (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: DWILLIAMS@LIFETOUCH.COM > > 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: ListGuru@fatcity.com (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 (srcdco@rit.edu) (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: srcdco@ritvax.rit.edu 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: ListGuru@fatcity.com (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).