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:
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.