I was getting ORA-00119 and ORA-00132 error while startup nomount a new db. SQL> startup nomount ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name ‘LISTENER_PROD’ This is because LOCAL_LISTENER parameter was used in the init file and […]
TROUBLESHOOTING
MRP0: Background Media Recovery terminated with error 1274
We were receiving error like MRPO terminated with error 1274,unnamed file added in standby database, when a new data file was added in the primary. Below is the actual error. Media Recovery Log /uv1019/u341/app/prod/arch/1_68815_799031040.arch File #382 added to control file as ‘UNNAMED00382’ because the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL The file […]