Register Login

Error ORA-10458: Standby Database Requires Recovery?

Updated May 18, 2018

Hello DBA Experts,

Can anyone help me to solve the following query faced me:

SQL> startup mount;
ORACLE instance started.
Total System Global Area 1140850688 bytes
Fixed Size 2923584 bytes
Variable Size 419431360 bytes
Database Buffers 704643072 bytes
Redo Buffers 13852672 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1:
'/u01/app/oracle/oradata/DG11G_STBY/datafile/o1_mf_system_bjl6rb9q_.dbf'

Thanks in Advance!

Read Here at Oracle Interview Questions to Get More Questions with Explanation like this one.


Comments

  • 17 Mar 2015 4:07 pm ravikumar Best Answer

    As per you mentioned that alter database open; in the standby server is not allowed. You make sure that every standby server is in read only mode becoz none of the user doesnot access. If any user is uses that database then it is not a standby server. 

     

    This issue (standby database requires recovery) i.e, requires recovery for standby database is caused due to one of the datafiles in-consistent and to make standby database read only mode. Here all the datafiles should be consistent and bring the standby database read only mode.

    The error is occuring becoz MRP is still running in the database which keeps the media recover on.

    Resolution- Stop the media recovery and then place the database in readonly mode by using "SQL>recover managed standy databse cancel;"

    Then "SQL>alter database open read only;"

    After that if you want to start the MRP by execute the statement

    "SQL>recover managed standby database disconnect from session using current logfile;"

    Check with this procedure... -- Rockz

  • 17 Mar 2015 3:12 pm Abhijeet Mudgal Helpful Answer

    startup nomount;
    SQL> ORACLE instance started.

    Total System Global Area 1140850688 bytes
    Fixed Size 2923584 bytes
    Variable Size 419431360 bytes
    Database Buffers 704643072 bytes
    Redo Buffers 13852672 bytes
    SQL> alter database mount standby database;

    Database altered.

    SQL> alter database open read only;
    alter database open read only
    *
    ERROR at line 1:
    ORA-10458: standby database requires recovery
    ORA-01152: file 1 was not restored from a sufficiently old backup
    ORA-01110: data file 1:
    '/u01/app/oracle/oradata/DG11G_STBY/datafile/o1_mf_system_bjl6rb9q_.dbf'

  • 17 Mar 2015 3:09 pm Sugandh

    May I know why shutdown this done for the db, what operation is done in before?

  • 17 Mar 2015 3:10 pm Nitesh Singh

    You are trying to open a standby database that too without converting it ?

  • 17 Mar 2015 3:10 pm Sonia Barwar

    Are you trying to open the standby database in open mode?

  • 17 Mar 2015 3:11 pm Abhijeet Mudgal

    I am creating datagaurd it is mounted but not opening in read only mode.

  • 17 Mar 2015 3:11 pm Nitesh Singh

    Use alter database open readonly; not what you're giving.

  • 17 Mar 2015 3:13 pm Sugandh

    Either the backup file is not restored properly or this db is not in archivelog mode so that the logs are not being applied to your db when you are trying to open it. And check if you have enough redo logs. Other way around could be you need to restore the file from the backup again.

  • 17 Mar 2015 3:14 pm Sugandh

    If you have used consistent backup then just recover database command may help you to overcome this issue.

  • 17 Mar 2015 3:14 pm Abhijeet Mudgal

    Database restored successfully. It is a consistent backup.

  • 17 Mar 2015 3:15 pm Sugandh

    At Mount put db in recovery mode for some time looks it need some fuzzy clearance then try with readonly open.

  • 17 Mar 2015 3:15 pm Abhijeet Mudgal

    I tried but same error.

  • 17 Mar 2015 3:17 pm Sugandh

    Did you try recover database command?

  • 17 Mar 2015 3:17 pm Abhijeet Mudgal

    Yes I tried.

  • 17 Mar 2015 3:17 pm Sugandh

    What is alert logs saying when you enable mrp?

  • 17 Mar 2015 3:18 pm Abhijeet Mudgal

    Alter database recover managed standby database command.

  • 17 Mar 2015 3:18 pm Sugandh

     I am telling to do a normal recover database command once you reach mount phase. Not the alter database recover managed one.

  • 17 Mar 2015 3:19 pm Abhijeet Mudgal

    In stand by side alert log file is not updating.

  • 17 Mar 2015 3:19 pm Chandan Singh Parihar

    In that case you're missing something.

  • 17 Mar 2015 3:20 pm Abhijeet Mudgal

    What I missed plz let me know?


×