Stephen, I have found that when I have trouble with metalink, letting the sales = rep know your level of disatisfaction works well at breaking things = loose. ----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Stephen.Lee@xxxxxxxx Sent: Friday, October 22, 2004 10:06 AM To: oracle-l@xxxxxxxxxxxxx Subject: Possible to recover from failed use of zerodbid No I didn't use the newdbid utility because I forgot about it. Now that is out of the way, I have an "analyst" on the other end at = metalink who just doesn't get the scenario I am describing and refuses to get = some help. It's always gratifying to know that those six-figure support fees = you pay to Oracle go to help the winos from the Salvation Army shelter find work. So I'll check on the list to see if anyone knows the black arts that = must be applied to recover from the following scenario: Copied a database. Recreated the control file changing the database name. Spent a few hours, making changes for the environment for the new = database. One of those changes was to reduce the number of rollback segments. =3D=3D> Forgot to change the rollback_segments in the init.ora. = ($*@#$*@!!) Went through steps to change dbid using zerodbid. Open resetlogs failed because rollback_segments parameter was wrong. We are now hosed. As far as I know, some low-level block fiddling is required ??? Or might there be a magic, undocumented command to tell the instance = forget about what it sees in file headers and trust me that it's OK to reset everything and open anyway? -- //www.freelists.org/webpage/oracle-l This electronic message transmission is a PRIVATE communication which = contains information which may be confidential or privileged. The information is = intended=20 to be for the use of the individual or entity named above. If you are = not the=20 intended recipient, please be aware that any disclosure, copying, = distribution=20 or use of the contents of this information is prohibited. Please notify = the sender of the delivery error by replying to this message, or notify us = by telephone (877-633-2436, ext. 0), and then delete it from your system. -- //www.freelists.org/webpage/oracle-l