Home » RDBMS Server » Backup & Recovery » lost sysaux datafile (merged)
lost sysaux datafile (merged) [message #637982] Sun, 31 May 2015 12:58 Go to next message
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'
Re: lost sysaux datafile [message #637984 is a reply to message #637982] Sun, 31 May 2015 13:00 Go to previous messageGo to next message
BlackSwan
Messages: 25856
Registered: January 2009
Location: SoCal
Senior Member
First you restore the database from backups & then you open it.
Re: lost sysaux datafile [message #637985 is a reply to message #637982] Sun, 31 May 2015 13:01 Go to previous messageGo to next message
John Watson
Messages: 7263
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 Go to previous messageGo to next message
dba2015
Messages: 4
Registered: May 2015
Location: iran
Junior Member
i have not any backup from datafile or database.
Re: lost sysaux datafile [message #637987 is a reply to message #637986] Sun, 31 May 2015 13:11 Go to previous messageGo to next message
Michel Cadot
Messages: 65388
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65388
Registered: March 2007
Location: Nanterre, France, http://...
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.



Re: lost sysaux datafile [message #638027 is a reply to message #637987] Mon, 01 June 2015 09:35 Go to previous messageGo to next message
EdStevens
Messages: 902
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?
Re: lost sysaux datafile [message #638035 is a reply to message #638027] Mon, 01 June 2015 10:35 Go to previous messageGo to next message
Michel Cadot
Messages: 65388
Registered: March 2007
Location: Nanterre, France, http://...
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).

Re: lost sysaux datafile [message #638045 is a reply to message #638027] Mon, 01 June 2015 12:18 Go to previous messageGo to next message
John Watson
Messages: 7263
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.
. [message #638047 is a reply to message #638045] Mon, 01 June 2015 12:27 Go to previous message
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:
  


Current Time: Fri Feb 23 05:01:37 CST 2018

Total time taken to generate the page: 0.01614 seconds