Oracle Database case study-Oracle system running failure-Data File status changes to RECOVER due to power failure

1.1 symptom description

Abnormal power failure: the database data file status changes from ONLINE to RECOVER. The system displays the following information:

SQL> select file_name, tablespace_name, online_status from dba_data_files;

FILE_NAME

--------------------------------------------------------------------------------

TABLESPACE_NAME                ONLINE_

------------------------------ -------

/enip/oracle_data/CBS_LOG_IDX

CBS_LOG_IDX                    RECOVER

1.2 possible causes

Abnormal power failure, resulting in abnormal data file status.

1.3 Procedure

1. ToOracleThe machine on which the user logs on to the data.
2. ToSysdbaThe user connects to the database.

% Sqlplus/as sysdba

3. Recover database data files.

SQL> recover datafile '/enip/oracle_data/CBS_LOG_IDX ';

4. Check the status of the database data file.

SQL> select file_name, tablespace_name, online_status from dba_data_files;

The database data file is successfully restored and the system displays the following information:

FILE_NAME

--------------------------------------------------------------------------------

TABLESPACE_NAME                ONLINE_

------------------------------ -------

/enip/oracle_data/CBS_LOG_IDX

CBS_LOG_IDX                    ONLINE

If the problem persists, use the RMAN tool to restore the file.

1.4 references

Use RMAN to restore files:

1. Start the RMAN tool.

% Rman target/

2. Restore the data file.

RMAN> restore datafile'Data file Path';

RMAN> recover datafile;

RMAN> exit;