How to resolve ORA-06540: PL/SQL: compilation error ORA-06553: PLS-252: reference to the wrong copy of package STANDARD

There was an issue regarding expired archives did not clear at standby as scheduled and following error was raise.

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of delete command at 07/09/2023 16:00:03

ORA-06540: PL/SQL: compilation error

ORA-06553: PLS-252: reference to the wrong copy of package STANDARD

Recovery Manager complete.

SOLUTION:

1. Restart the standby database

2. Flush shared pool

to clear the whole shared pool you would issue the following command from a privileged user.

ALTER SYSTEM FLUSH SHARED_POOL;