Hi Dan
It should be possible to open that database !
1) You should restore the databse from tape once more to make sure we
start on somthing clean.
2) Add the _allow_resetlogs_corruption=true to the parameter file (init.ora)
3) Mount the database and create new controlfiles
4) Do a fake
I
would be curious to hear what Oracle Support suggests, Dan.
Regards, Patrice Boivin Systems Analyst
(Oracle Certified DBA)
Systems Admin Operations | Admin. et
Exploit. des systèmes Technology
Services | Services
technologiques Informatics
Branch | Direction de
l'informatique
I've tried several approaches to the recovery. So far, no success. I have a
feeling that this is a truly unrecoverable db (without having Oracle Field
Support use their magic).
The main problem (in my mind) is that the current database physical
structure (files and sizes) does not match the
Dan - When you say recreate a control file are you meaning the CREATE
CONTROLFILE statement? If so, then in answer to that specific issue, the
order of the datafiles does not matter. I do this regularly to create test
databases and I've never worried about making the order the same. I have
even
If I recall the original problem, you have a backup of the datafiles, and redologs,
but no controlfiles. In that case, just specify all the datafiles and redologs (that
are in the backup) in the create controlfile... statement.
The order does not matter, nor is the list required to be
Dan - May be a good Oracle Support question. I've had pretty good luck with
them on really challenging recoveries. My suggestion would be to try again.
Load the files again from tape, but allow recovery when the database comes
up. Since the database was shutdown abort, Oracle will want to
I have a colleague working the 'Official' approach with Oracle support. I am
not certain what he will learn nor how quickly, so I'm taking the shotgun
approach.
Dan
-Original Message-
Sent: Wednesday, September 11, 2002 3:26 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Dan - May
If you can't recover it, Oracle has, or had, a utility called DUL (Data
UnLoader ???) that will read the datafiles and create files usable by
sqlldr.
I haven't used it, but I heard about it several times.
It's still urban legend until I get a copy :)
Anybody have a copy I can borrow for AIX or
Steve,
no one will ever have a copy of data unloader because Oracle does not
sell IT but sells the service of running it for you.
It's not urban legend, I've used it. It's from Field Support, not Tech
Support, it's expensive as all getout and they are reluctant to use it.
It will generate
no urban legend as Rachel has had to use it, the catch is they come in,
load the software, do the unloading and remove it before they leave.
oh and its EXPENSIVE.
joe
Steve Perry wrote:
If you can't recover it, Oracle has, or had, a utility called DUL (Data
UnLoader ???) that will read the
Correct me if I am wrong, I don't think anybody has a copy. Oracle will run
it for you and bill you for it.
-Original Message-
Sent: Wednesday, September 11, 2002 8:53 PM
To: Multiple recipients of list ORACLE-L
If you can't recover it, Oracle has, or had, a utility called DUL (Data
11 matches
Mail list logo