how to open db when sysaux datafile lost
Rasheed_Jun 28 2011 — edited Jun 29 2011How to open database from the following case ..
SQL> startup
ORACLE instance started.
Total System Global Area 1048576000 bytes
Fixed Size 1223344 bytes
Variable Size 281019728 bytes
Database Buffers 759169024 bytes
Redo Buffers 7163904 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '/home/durai/rp/data/sysaux.dbf'
SQL> alter database datafile '/home/durai/rp/data/sysaux.dbf' offline drop;
alter database datafile '/home/durai/rp/data/sysaux.dbf' offline drop
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Alertlog
[durai@training ~]$ tail /home/durai/rp/bdump/alert_rp.log
alter database datafile '/home/durai/rp/data/sysaux.dbf' offline drop
Wed Jun 29 08:23:22 2011
Errors in file /home/durai/rp/bdump/rp_dbw0_10186.trc:
ORA-00600: internal error code, arguments: [3600], [2], [14], [], [], [], [], []Wed Jun 29 08:23:22 2011
Errors in file /home/durai/rp/bdump/rp_dbw0_10186.trc:
ORA-00600: internal error code, arguments: [3600], [2], [14], [], [], [], [], []Wed Jun 29 08:23:22 2011
DBW0: terminating instance due to error 471
Instance terminated by DBW0, pid = 10186