Re: System tablespace datafile lost - NO archivelog - Recovery options...???
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: tim@xxxxxxxxx, Marco Gralike <Marco.Gralike@xxxxxxx>
- Date: Mon, 09 Oct 2006 20:51:35 +0200
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@xxxxxxxxx
> mobile = +1-303-885-4526
> fax = +1-303-484-3608
>
> -- //www.freelists.org/webpage/oracle-l
Other related posts:
