ORA-01157: cannot identify/lock data file 6 - see DBWR trace file ORA-01110: data file 6: '/opt/oracle/db02/nms_index.dbf'

Friday, November 1, 2013

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file ORA-01110: data file 6: '/opt/oracle/db02/nms_index.dbf'

SQL> startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1279120 bytes
Variable Size 104860528 bytes
Database Buffers 58720256 bytes
Redo Buffers 2912256 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/opt/oracle/db02/nms_index.dbf'

SQL>
SQL>
SQL> shut abort
ORACLE instance shut down.
SQL>
SQL> startup mount
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1279120 bytes
Variable Size 104860528 bytes
Database Buffers 58720256 bytes
Redo Buffers 2912256 bytes
Database mounted.
SQL> alter database datafile '/opt/oracle/db02/nms_index.dbf' offline drop;

Database altered.

SQL>
SQL>
SQL> shut abort
ORACLE instance shut down.
SQL>
SQL>
SQL> startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1279120 bytes
Variable Size 104860528 bytes
Database Buffers 58720256 bytes
Redo Buffers 2912256 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL>

ANURAG PANDEY

I am Anurag Pandey, working as Cloud Database Architect | Cloud Migration and Modernization Expert .Database Administration and Implementation. Provide technical guidance and work with global team. Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible, Audit, Email - anuragkumarjoy@gmail.com

1 comment:

TestSoftMumbaiFebruary 27, 2014 at 4:10 PM
Hi,

It worked in my case. I tries the below command:
alter database datafile 'C:\TEMP\NC_ITA.DBF' offline drop;

The file NC_ITA.DBF was accidentally deleted.
You need to explain what offline drop does

Thanks and Regards
N Ponpandian
ReplyDelete
Replies

Add comment

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Real World Oracle AI Cloud Database Solutions

Friday, November 1, 2013