Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

Error ORA-10458: Standby Database Requires Recovery?

|| || 20

Error ORA-10458: Standby Database Requires Recovery?
Stechies

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 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 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

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

  • Nitesh Singh
    17 Mar 2015 3:10 pm

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

  • Sonia Barwar
    17 Mar 2015 3:10 pm

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

  • 17 Mar 2015 3:11 pm

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

  • Nitesh Singh
    17 Mar 2015 3:11 pm

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

  • 17 Mar 2015 3:13 pm

    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

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

  • 17 Mar 2015 3:14 pm

    Database restored successfully. It is a consistent backup.

  • 17 Mar 2015 3:15 pm

    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

    I tried but same error.

  • 17 Mar 2015 3:17 pm

    Did you try recover database command?

  • 17 Mar 2015 3:17 pm

    Yes I tried.

  • 17 Mar 2015 3:17 pm

    What is alert logs saying when you enable mrp?

  • 17 Mar 2015 3:18 pm

    Alter database recover managed standby database command.

  • 17 Mar 2015 3:18 pm

     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

    In stand by side alert log file is not updating.

  • 17 Mar 2015 3:19 pm

    In that case you're missing something.

  • 17 Mar 2015 3:20 pm

    What I missed plz let me know?


Advertisement
Advertisement
Advertisement