Anyone has a link, cuse i cant find nothing about that product
Printable View
Anyone has a link, cuse i cant find nothing about that product
Its not a product, nor is it available to the General Public. It is a proprietary tool that Oracle Consulting uses to recover data.
In other words, call Oracle.Quote:
Originally posted by marist89
Its not a product, nor is it available to the General Public. It is a proprietary tool that Oracle Consulting uses to recover data.
MH
Oh my! Oh my... that was a Chaos!! Why on earth was that production db, not put on archive mode?
Leassons to learn :(
Sam
I know, there is a simple rule to follow:
if the cost of (disk for archivelog mode + tape backup) >
cost of lost of data then backup like a mad man baby!!
It's a client database. And i done a lot of errors on production database, but never in hell i have and will drop a tablespace by errors without backup.
SITUATION:
1. tablespace is dropped yesterday(it is a data tablespace, not temp or rbs or system).
2. not in archivelog mode.
3. no backup exept full export dated 15 august..
4. the datafile is not deleted on the os.
5. The tablespace did not have ddl statement.
SOLUTION:
1.Take a cold backup, with a backup controlfile to trace and add the datafile dropped in it.
2.Create a new instance on a new machine.
3.take the system datafile + the dropped tablespace datafile.
4.open resetlogs.
Think it will work?
[Edited by steeve123 on 10-04-2002 at 03:22 PM]
Of course it will not work!
Your tablespace was dropped, so what's the point of this whole rescue scenario? Your backup controlfile to trace will still result in controlfile without the dropped tablespace. It has been dropped, remember? So it is not recorded in your current controlfile any more and there will be no trace of it in any kind of backup controlfile. So your steps 2., 3. and 4. are superflous, you'll ended with axactly the same redundant database as you allready have - without the dropped tablespace.
What does #3 mean? Take them out to lunch? Offline?Quote:
Originally posted by steeve123
SOLUTION:
1.Take a cold backup, with a backup controlfile to trace.
2.Create a new instance on a new machine.
3.take the system datafile + the dropped tablespace datafile.
4.open resetlogs.
Think it will work?
Why do you have to go to a new machine?
Why isn't there a step 5? "Put database in archivelog mode."
Why don't you call Oracle for support as has been recommended several times now?
If you "REALLY" want the data and you have enough $$$$$, then you can recover the data. All you need to do is: Contact Oracle Support.
Few years ago, Oracle Corpn told us $1500 per day work for recovering the data file when we did not have correct backup file.
It all depends upon the money you are willing to spend.
:) Is key entry an option :)
MH