Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Possible to recover from failed use of zerodbid

RE: Possible to recover from failed use of zerodbid

From: Reidy, Ron <>
Date: Fri, 22 Oct 2004 10:11:02 -0600
Message-ID: <>


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-----

[]On Behalf Of Stephen.Lee_at_DTAG.Com Sent: Friday, October 22, 2004 10:06 AM
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?


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.

-- Received on Fri Oct 22 2004 - 11:08:02 CDT

Original text of this message