Database Error Messages

ORA-59600

File file_name has too many mirror copies; needed_mirrors needed, allowed_mirrors allowed
  • file_name: The name of file.
  • needed_mirrors: The total number of mirrors needed, including the file's current mirrors and the requested additional mirrors.
  • allowed_mirrors: The maximum number of mirrors allowed for the file.

Cause

The specified file has too many mirror copies when the change is requested.


Action

To resolve the issue, try one of the following:

  • Retry the command by using a lower target number of copies.
  • If preparing a mirror split, reduce the file's current number of copies and retry the command,
  • If the sum of the file's current number of copies, plus the additional number of copies requested by the command does not exceed the number of mirror copies allowed, then wait for the BALANCE phase of the rebalance operation to complete.

Retry the command. Refer to the error message for the number of mirror copies allowed.