I'm working on a logical standby.
I've just realized the applier has stopped with the following error:
ORA-26808: Apply process AS01 died unexpectedly.
ORA-02379: profile PROFILE_XXX already exists
I tried to delete the profile on the standby, but it fails again.
I think the solution for this would be to skip these kind of DDL but I'm not sure.
Any idea how to skip this profile ?
Thanks in advance,
I solved it by running the following command:
ALTER DATABASE START LOGICAL STANDBY APPLY SKIP FAILED TRANSACTION IMMEDIATE;