Oracle 8i Data Recovery Reg

2 views
Skip to first unread message

babi

unread,
Sep 1, 2009, 4:23:20 AM9/1/09
to Oracle in World
Hello,


I am using Oracle8i Release 8.1.6.0.0 - Production.

My hard disk failed.

only backup of dbf files and control file is available. i.e. I
installed oracle folder in second hard disk. I do not have a copy of
logical backup. Can I restore the data using these files without
using logical back up ?

Thanks & Regards
Babi




Amr Rashed

unread,
Sep 1, 2009, 6:21:14 AM9/1/09
to oracle-...@googlegroups.com
yes of course u can 
u can install a fresh installtion  and replace thethe files with hthe one sin ur backup 
--
eng. aMr  rAsHeD
       DBA
Mashreq for commercial investment,
Smouha, industrial Zone 14th May Bridge
P.O. Box 80 Sidi Gaber Alexandria, Egypt,

E-Mail: amr.r...@gmail.com
Mob NO.: 002 0105223274
TEl: 002 03 4211668
Fax: 002 03 4211883

Joseph Gichamba

unread,
Sep 1, 2009, 8:06:47 AM9/1/09
to oracle-...@googlegroups.com
yeah..its possible. js put your old data files from backup in the
second disk and make sure
they are referenced correctly(data file name & path) in the control
file of the new db.

Mogale Madisha

unread,
Sep 1, 2009, 8:34:02 AM9/1/09
to oracle-...@googlegroups.com
yes , you can. Just recreate the pfile and startup the db in nomount.
Create the spfile from spfile and shutdown the db. start it up using
the spfile.

--
Regards,
Kenneth

ORACLE DATABASE ADMINISTRATOR
TEL : 0861 RDC RDC
FAX : 0861 RDC FAX
email 1: mogo...@gmail.com
email 2: kenn...@rdc.co.za

Reply all
Reply to author
Forward
0 new messages