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?
you needd the control file(s).
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)?
Do you have all the datafiles? What kind of backup (hot or cold)?
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin