Sunday, June 15, 2014

1z0-060 Upgrade to Oracle Database 12c - Missing tempfile will be recreated during the database startup

SMON: enabling tx recovery
Errors in file /u01/app/oracle/diag/rdbms/orclcdb/orclcdb/trace/orclcdb_dbw0_3896.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/orclcdb/temp01.dbf'
ORA-27037: unable to obtain file status
Solaris-AMD64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/orclcdb/orclcdb/trace/orclcdb_dbw0_3896.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/orclcdb/temp01.dbf'
File 201 not verified due to error ORA-01157
Re-creating tempfile /u01/app/oracle/oradata/orclcdb/temp01.dbf
Starting background process SMCO
SMCO started with pid=32, OS id=3962