Re: Recover an unrecoverable database

2002-09-12 Thread Peter Gram




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 recovery via 
  4.1) recover database;
  4.2) when it asks for a archive file type 'mogens'
  4.3) cancel the recovery session 
5) Open the database with resetlogs


You migth need to corrupt the Rollback as well with _corrupted_rollback_segments=(xx,
xx, xx)
where 'xx' are the names of the rollback segments in the database.

If the database makes a fuzz abut not being in Archive log mode that can
be fixed when you create the control file.

There are alwas the the real brut force way : create a database with the
same name and that same datafiles, redologfiles, and controlfile
and then copy the header blocks from the datafile's to the old database with
dd.

   

  -Original Message-
Sent: Wednesday, September 11, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L


Here's the scenario - A backup was done of a database that had been
  

   
shutdown

   

  with the abort option. The redo logs (no archiving) are also backed up.
  

   
The

   

  controlfiles have since been lost.
Business request - Retrieve a schema that has since been dropped from the
database.

Attempted solution - restore the backups, open the db without performing
recovery (resetlogs and readonly corruption allowed). Unfortunately, this
resulted in an ORA-00600 when it attempted to read the SYSTEM datafile.

Does anyone have any ideas of how to open this db so we can get the data


  out of the schema? We don't care if it is not consistent.

All assistance is appreciated.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fink, Dan
  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).

  
  
  


-- 
/regards

Peter Gram

Mobil : +45 2527 7107
Fax   : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Mlv
http://miracleas.dk






smime.p7s
Description: application/pkcs7-signature


RE: Recover an unrecoverable database

2002-09-12 Thread Boivin, Patrice J



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 Maritimes Region, 
DFO | Région des Maritimes, MPO 
E-Mail: [EMAIL PROTECTED] 


  -Original Message-From: Fink, Dan 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 11, 2002 7:19 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Recover an unrecoverable database
  Here's the 
  scenario - A backup was done of a database that had been shutdown with the 
  abort option. The redo logs (no archiving) are also backed up. The 
  controlfiles have since been lost. 
  Business request - 
  Retrieve a schema that has since been dropped from the 
  database.
  
  Attempted 
  solution- restore the backups, open the db without performing recovery 
  (resetlogs and readonly corruption allowed). Unfortunately, this resulted in 
  an ORA-00600 when it attempted to read the SYSTEM 
datafile.
  
  Does anyone have 
  any ideas of how to open this db so we can get the data out of the schema? We 
  don't care if it is not consistent.
  
  All assistance is 
  appreciated.
  
  


RE: Recover an unrecoverable database

2002-09-12 Thread Fink, Dan

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 backup version, so I have no
guide for creating a controlfile. When you recreate a controlfile, the files
are listed in a specific order, which I presume matches the file# in
sys.file$. So, if you don't know the proper order, the file information in
the controlfile and data dictionary will be mismatched and thus the db
cannot be opened. Right or wrong?

Thanks to all for the ideas and information. 

Dan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  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).



RE: Recover an unrecoverable database

2002-09-12 Thread DENNIS WILLIAMS

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 left datafiles off and Oracle just flags those. That doesn't solve your
overall problem, though.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, September 12, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L


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 backup version, so I have no
guide for creating a controlfile. When you recreate a controlfile, the files
are listed in a specific order, which I presume matches the file# in
sys.file$. So, if you don't know the proper order, the file information in
the controlfile and data dictionary will be mismatched and thus the db
cannot be opened. Right or wrong?

Thanks to all for the ideas and information. 

Dan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  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).



RE: Recover an unrecoverable database

2002-09-12 Thread Binley Lim


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 complete. Oracle will 
compare the file headers with the dictionary, and flag files you have not provided in 
the create controlfile as missing. After the create controlfile, recover database, 
and alter database open. Everything required for recovery is in the redologs, so a 
normal recovery is possible. No need for any underscore parameters -- they cause more 
problems.

 [EMAIL PROTECTED] 09/13/02 05:08a.m. 
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 left datafiles off and Oracle just flags those. That doesn't solve your
overall problem, though.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, September 12, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L


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 backup version, so I have no
guide for creating a controlfile. When you recreate a controlfile, the files
are listed in a specific order, which I presume matches the file# in
sys.file$. So, if you don't know the proper order, the file information in
the controlfile and data dictionary will be mismatched and thus the db
cannot be opened. Right or wrong?

Thanks to all for the ideas and information. 

Dan


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
  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).



RE: Recover an unrecoverable database

2002-09-11 Thread DENNIS WILLIAMS

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 automatically
recover the database when it tries to start. The recovery information is
probably in the redo logs (good reason to back them up).
 
 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, September 11, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L


Here's the scenario - A backup was done of a database that had been shutdown
with the abort option. The redo logs (no archiving) are also backed up. The
controlfiles have since been lost. 
Business request - Retrieve a schema that has since been dropped from the
database.
 
Attempted solution - restore the backups, open the db without performing
recovery (resetlogs and readonly corruption allowed). Unfortunately, this
resulted in an ORA-00600 when it attempted to read the SYSTEM datafile.
 
Does anyone have any ideas of how to open this db so we can get the data out
of the schema? We don't care if it is not consistent.
 
All assistance is appreciated.
 
 

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



RE: Recover an unrecoverable database

2002-09-11 Thread Fink, Dan

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 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 automatically
recover the database when it tries to start. The recovery information is
probably in the redo logs (good reason to back them up).
 
 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, September 11, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L


Here's the scenario - A backup was done of a database that had been shutdown
with the abort option. The redo logs (no archiving) are also backed up. The
controlfiles have since been lost. 
Business request - Retrieve a schema that has since been dropped from the
database.
 
Attempted solution - restore the backups, open the db without performing
recovery (resetlogs and readonly corruption allowed). Unfortunately, this
resulted in an ORA-00600 when it attempted to read the SYSTEM datafile.
 
Does anyone have any ideas of how to open this db so we can get the data out
of the schema? We don't care if it is not consistent.
 
All assistance is appreciated.
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  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).



Re: Recover an unrecoverable database

2002-09-11 Thread Steve Perry

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

Steve

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 11, 2002 5:54 PM


 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 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
automatically
 recover the database when it tries to start. The recovery information is
 probably in the redo logs (good reason to back them up).


 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

 -Original Message-
 Sent: Wednesday, September 11, 2002 5:19 PM
 To: Multiple recipients of list ORACLE-L


 Here's the scenario - A backup was done of a database that had been
shutdown
 with the abort option. The redo logs (no archiving) are also backed up.
The
 controlfiles have since been lost.
 Business request - Retrieve a schema that has since been dropped from the
 database.

 Attempted solution - restore the backups, open the db without performing
 recovery (resetlogs and readonly corruption allowed). Unfortunately, this
 resulted in an ORA-00600 when it attempted to read the SYSTEM datafile.

 Does anyone have any ideas of how to open this db so we can get the data
out
 of the schema? We don't care if it is not consistent.

 All assistance is appreciated.


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Fink, Dan
   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: Steve Perry
  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).



Re: Recover an unrecoverable database

2002-09-11 Thread Rachel Carmichael

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 either dump files that import can read or flat files
that sqlldr can read, It helps if you have the SYSTEM tablespace, but
it is not essential.

I would not suggest even trying to get Oracle to come in with this
unless the data is so critical that you will lose enormous amounts of
money if you don't use it (yes, it was for us)

Dan, if you want more info on it, email me offline.


Rachel

--- Steve Perry [EMAIL PROTECTED] wrote:
 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 NT???
 
 Steve
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, September 11, 2002 5:54 PM
 
 
  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 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
 automatically
  recover the database when it tries to start. The recovery
 information is
  probably in the redo logs (good reason to back them up).
 
 
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 
  -Original Message-
  Sent: Wednesday, September 11, 2002 5:19 PM
  To: Multiple recipients of list ORACLE-L
 
 
  Here's the scenario - A backup was done of a database that had been
 shutdown
  with the abort option. The redo logs (no archiving) are also backed
 up.
 The
  controlfiles have since been lost.
  Business request - Retrieve a schema that has since been dropped
 from the
  database.
 
  Attempted solution - restore the backups, open the db without
 performing
  recovery (resetlogs and readonly corruption allowed).
 Unfortunately, this
  resulted in an ORA-00600 when it attempted to read the SYSTEM
 datafile.
 
  Does anyone have any ideas of how to open this db so we can get the
 data
 out
  of the schema? We don't care if it is not consistent.
 
  All assistance is appreciated.
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Fink, Dan
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: Steve Perry
   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).


__
Yahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
http://dir.remember.yahoo.com/tribute
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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 

Re: Recover an unrecoverable database

2002-09-11 Thread Joe Testa

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

Steve

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 11, 2002 5:54 PM


  

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


automatically
  

recover the database when it tries to start. The recovery information is
probably in the redo logs (good reason to back them up).


Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, September 11, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L


Here's the scenario - A backup was done of a database that had been


shutdown
  

with the abort option. The redo logs (no archiving) are also backed up.


The
  

controlfiles have since been lost.
Business request - Retrieve a schema that has since been dropped from the
database.

Attempted solution - restore the backups, open the db without performing
recovery (resetlogs and readonly corruption allowed). Unfortunately, this
resulted in an ORA-00600 when it attempted to read the SYSTEM datafile.

Does anyone have any ideas of how to open this db so we can get the data


out
  

of the schema? We don't care if it is not consistent.

All assistance is appreciated.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fink, Dan
  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: Joe Testa
  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).



RE: Recover an unrecoverable database

2002-09-11 Thread Ji, Richard

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

Steve

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 11, 2002 5:54 PM


 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 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
automatically
 recover the database when it tries to start. The recovery information is
 probably in the redo logs (good reason to back them up).


 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

 -Original Message-
 Sent: Wednesday, September 11, 2002 5:19 PM
 To: Multiple recipients of list ORACLE-L


 Here's the scenario - A backup was done of a database that had been
shutdown
 with the abort option. The redo logs (no archiving) are also backed up.
The
 controlfiles have since been lost.
 Business request - Retrieve a schema that has since been dropped from the
 database.

 Attempted solution - restore the backups, open the db without performing
 recovery (resetlogs and readonly corruption allowed). Unfortunately, this
 resulted in an ORA-00600 when it attempted to read the SYSTEM datafile.

 Does anyone have any ideas of how to open this db so we can get the data
out
 of the schema? We don't care if it is not consistent.

 All assistance is appreciated.


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Fink, Dan
   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: Steve Perry
  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: Ji, Richard
  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).