{"id":1815,"date":"2016-03-27T15:25:26","date_gmt":"2016-03-27T12:25:26","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1815"},"modified":"2016-10-21T15:27:56","modified_gmt":"2016-10-21T12:27:56","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-10500-to-ora-10600","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-10500-to-ora-10600\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-10500 to ORA-10600"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-10500 to ORA-10600<\/strong><\/p>\n

\n
ORA-10546: Cannot perform block media recovery; standby database does not have requisite redo.<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform block media recovery on the standby database when the necessary redo was not available.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Wait until the necessary redo is available and reattempt block media recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10547: Cannot perform block media recovery; standby database is not caught up with primary.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform block media recovery on the standby database up to scn %s, which is greater than the highest scn of %s yet applied at the standby.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recover the standby up to scn %s and reattempt block media recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10548: Cannot perform block media recovery on a read-only plugged-in datafile.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform block media recovery on a read-only plugged-in datafile.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Convert the plugged-in datafile to read\/write and reattempt block media recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10549: Cannot perform block media recovery using a read-only plugged-in backup datafile.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform block media recovery using a backup of a read-only plugged-in datafile.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reattempt block media recovery using a backup taken after the plugged-in datafile has been converted to read\/write.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10553: Incompatible UNTIL CONSISTENT clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0RECOVER UNTIL CONSISTENT required database-level recovery with a backup control file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Omit the UNTIL CONSISTENT clause and retry recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10554: Media recovery failed to bring datafile\u00a0string<\/i>\u00a0to a consistent point<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Media recovery couldn’t recover database to a consistent point due to the specified datafile.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Restore a backup of the datafile.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10560: block type ‘string<\/i>‘<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Report block type for details of another error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See associated error message.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10561: block type ‘string<\/i>‘, data object#\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Report block type and data object number for details of another error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See associated error message.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10562: Error occurred while applying redo to data block (file#\u00a0string<\/i>, block#\u00a0string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0See other errors on error stack.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Investigate why the error occurred and how important is the data block. Media and standby database recovery usually can continue if user allows recovery to corrupt this data block.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10563: Test recovery had to corrupt data block (file#\u00a0string<\/i>, block#\u00a0string<\/i>) in order to proceed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Test recovery completed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. See other messages on error stack for a summary of the result of the test recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10564: tablespace\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Report tablespace name for details of another error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See associated error message.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10565: Another test recovery session is active<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There can only be one test recovery session at any time. Another test recovery session is active.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Wait till the other test recovery session completes.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-10566: Test recovery has used all the memory it can use<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Test recovery tests redo in memory. It can no longer proceed because it has consumed all the memory it can use.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. See other messages on error stack for a summary result of the test recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10567: Redo is inconsistent with data block (file#\u00a0string<\/i>, block#\u00a0string<\/i>, file offset is\u00a0string<\/i>\u00a0bytes)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There are two possible causes of this error: (1) A write issued by Oracle was lost by the underlying OS or storage system. (2) an Oracle internal error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Investigate why the error occurred and how important is the data block. Media and standby database recovery usually can continue if user allows recovery to corrupt this data block.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10568: Failed to allocate recovery state object: out of SGA memory<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0out of SGA memory<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Restart the instance. If problem persists, call Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10570: Test recovery complete<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Test recovery completed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. See other messages on error stack for a summary result of the test recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10571: Test recovery canceled<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User canceled test recovery.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. See other messages on error stack for a summary of the result of the test recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10572: Test recovery canceled due to errors<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0See other errors on the error stack.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0is needed. See other messages on error stack for a summary of the result of the test recovery so far.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10573: Test recovery tested redo from change\u00a0string<\/i>\u00a0to\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This message show the range of test recovery have tested.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is needed. See other messages on error stack.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10574: Test recovery did not corrupt any data block<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This message summarizes test recovery result.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is needed. See other messages on error stack.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10575: Give up restoring recovered datafiles to consistent state: out of memory<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There were not enough memory to restore recovered datafiles to consistent state<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This error is just a warning: You may not be able to open the database with resetlogs immediately after this error. However, you may continue media\/standby recovery, and that may make the datafiles recovered consistent again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10576: Give up restoring recovered datafiles to consistent state: some error occurred<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0See alert file or other errors on the stack for a cause of the problem.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This error is just a warning: You may not be able to open the database with resetlogs immediately after this error. However, you may continue media\/standby recovery, and that may make the datafiles recovered consistent again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10577: Can not invoke test recovery for managed standby database recovery<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Test recovery option is used for managed standby database recovery.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either remove the test recovery option or invoke manual test standby database recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10578: Can not allow corruption for managed standby database recovery<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You used the allow corruption option for managed standby database recovery.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either remove the allow corruption option or invoke manual standby database recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10579: Can not modify control file during test recovery<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0To proceed with recovery, test recovery needs to modify the control file. But test recovery is not allowed to modify control file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. It can only go so far in the redo stream.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10580: Can not modify datafile header during test recovery<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0To proceed with recovery, test recovery needs to modify a datafile header. But test recovery is not allowed to modify datafile headers.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. It can only go so far in the redo stream.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10581: Can not modify redo log header during test recovery<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0To proceed with recovery, test recovery needs to modify a redo log header. But test recovery is not allowed to modify redo log headers.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is needed. Test recovery has ended successfully. It can only go so far in the redo stream.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10582: The control file is not a backup control file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User requested backup control file test recovery, but the control file is not a backup control file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a backup control file, or do not use USING BACKUP CONTROLFILE option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10583: Can not recovery file\u00a0string<\/i>\u00a0renamed as missing during test recovery<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One of the files to be recovered is renamed as missing.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Rename the file to the correct file or offline it.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10584: Can not invoke parallel recovery for test recovery<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Both test recovery and parallel recovery are requested.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop either one of the two recovery options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10585: Test recovery can not apply redo that may modify control file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Test recovery has encountered a special redo that may modify control file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is needed. Test recovery has proceeded successfully as far as it could from its starting point.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10586: Test recovery had to corrupt 1 data block in order to proceed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This message summarizes test recovery result: Oracle may have to corrupt one block in order to apply the range of redo tested.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See alert log for details of the problem.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10587: Invalid count for ALLOW n CORRUPTION option<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The number specified in the ALLOW n CORRUPTION option is too big.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a smaller number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10589: Test recovery had to corrupt\u00a0string<\/i>\u00a0data blocks in order to proceed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This message summarizes test recovery result: Oracle may have to corrupt a number of data blocks as specified in the message in order to apply the range of redo tested.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See alert log for details of the problems.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-10500 to ORA-10600 ORA-10546: Cannot perform block media recovery; standby database does not have requisite redo. Cause:\u00a0An attempt was made to perform block media recovery on the standby database when the necessary redo was not available. Action:\u00a0Wait until the necessary redo is available and reattempt block media…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1815","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-th","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1815","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1815"}],"version-history":[{"count":2,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1815\/revisions"}],"predecessor-version":[{"id":1817,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1815\/revisions\/1817"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1815"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}