Databases Reference
In-Depth Information
A look at the related
alert<SID>.log
file, will show information about the missing
datafiles too.
ALTER DATABASE OPEN
Tue Jun 2 10:13:05 2009
Errors in file /u01/app/oracle/admin/alpha/bdump/alpha_dbw0_28543.trc:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u01/app/oracle/oradata/alpha/system01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Tue Jun 2 10:13:05 2009
Errors in file /u01/app/oracle/admin/alpha/bdump/alpha_dbw0_28543.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '/u01/app/oracle/oradata/alpha/undotbs01.
dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Tue Jun 2 10:13:05 2009
Errors in file /u01/app/oracle/admin/alpha/bdump/alpha_dbw0_28543.trc:
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '/u01/app/oracle/oradata/alpha/sysaux01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-1157 signalled during: ALTER DATABASE OPEN...
Three critical datafiles are missing, so it is not possible to open the database unless
these files are completely recovered.
A critical database file cannot be set offline, and the database cannot be opened until
the datafile is completely recovered.
Search WWH ::
Custom Search