Shulou(Shulou.com)06/01 Report--

Corrupted file or missing date file:

Operation flow

1 、 shutdown immediate

2 、 startup mount

3. Recover datafile'd:\'

4 、 alter database open

C:\ Documents and Settings\ Administrator > sqlplus / nolog

SQL*Plus: Release 10.2.0.1.0-Production on Wednesday May 29 11:38:24 2019

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL > conn / as sysdba

Connected.

SQL > shutdown immediate

ORA-01109: the database is not open

The database has been uninstalled.

The ORACLE routine has been closed.

SQL > startup mount

The ORACLE routine has been started.

Total System Global Area 1.7834E+10 bytes

Fixed Size 2232320 bytes

Variable Size 961114112 bytes

Database Buffers 1.6861E+10 bytes

Redo Buffers 9732096 bytes

The database is loaded.

SQL > recover datafile'd:\'

ORA-01179: file d:\ does not exist

SQL > recover datafile'D:\ oracle\ product\ 10.2.0\ oradata\ orcl\ UNDOTBS01.DBF'

Complete the media recovery.

SQL > alter database open

Alter database open

*

An error occurred on line 1:

ORA-01113: file 4 requires media recovery

ORA-01110: data file 4: d:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ ORCL\ USERS01.DBF'

SQL > recover datafile'D:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ ORCL\ USERS01.DBF'

Complete the media recovery.

SQL > alter database open

Alter database open

*

An error occurred on line 1:

ORA-01113: file 5 requires media recovery

ORA-01110: data file 5: d:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ ORCL\ EXAMPLE01.DBF'

SQL > recover datafile'D:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ ORCL\ EXAMPLE01.DBF'

Complete the media recovery.

SQL > alter database open

The database has changed.

SQL > exit

From Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production

With the Partitioning, OLAP and Data Mining options disconnected

C:\ Documents and Settings\ Administrator > sqlplus

SQL*Plus: Release 10.2.0.1.0-Production on Wednesday May 29 11:42:35 2019

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Please enter a user name: ecology

Enter the password:

Connect to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production

With the Partitioning, OLAP and Data Mining options

SQL >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.