Problem with duplicating database on same server to with a different DB_NAME using RMAN
I am trying to duplicate my newly upgraded 19c database to another instance with a different name on the same server. I follow the exact steps which was listed in KB Using RMAN to Safely Clone a Database onto the Same Storage as the Source Database (Doc ID 2289796.1)
I am duplicating from a backup copy of the target database.
However the duplication job keep getting stuck as the database wasn't able to start back up after the memory script shut the database down.
One very weird thing is when I initiate the command duplicate target database to <AUX> from RMAN, the memory script will try to rename my clone database to the target DB. This is why I suspect the database failed to start up because the target database is still running on the same server.