Added Datafile on wrong mountpoint in Dataguard

There were two tasks to be done. One was to move the file from incorrect location to correct one for Logical Database. And then register the datafile in the Physical Standby.
>

1)To move the datafile to the correct location in Logical Standby

ALTER DATABASE STOP LOGICAL STANDBY APPLY;

ALTER TABLESPACE ***** OFFLINE NORMAL;

cp /wrong mount point /right mount point

ALTER TABLESPACE ****** RENAME DATAFILE '/old.dbf' TO '/new.dbf';

ALTER TABLESPACE ***** ONLINE;

ALTER DATABASE START LOGICAL STANDBY APPLY;


2)

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL;

alert log:

ORA-01111: name for data file 65 is unknown - rename to correct file
ORA-01110: data file 65: '/UNNAMED00065'
ORA-01157: cannot identify/lock data file 65 - see DBWR trace file

ALTER DATABASE CREATE DATAFILE '/UNNAMED00065' as '/new.dbf';

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;