No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

eSight V300R010C00SPC200, 300, and 500 Local HA System Software Installation Guide (SUSE Linux + Oracle + Veritas) 10

Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
How Do I Do If Error Code ORA-01113 Is Displayed Because the Oracle Database Fails to be Connected

How Do I Do If Error Code ORA-01113 Is Displayed Because the Oracle Database Fails to be Connected

Question

How do I do if error code ORA-01113 is displayed because the Oracle database fails to be connected?

Symptom

After you log in to the database as the sysdba user and run the alter database open command, the message "ORA-01113: file * needs media recovery" is displayed. However, the database file exists.

> sqlplus / as sysdba 
SQL>alter database open 
ERROR at line 1: 
ORA-01113: file * needs media recovery 
ORA-01110: data file *: 'xxx.dbf'

Answer

  • HA system
    1. Log in to the active server.
    2. Run the hares -state Netlsnr -sys $(hostname) command as the root user to check whether the command output is online. Ensure that the Netlsnr resource is online.
    3. Run the following commands to log in to the Oracle database:
      # su - oracle 
      > sqlplus commonuser/eSight database password as sysdba;
    4. After the login is successful, run the following commands to restore the data files:
      SQL> recover database; 
      SQL> exit
    5. Run the hares -offline Oracle -sys $(hostname) command as the root user to bring the Oracle resource offline, and then run the hares -online Oracle -sys $(hostname) command to bring the Oracle resource online.
  • Single-node system
    1. Run the following commands to log in to the Oracle database:
      # su - oracle 
      > sqlplus / as sysdba;
    2. After the login is successful, run the following commands to restore the data files:
      SQL> recover database;
    3. Run the following commands to restart the database:
      SQL> shutdown immediate 
      SQL> startup 
      SQL> exit
Translation
Download
Updated: 2019-10-30

Document ID: EDOC1100044372

Views: 30590

Downloads: 26

Average rating:
This Document Applies to these Products
Related Version
Related Documents
Share
Previous Next