OraFAQ Forum: Backup & Recovery » lost sysaux datafile (merged)

Home » RDBMS Server » Backup & Recovery » lost sysaux datafile (merged)

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

lost sysaux datafile (merged) [message #637982]

Sun, 31 May 2015 12:58

dba2015
Messages: 4
Registered: May 2015
Location: iran

Junior Member

hi
how to open database when all datafile belong to sysaux tablespace is drop from os.
oracle is 10.2.0.4

SQL> startup migrate
ORACLE instance started.

Total System Global Area 145643680 bytes
Fixed Size 1877836 bytes
Variable Size 163582984 bytes
Database Buffers 36776216 bytes
Redo Buffers 5406144 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '/u01/oracle/oradata/orcl/sysaux01.dbf'

Report message to a moderator

Re: lost sysaux datafile [message #637984 is a reply to message #637982]

Sun, 31 May 2015 13:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

First you restore the database from backups & then you open it.

Report message to a moderator

Re: lost sysaux datafile [message #637985 is a reply to message #637982]

Sun, 31 May 2015 13:01

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

--update: message content removed. jw.

[Updated on: Sun, 31 May 2015 14:39]

Report message to a moderator

Re: lost sysaux datafile [message #637986 is a reply to message #637985]

Sun, 31 May 2015 13:07

dba2015
Messages: 4
Registered: May 2015
Location: iran

Junior Member

i have not any backup from datafile or database.

Report message to a moderator

Re: lost sysaux datafile [message #637987 is a reply to message #637986]

Sun, 31 May 2015 13:11

Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Your IP shows your are in Iran.
You say you are in Japan, so you lie and know you do something wrong.

[Updated on: Sun, 31 May 2015 13:13]

Report message to a moderator

Re: lost sysaux datafile [message #637988 is a reply to message #637987]

Sun, 31 May 2015 13:17

dba2015
Messages: 4
Registered: May 2015
Location: iran

Junior Member

I have not any backu from database.

[Updated on: Sun, 31 May 2015 13:29]

Report message to a moderator

Re: deleted sysaux datafile from os [message #637994 is a reply to message #637982]

Sun, 31 May 2015 13:47

Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Now, it is useless to create new topics for the same question, I will merge all of them.

Also, it will be useless to create new accounts for the same reason.

Report message to a moderator

Re: lost sysaux datafile [message #638027 is a reply to message #637987]

Mon, 01 June 2015 09:35

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

Michel Cadot wrote on Sun, 31 May 2015 13:11

Your IP shows your are in Iran.
You say you are in Japan, so you lie and know you do something wrong.

Isn't Iran under export restriction? If so, isn't the very fact that he has a copy of Oracle a violation of law?

Report message to a moderator

Re: lost sysaux datafile [message #638035 is a reply to message #638027]

Mon, 01 June 2015 10:35

Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is why I posted this information.
But Oracle Technology Network License Agreement says:

Quote:

Export Controls
Export laws and regulations of the United States and any other relevant local export laws and regulations apply to the Programs . You agree that such export control laws govern Your use of the Programs (including technical data) and any services deliverables provided under this agreement, and You agree to comply with all such export laws and regulations

which may be interpreted (but I'm not a lawyer) that some local laws may override USA ones and allow someone in some country to help, so I let this topic and account (as we did in the past with all of them).

Report message to a moderator

Re: lost sysaux datafile [message #638045 is a reply to message #638027]

Mon, 01 June 2015 12:18

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

EdStevens wrote on Mon, 01 June 2015 15:35

Michel Cadot wrote on Sun, 31 May 2015 13:11

Your IP shows your are in Iran.
You say you are in Japan, so you lie and know you do something wrong.

Isn't Iran under export restriction? If so, isn't the very fact that he has a copy of Oracle a violation of law?

Ed, there have been a couple of moderator discussions on this. The problem is that while OP's use of Oracle is illegal under US law, it is of course legal under Iranian law. Many OraFAQ members are either American or (like me) want to remain on good terms with the US (and with Larry) so we won't usually help, but the board is not hosted in the US and enforcing US law is not part of its purpose.

Report message to a moderator

. [message #638047 is a reply to message #638045]

Mon, 01 June 2015 12:27

tomson
Messages: 9
Registered: June 2015
Location: a

Junior Member

I can't help people who help someone who illegally use Oracle, this is against OTN license agreement

[Updated on: Mon, 01 June 2015 13:01]

Report message to a moderator

Previous Topic:	Online data backup solution?
Next Topic:	apply archive logs to old incarnation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 25 12:53:58 CST 2025