I have 3 database 1 primary and two standby, The storage of one the standby was abruptly removed without shutting down the database.

Few Days later the storage was returned, I restart the whole database server, and while trying to open my database instance(alter database open) I get the errors below:

ERROR at line 1: ORA-10458: standby database requires recovery ORA-01196: file 1 is inconsistent due to a failed media recovery session ORA-01110: data file 1: '+DATA/drstby/datafile/system.306.918916853'

I tried to do "recover database;" and I get another error:

RMAN-03002: failure of recover command at 12/15/2017 17:11:50 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 62585 and starting SCN of 16625729961

Please what can I do.

Note: the database in question has the following FRA ASM RMAN BACKUPS. THANKS

closed as off-topic by hot2use, Marco, Colin 't Hart, Philᵀᴹ, Max Vernon Jul 31 '18 at 15:54

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – hot2use, Marco, Colin 't Hart, Philᵀᴹ, Max Vernon
If this question can be reworded to fit the rules in the help center, please edit the question.


Looks like you need to restore archivelogs. If you have them backed up to tape, you may need to do something like:

  allocate channel ch1 type 'sbt_tape' parms
  restore archivelog from scn 16625729961 until scn 999999999;

Replace the until scn 999999999 with an appropriate scn from your primary database.

Not the answer you're looking for? Browse other questions tagged or ask your own question.