OraFAQ Forum: Backup & Recovery » It is very urgent help me

Home » RDBMS Server » Backup & Recovery » It is very urgent help me

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: It is very urgent help me [message #123740 is a reply to message #123657]

Tue, 14 June 2005 11:31

limer
Messages: 15
Registered: June 2005
Location: Madrid

Junior Member

hello!

Do you have a backup of control file??. If not I think it could be not possible to recover your database.

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	How to Backup and recover
Next Topic:	Urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 01 02:34:18 CST 2025