ORA-01157 Problem Solving

Source: Internet
Author: User
Tags exit dba
Solve the problem ORA-01157 problem how to solve?

Environment: Redhat 9 + Oracle 817
Question: After yesterday's sudden power off, the database was prompted for this error after it was started. The data is not archived, and the data file is also useful. How to recover.

[Oracle@ccdevsvr root]$ SVRMGRL

Oracle Server Manager Release 3.1.7.0.0-production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.4.0-production
With the partitioning option
Jserver Release 8.1.7.4.0-production

Svrmgr> Connect System/manager as Sysdba
Connected.
Svrmgr> Show
Instance Local
Spool off
Timing off
Termout on
Echo off
Stoponerror off
AutoRecovery off
Logsource <default>
Maxdata 20480
Numwidth 10
Charwidth 80
Longwidth 80
Datewidth 9
Labwidth 32
Compatibility NATIVE
Retries Infinite
Server Output off
Autoprint off
Fetchrows Infinite
Appinfo off (usertext:oracle Server Manager)
Svrmgr> Startup
Ora-01081:cannot start already-running Oracle-shut it down
svrmgr> shutdown Immediate
Ora-01109:database not open
Database dismounted.
ORACLE instance shut down.
Svrmgr> Startup
ORACLE instance started.
Total System Global area 73109664 bytes
Fixed Size 73888 bytes
Variable Size 56086528 bytes
Database buffers 16777216 bytes
Redo buffers 172032 bytes
Database mounted.
Ora-01157:cannot identify/lock data file 10-see DBWR trace file
Ora-01110:data file: '/home/oracle/dwbx_wmstat.dbf '
Svrmgr>

[Oracle@ccdevsvr oracle]$ pwd
/home/oracle
[Oracle@ccdevsvr oracle]$ ll *.dbf
-RWXRWXRWX 1 Oracle DBA 209723392 Nov 11:47 iwbx_wmindx.dbf
-RWXRWXRWX 1 Oracle DBA 104865792 DEC 1 09:35 test.dbf
[Oracle@ccdevsvr oracle]$
Does the database archive mode?
in Mount State:

Archived words:
Sql>alter database DataFile ' I:\ORADATA\EXAMORA\TEST01. DBF ' offline;
Non-archived words:
Sql>alter database DataFile ' I:\ORADATA\EXAMORA\TEST01. DBF ' offline drop;

And then in
Sql>alter database open;

[Oracle@ccdevsvr root]$ Cd/home/oracle
[Oracle@ccdevsvr oracle]$ ll *.dbf
-RWXRWXRWX 1 Oracle DBA 209723392 Nov 11:47 iwbx_wmindx.dbf
-RWXRWXRWX 1 Oracle DBA 104865792 DEC 1 09:35 test.dbf
[Oracle@ccdevsvr oracle]$ exit
Exit
Svrmgr> select Sysdate from dual;
Sysdate
---------
01-dec-04
1 row selected.

Svrmgr> ALTER DATABASE Open
2>;
ALTER DATABASE Open
*
Ora-01157:cannot identify/lock data file 10-see DBWR trace file
Ora-01110:data file: '/home/oracle/dwbx_wmstat.dbf '
svrmgr> ALTER DATABASE datafile '/HOME/ORACLE/DWBX_WMSTAT.DBF ' offline drop;
Statement processed.
svrmgr> ALTER DATABASE open;
Statement processed.
Svrmgr>


Large-Scale Price Reduction
  • 59% Max. and 23% Avg.
  • Price Reduction for Core Products
  • Price Reduction in Multiple Regions
undefined. /
Connect with us on Discord
  • Secure, anonymous group chat without disturbance
  • Stay updated on campaigns, new products, and more
  • Support for all your questions
undefined. /
Free Tier
  • Start free from ECS to Big Data
  • Get Started in 3 Simple Steps
  • Try ECS t5 1C1G
undefined. /

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.