ORA-10580: Can not modify datafile header during test recovery

Cause : To proceed with recovery, test recovery needs to modify a datafile header. But test recovery is not allowed to modify datafile headers.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

No action is needed. Test recovery has ended successfully. It can only go so far in the redo stream.

update : 28-04-2017

ORA-10580 - Can not modify datafile header during test recovery
ORA-10580 - Can not modify datafile header during test recovery

  • ora-28109 : the number of related policies has exceeded the limit of 16
  • ora-13424 : the GeoRaster object is not spatially referenced
  • ora-08238 : smsfre: cannot detach from SGA
  • ora-18002 : the specified outline does not exist
  • ora-12213 : TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
  • ora-07801 : slbtpd: invalid exponent
  • ora-23618 : Generation of script string is not complete.
  • ora-24752 : OCI_TRANS_NEW flag must be specified for local transactions
  • ora-06952 : Remote end of the communication issued a forward-reset packet.
  • ora-01917 : user or role 'string' does not exist
  • ora-25189 : illegal ALTER TABLE option for an index-organized table
  • ora-28529 : invalid or missing parameter in Net8 service name definition
  • ora-09838 : removeCallback: failure removing the callback port.
  • ora-30726 : cannot specify referenced column list here
  • ora-03283 : specified datafile string does not exist
  • ora-25300 : Cannot drop buffer for queue with buffered subscribers
  • ora-38770 : FLASHBACK DATABASE failed during recovery.
  • ora-39305 : schema "string" does not exist
  • ora-29348 : You must specify the datafiles to be plugged in
  • ora-08184 : attempting to re-enable Flashback while in Flashback mode
  • ora-38621 : Decision Tree maximum depth setting not between [2, 20]
  • ora-25504 : the system is already in quiesced state
  • ora-23369 : value of "string" argument cannot be null
  • ora-00226 : operation disallowed while alternate control file open
  • ora-38754 : FLASHBACK DATABASE not started; required redo log is not available
  • ora-22926 : specified trim length is greater than current LOB value's length
  • ora-13061 : topology with the name string does not exist
  • ora-07506 : scgrl: $deq unexpected return on lockid string
  • ora-29298 : Character set mismatch
  • ora-16818 : Fast-Start Failover suspended
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.