Home » RDBMS Server » Backup & Recovery » Recovering a lost database (Oracel 9i)
| Recovering a lost database [message #422896] |
Mon, 21 September 2009 02:17  |
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  |
babuknb
Messages: 1736
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 |
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 |
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
|
|
|
|
Goto Forum:
Current Time: Thu Apr 25 10:31:53 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
