HomeOracleOracle Error ORA-19527: physical standby redo log must be renamed

Oracle Error ORA-19527: physical standby redo log must be renamed

Oracle Error Message

ORA-19527: physical standby redo log must be renamed

Reason for the Error

An attempt was made to clear redo log at a physical standby database. Clearing an OMF redo log will not work unless DB_CREATE_FILE_DEST, DB_CREATE_ONLINE_LOG_DEST_n or DB_RECOVERY_FILE_DEST parameter is specified. Clearing a non-OMF (or user-defined) redo log file will not work unless the LOG_FILE_NAME_CONVERT initialization parameter is set.

Solution

Set DB_CREATE_FILE_DEST, DB_CREATE_ONLINE_LOG_DEST_n or DB_RECOVERY_FILE_DEST parameter for OMF redo log files and re-issue the operation that attempted to clear redo log. Set LOG_FILE_NAME_CONVERT parameter for non-OMF redo log files and re-issue the operation that attempted to clear redo log.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...