OraFAQ Forum: Backup & Recovery » Tablespace recovery

Home » RDBMS Server » Backup & Recovery » Tablespace recovery (10.2.0.3 on Windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tablespace recovery [message #416026]

Thu, 30 July 2009 03:58

jalcroft
Messages: 3
Registered: July 2009
Location: UK

Junior Member

Hi all

My Oracle server crashed last week and I am pulling my hair out for being so stupid and not doing what I tell others to do.

I do Oracle exports every night of our development and testing schema's. This is done with a script generating a .par file with all schema owners which contain a specific table.

What I had totally forgotten is that we have a FAQ and Forum schema. Guess what, these don't contain my specific table.

I have the .dbf files. I have copies of the control file.

I have created a new database, named the same on my laptop. I have copied the control file and have my database working with just the default data. When I try to recreate my control file to add in my two tablespaces, I get error 1159 (file is not from the same database as previous files - wrong database id).

Questions:
How do I find out what the database id was on my crashed database? If I can find this, how do I create my new database with the sames ID.
If I can't get this, is it possible to add this data file?
Or should I just cut my losses and get shouted at?

Many thanks for your help

James

Report message to a moderator

Re: Tablespace recovery [message #416087 is a reply to message #416026]

Thu, 30 July 2009 07:21

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>I have the .dbf files. I have copies of the control file.
Are these from a valid "cold" backup?
If so,
just copy them in a similar directory structure( in new machine) and just mount the database.
Else, you may be out of luck.
Please be aware that EXPORT is not a backup. It is just a method to move the data/objects around.

Quote:

I have created a new database, named the same on my laptop. I have copied the control file and have my database working with just the default data.

This will not work. You cannot just "plug" the datafiles from another database unless it is something transportable tablespaces.

Report message to a moderator

Re: Tablespace recovery [message #416090 is a reply to message #416087]

Thu, 30 July 2009 07:38

jalcroft
Messages: 3
Registered: July 2009
Location: UK

Junior Member

Thanks for the reply.

The primary drive (C:) crashed on the server. Drive D: and E: were Ok. the two data files were on D: and E:.

I have had to rebuild the db and I have tried adding the data file from the D: and get the same error.

Report message to a moderator

Re: Tablespace recovery [message #416147 is a reply to message #416090]

Thu, 30 July 2009 18:24

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You didn't answer Mahesh's key question:

Mahesh Rajendran wrote on Thu, 30 July 2009 08:21

>>I have the .dbf files. I have copies of the control file.
Are these from a valid "cold" backup?

Another question would be...are all the .dbf, redo log and control file(s) recoverable from the D: and E: drives?

Report message to a moderator

Re: Tablespace recovery [message #416206 is a reply to message #416147]

Fri, 31 July 2009 03:12

jalcroft
Messages: 3
Registered: July 2009
Location: UK

Junior Member

Not from any backup, the drives where these data files were are in tact and I still have a backup control file.

James

Report message to a moderator

Re: Tablespace recovery [message #416223 is a reply to message #416206]

Fri, 31 July 2009 04:50

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You "may" be able to simply recreate the Windoze Oracle service with oradim and start the database and let it do instance recovery.

Report message to a moderator

Previous Topic:	point in time recovery in oracle 10g.
Next Topic:	Incrementally updated backups

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 23:27:00 CST 2024