Home » RDBMS Server » Backup & Recovery » how get 12c data when windows 7 crashed (oracle 12C)
how get 12c data when windows 7 crashed [message #659178] Mon, 09 January 2017 01:14 Go to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
hi to all
dear
my windows 7 have crashed
my windows in C:\> drive and my oracle 12c in D:\> drive
pleas give me idea how i get my oracle 12c database or data
we need data because data is very important for me

hope you understand with my problem
regard
Re: how get 12c data when windows 7 crashed [message #659179 is a reply to message #659178] Mon, 09 January 2017 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What do you mean by "my windows 7 have crashed"?

Re: how get 12c data when windows 7 crashed [message #659180 is a reply to message #659179] Mon, 09 January 2017 01:30 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
dear my window 7 crash
need new installation but i wait for recover oracle 12c data
windows new installation in c:\>
and old oracle 12c installation in d:\>
pleas guide me how i get oracle data and install new oracle 12c

hope now you understand with my problem
regadr
Re: how get 12c data when windows 7 crashed [message #659181 is a reply to message #659180] Mon, 09 January 2017 01:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Reinstall Oracle and use oradim to create a new Oracle instance service and start it.


Re: how get 12c data when windows 7 crashed [message #659182 is a reply to message #659181] Mon, 09 January 2017 01:43 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
but dear before installation not format D:\> drive
Re: how get 12c data when windows 7 crashed [message #659184 is a reply to message #659182] Mon, 09 January 2017 01:56 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
If your D: drive is your only copy of the database, no, I would not advise formatting it. Your posts are not clear, but it sounds as though you have re-installed Windows on your C: drive. Is that correct? And can Windows see your D: drive, with all the database files?
Re: how get 12c data when windows 7 crashed [message #659185 is a reply to message #659182] Mon, 09 January 2017 01:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Surely not if you have your database on it, but remove all Oracle files (but database ones).

Re: how get 12c data when windows 7 crashed [message #659186 is a reply to message #659185] Mon, 09 January 2017 02:21 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
please guide me which file and folder i save and copy for new installation
regard
Re: how get 12c data when windows 7 crashed [message #659187 is a reply to message #659186] Mon, 09 January 2017 02:27 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I see that you have raised this question on the Oracle forums too.

If you followed a default installation and database creation, your database is in d:\...something...\oradata. That is what you need to preserve. But you can ignore all that: just install Oracle again, into a different directory. Assuming, of course, that you have already re-installed Windows.
Re: how get 12c data when windows 7 crashed [message #659189 is a reply to message #659187] Mon, 09 January 2017 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Also preserve d:\...something...\database to keep database configuration and password files.

Re: how get 12c data when windows 7 crashed [message #659190 is a reply to message #659189] Mon, 09 January 2017 03:15 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
this is my d:\> drive path D:\app\OracleHomeUser1
Re: how get 12c data when windows 7 crashed [message #659191 is a reply to message #659190] Mon, 09 January 2017 03:20 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Cnme on, man. Do you have a directory named oradata or not?
Re: how get 12c data when windows 7 crashed [message #659192 is a reply to message #659191] Mon, 09 January 2017 03:35 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
yes dear
D:\app\OracleHomeUser1
have two folder
oradata
product

see path D:\app\OracleHomeUser1\oradata
D:\app\OracleHomeUser1\oradata\orcl\pdborcl
D:\app\OracleHomeUser1\oradata\orcl\pdbseed

these all folder have DBF file




Re: how get 12c data when windows 7 crashed [message #659193 is a reply to message #659192] Mon, 09 January 2017 03:38 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
So are you now capable of following instructions? Make sure that you save the contents of the directories that MC and I have told you to save, then you can delete everything and re-install.

This is like getting blood out of a stone.
Re: how get 12c data when windows 7 crashed [message #659194 is a reply to message #659193] Mon, 09 January 2017 03:48 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
yes dear i wait for your instructions
pleas guide me step by step
regard
Re: how get 12c data when windows 7 crashed [message #659195 is a reply to message #659194] Mon, 09 January 2017 03:51 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
mfahimaamirgmailcom wrote on Mon, 09 January 2017 09:48
yes dear i wait for your instructions
pleas guide me step by step
regard
You will be waiting forever. I have no intention of repeating the instructions I have already given you.

Re: how get 12c data when windows 7 crashed [message #659196 is a reply to message #659195] Mon, 09 January 2017 03:59 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
dear please guide me which file i save and replace with new oracle 12c file
Re: how get 12c data when windows 7 crashed [message #659197 is a reply to message #659196] Mon, 09 January 2017 04:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

John Watson wrote on Mon, 09 January 2017 09:27
...
your database is in d:\...something...\oradata. That is what you need to preserve.
...
Michel Cadot wrote on Mon, 09 January 2017 10:03

Also preserve d:\...something...\database to keep database configuration and password files.
All what is not saved/preserved have to be replaced.

Re: how get 12c data when windows 7 crashed [message #659268 is a reply to message #659197] Tue, 10 January 2017 22:58 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
dear
my oracle 12c database name is PDBORCl
Re: how get 12c data when windows 7 crashed [message #659280 is a reply to message #659268] Wed, 11 January 2017 06:39 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
mfahimaamirgmailcom wrote on Tue, 10 January 2017 22:58
dear
my oracle 12c database name is PDBORCl
Just as an aside ...

I understand that English is not your native language, but please allow me to further your understanding of a subtle point.

The usage "Dear Fred" or "Dear Sir" is used as a salutation in formal written communications. "Dear Fred" when you know the recipient's name is Fred, and "Dear Sir", when you don't know the name of the recipient, as in a letter to a company and not a known individual. And in these cases, it is only used in the opening salutation.

But other uses of "dear", as in "yes dear" are considered terms of endearment .. as in how I address my wife. I often address my wife as "dear". I'd never address a colleague as "dear". In fact, if I were to address a female colleague as "dear", I'd be open to a workplace harassment complaint.
Re: how get 12c data when windows 7 crashed [message #659281 is a reply to message #659178] Wed, 11 January 2017 06:54 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
OP is also working this question on OTN - https://community.oracle.com/thread/4005307
Re: how get 12c data when windows 7 crashed [message #659303 is a reply to message #659281] Wed, 11 January 2017 14:58 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Ed

The usage "Dear Fred" ...
Would you prefer if he called you a deer instead? /forum/fa/917/0/

Re: how get 12c data when windows 7 crashed [message #659305 is a reply to message #659303] Thu, 12 January 2017 02:19 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
i format D:\ drive and install new oracle 12 and import last dump file and feed 2 days data
Re: how get 12c data when windows 7 crashed [message #659308 is a reply to message #659305] Thu, 12 January 2017 06:49 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
mfahimaamirgmailcom wrote on Thu, 12 January 2017 02:19
i format D:\ drive and install new oracle 12 and import last dump file and feed 2 days data
Who said anything about formatting the D: drive? Why did you think you needed to do that? You already showed that your data was there and was intact.
Exactly what do you mean by "import last dump file and feed 2 days data?

So, do you have your database back?

[Updated on: Thu, 12 January 2017 06:49]

Report message to a moderator

Re: how get 12c data when windows 7 crashed [message #661237 is a reply to message #659178] Sat, 11 March 2017 14:05 Go to previous messageGo to next message
billgates
Messages: 19
Registered: March 2017
Junior Member
just copy folders ORADATA and DATABASE and then reinstall database in different drive
Re: how get 12c data when windows 7 crashed [message #661239 is a reply to message #661237] Sat, 11 March 2017 14:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just don't do what you say which is by the way meaningless.
What does mean "reinstall database"?

[Updated on: Sat, 11 March 2017 14:11]

Report message to a moderator

Re: how get 12c data when windows 7 crashed [message #661247 is a reply to message #661237] Sun, 12 March 2017 15:07 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
billgates wrote on Sat, 11 March 2017 14:05
just copy folders ORADATA and DATABASE and then reinstall database in different drive
I doubt the OP has been waiting for the last two months for this ..... look at the dates on the messages.
Previous Topic: incremental 0/1 and full backup status
Next Topic: Create backup
Goto Forum:
  


Current Time: Thu Mar 28 08:05:45 CDT 2024