Get the App
SLTechnology News&Howtos  ›  Database  › 

Ora-01113: file 2 requires media recovery

Shulou Source: shulou.com Published: 2022-06-01 13:20:48 11月16日 Update

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 >

Tags: File data media database week error input password day process user user name missing load Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MySQL Microsoft Shulou Technology MariaDB Xiaomi