Link to home
Start Free TrialLog in
Avatar of bdrmki
bdrmki

asked on

How to recover oracle database using datafile and temporary file

Hi, I have been working on small oracle system then my hard disk is totally damaged, fortunatly I have backup from my forms and reports in a flash disk,  and I have only datafile and temporary file, after install oracle on another hard disk How to recover the database from those tow files?
Avatar of abuckheit
abuckheit

you needd the control file(s).
Avatar of johnsone
The control file is not completely necessary, as long as you have all the datafiles, you can recreate the control file.

Do you have all the datafiles?  What kind of backup (hot or cold)?
Avatar of bdrmki

ASKER

Hi Johnsone,
Unfortunatly Ididn't take any type of backup for my database I only have the datafile and temporary file because I created them in specific location  using
 Create Tablespace <tsname>
Datafile <'path'>
Size 100M
Autoextend      ON
Next            5M
Maxsize      Unlimited
Default storage
      (Initial      100K
       Next            500K
       Minextents      1
       Maxextents      999
       Pctincrease      10
      )
Online
Permanent;
and
Create Tablespace <tsname>
Datafile <'path'>
Size 50M
Autoextend      ON
Next            5M
Maxsize      Unlimited
Online
Temporary;
Options
ASKER CERTIFIED SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Forced accept.

Computer101
EE Admin