It is very urgent help me [message #123657] |
Tue, 14 June 2005 05:15 |
sponguru_dba
Messages: 51 Registered: May 2005 Location: Bangalore
|
Member |
|
|
Hi All
in my DB i have 7 users(schemas),and 100MB Data,OK
System was crashed...entire C:\ was dameged but D:\ is fine
my sysadministratorhe copied all files which belong my present DB(all DBF,ctl,redolog),with this file how can i get DB back
every day evening we are taking Backups,but this thing happend it 2:30 PM so, if we restore the database we have to lose 1 day data
Datafiles I have:
Index01.dbf
system01.dbf
temp01.dbf
tools01.dbf
undotbs01.dbf
user01.dbf
i want DB back with schemas and all please some body help me
|
|
|
|
Re: It is very urgent help me [message #123751 is a reply to message #123740] |
Tue, 14 June 2005 12:50 |
girish.rohini
Messages: 744 Registered: April 2005 Location: Delhi (India)
|
Senior Member |
|
|
hey
dont loose heart.. in case u r not having control file with u, u can recreate it and then recover database. But remember care has to be taken in recreating control file. If u omit any datafile there, then frankly ur database is gone....
...Girish
|
|
|
Re: It is very urgent help me [message #124490 is a reply to message #123657] |
Sun, 19 June 2005 07:54 |
salmansh
Messages: 14 Registered: June 2005 Location: Al-Khobar
|
Junior Member |
|
|
Hi,
The information provided is not enough. Is the operating system working? where is oracle software installed? What type of backup are taken? how did the system administrator copied the files?
If you can provide the information that someone might be able to help you.
|
|
|