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?
Last Comment
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
