Today when I try to restore the database from the cold backup, I was hit with error ORA-01157: cannot identify/lock data file 4 – see DBWR trace file & ORA-01110: data file 4: ‘/database/u01/app/oracle/oradata/SID/users01.dbf’. Below is the console output of how I solve this problem:

oracle@qhms_scripts> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 – Production on Thu Feb 8 14:54:38 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area  236404368 bytes
Fixed Size                   724624 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 798720 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 11 – see DBWR trace file
ORA-01110: data file 4: ‘/database/u01/app/oracle/oradata/SID/users01.dbf’
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area  236404368 bytes
Fixed Size                   724624 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 798720 bytes
Database mounted.
SQL> alter database datafile  ‘/database/u01/app/oracle/oradata/SID/users01.dbf‘ offline drop;
Database altered.
SQL> alter database open;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area  236404368 bytes
Fixed Size                   724624 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 798720 bytes
Database mounted.
Database opened.
SQL>

Bookmark It

Hide Sites