Re: System tablespace datafile lost - NO archivelog - Recovery options...???

Marco,

Go to www.ora600.nl
This is the site of Kurt van Meerbeeck. This guy has done great jobs, and it is not all that expensive (a lot cheaper than DUL, and you can DIY). He was one of the teacher/presenters at the Miracle Downtime High Performance Bootcamp in June. Tuomas Pystynen was another one, and I happened to be the 3rd. Kurt sat next to me in my car for 16 hours driving to and from Copenhagen, so we had some time to chat.

One of his most remarkable stories was a Baan database. After a major crash it appeared tapes were never aged out, and a lot of tapes appeared unreadable. They managed to get all datafiles collected from a series of tapes spanning a month, except SYSTEM. Not that much of a consistent backup.

His tool (I've seen it working) parsed data files 'guessing' table layouts. This system ended up with 15000 tables, each exported in a dump file, each table numbered from 1..15000. A bunch of Baan consultants started (re)naming the tables based on the column type/order, and contents. After 2 weeks pretty much most of the data was there again.

Even better, if you have a system tablespace of say, a development clone, it can use that one to determine the layout and will pretty much be able to restore the whole lot.

HTH, Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Mon, 2006-10-09 at 10:13 -0600, Tim Gorman wrote:

> It's kind of like voting for president in North Korea. Only one
> choice -- under any circumstances -- when in NOARCHIVELOG mode: full
> database restore from cold backup. There are no options for partial
> recovery or any recovery at all. NOARCHIVELOG mode = full database
> restore, no recovery, period. This scenario is no exception.
>
> So, vote for Kim Jong Il...
>
>
>
> Marco Gralike wrote:
>
> > Got a nice one. What are my options?
> >
> > Situation.
> >
> > Old Oracle 7.3 database on Novell Netware 4.11 server, which is NOT
> > in archivemode AND lost the system tablespace datafile...
> >
> > I know off / and performed, in my days, nice tricky anc challenging
> > recoveries with hidden "corruption allowed" etc parameters, but
> > uptill now I always had a system tablespace datafile to work
> > with...
> >
> > Has someone ideas?
> >
> >
> >
> > Thanks
> >
> >
> > Marco
>
>
>
> --
> Tim Gorman
> consultant - Evergreen Database Technologies, Inc.
>
> website = http://www.evdbt.com
> email = tim_at_evdbt.com
> mobile = +1-303-885-4526
> fax = +1-303-484-3608
>
> -- http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l