Created a SAN copy of a PROD -> TEST, table alert_log tries to find the old alert log when quering i

Hi,

I have created a SAN copy (block for block) of our PROD db -> TEST db.

Is there a way to change the internal name of the alert log? The file name on disk is correct, but when quering table alert_log I get:

select * from alert_log
              *
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file alert_SPLQPROD.log in BACKGROUND_DUMP not found

SPLQPROD is the name of my PROD db, and TEST is named SPLQTEST.

Is there a way around this? Our monitoring script checks the alert_log table.

Regards