Home » RDBMS Server » Backup & Recovery » Recovering a lost database (Oracel 9i)
Recovering a lost database [message #422896] Mon, 21 September 2009 02:17 Go to next message
sumswap
Messages: 3
Registered: September 2009
Location: India
Junior Member
hi friends,
due to a hard disk crash, i lost my oracle 9i database. i succeefully recovered the following files from the failed hard disk.

REDO01.LOG, CWMLIT~1.DBF, DRSYS01.DBF, EXAMPL~1.DBF, INDX01.DBF, ODM01.DBF, SYSTEM01.DBF, TOOLS01.DBF, UNDOTB~1.DBF, USERS01.DBF,
XDB01.DBF

i am having an important personal database and i think that is stored in the system database file which is in the above list. kindly help me to recover my lost data.

Suman C S, Kochi.
Re: Recovering a lost database [message #423182 is a reply to message #422896] Tue, 22 September 2009 07:48 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
REDO01.LOG, CWMLIT~1.DBF, DRSYS01.DBF, EXAMPL~1.DBF, INDX01.DBF, ODM01.DBF, SYSTEM01.DBF, TOOLS01.DBF, UNDOTB~1.DBF, USERS01.DBF,
XDB01.DBF


Quote:
i think that is stored in the system database file which is in the above list


Your not sure in which tablespace your database has been stored. If it's System Tablespace corrupt you can't recover your database.

Thanks

[Updated on: Tue, 22 September 2009 07:55] by Moderator

Report message to a moderator

Re: Recovering a lost database [message #423344 is a reply to message #422896] Wed, 23 September 2009 09:04 Go to previous messageGo to next message
sumswap
Messages: 3
Registered: September 2009
Location: India
Junior Member
dear Babu,
Yes, it is in the system tablespace and that file "SYSTEM01.DBF" is intact. now, can i recover the database from that file?. if yes, how?
suman
Re: Recovering a lost database [message #423769 is a reply to message #423344] Sun, 27 September 2009 23:40 Go to previous message
sumswap
Messages: 3
Registered: September 2009
Location: India
Junior Member
hi Babu,
i have not taken the backup from Oracle. Only thing i have is the below mentioned files, which i have successfully copied from the failed hard disk using the DOS command "copy *.* (source) *.*(destination).

Now i have taken the following steps. In a new hard disk, i installed Oracle in E: and created a database with the name "SUM" exactly like that existed in the old crashed hard disk. Now i copied the recovered files, i.e.CONTROL01.CTL,CONTROL02.CTL,CONTROL03.CTL,
CWMLITE01.DBF,
DRSYS01.DBF,
EXAMPLE01.DBF,
INDX01.DBF,
ODM01.DBF,
REDO01.LOG,REDO02.LOG,
SYSTEM01.DBF,
TOOLS01.DBF,
UNDOTBS01.DBF,
USERS01.DBF,
XDB01.DBF
into E:\oracle\oradata\sum. In the above files, REDO02.LOG is corrupted and it shows a size lesser than REDO01.LOG.

Now i opened the Enterprise Manager and mounted the database "SUM" successfully. But when i tried to Open the database, it shows the error "ORA-00327:log 2 of thread 1, physical size less than needed"."ORA-00312: online log 2 thread 1: E:\ORACLE\ORADATA\SUM\REDO02.LOG".

please help.

suman
Previous Topic: ORA-01034: Oracle Not Available - I know what I did, but I don't know how to fix it
Next Topic: having problem when i take rman backup
Goto Forum:
  


Current Time: Sat Sep 24 23:09:24 CDT 2016

Total time taken to generate the page: 0.04522 seconds