OraFAQ Forum: Server Administration » important question [merged 3]

Home » RDBMS Server » Server Administration » important question [merged 3]

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

important question [merged 3] [message #524788]

Mon, 26 September 2011 15:10

start84
Messages: 4
Registered: June 2011

Junior Member

if the folder which contain alert_sid deleted
can i made this file again from the database was setup

Report message to a moderator

Re: important question [message #524789 is a reply to message #524788]

Mon, 26 September 2011 15:11

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

>if the folder which contain alert_sid deleted
>can i made this file again from the database was setup
HUH?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: important question [message #524792 is a reply to message #524789]

Mon, 26 September 2011 15:15

start84
Messages: 4
Registered: June 2011

Junior Member

i mean that
the alert_sid file was deleted
can i recover this file since the database were setup

Report message to a moderator

Re: important question [message #524793 is a reply to message #524792]

Mon, 26 September 2011 15:18

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

>i mean that
>the alert_sid file was deleted
>can i recover this file since the database were setup

This is Operating System (OS) issue & has nothing to do with Oracle.
Solution is OS specific.
Since you ignored Posting Guidelines, we don't know your OS & no advice is possible now.

Oracle does not care the file went missing & will create a new file after directory exists again

Report message to a moderator

Re: important question [message #524794 is a reply to message #524793]

Mon, 26 September 2011 15:20

start84
Messages: 4
Registered: June 2011

Junior Member

ok it make new file right

but can i recover what have been written to this file since the db setup

Report message to a moderator

Re: important question [message #524795 is a reply to message #524794]

Mon, 26 September 2011 15:22

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

start84 wrote on Mon, 26 September 2011 13:20

but can i recover what have been written to this file since the db setup

This is Operating System (OS) issue & has nothing to do with Oracle.
Solution is OS specific.
Since you ignored Posting Guidelines, we don't know your OS & no advice is possible now.

Report message to a moderator

Re: important question [message #524799 is a reply to message #524795]

Mon, 26 September 2011 15:44

start84
Messages: 4
Registered: June 2011

Junior Member

BlackSwan wrote on Mon, 26 September 2011 23:22

start84 wrote on Mon, 26 September 2011 13:20

but can i recover what have been written to this file since the db setup

This is Operating System (OS) issue & has nothing to do with Oracle.
Solution is OS specific.
Since you ignored Posting Guidelines, we don't know your OS & no advice is possible now.

my os is windows server 2008 enterprise edition

Report message to a moderator

Re: important question [message #524805 is a reply to message #524799]

Mon, 26 September 2011 23:09

Michel Cadot
Messages: 54238
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Ask your sysadmin to restore the file from his backup.

Regards
Michel

Report message to a moderator

Previous Topic:	table can not shrink
Next Topic:	shrink in manual space managment tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 02:09:39 CDT 2013

Total time taken to generate the page: 0.13611 seconds