Cross System Restore fails during Controlfile rename
Good Day,
I had a problem last week doing a cross system restore using brtools when it tries to rename the control files
SOURCE : SID1
TARGET : SID2
BR0668I Warnings or errors occurred – you can continue to ignore them or go back to repeat the last action
BR0126I Unattended mode active – continuing processing with default reply ‘cont’
BR0252W Function rename() failed for ‘/oracle/SID2/sapdata1/cntrl/cntrlSID1.dbf -> /oracle/SID2/origlogA/cntrl/cntrlSID2.dbf’ at location BrFileRename-1
BR0253W errno 18: Invalid cross-device link
BR0252W Function rename() failed for ‘/oracle/SID2/origlogA/cntrl/cntrlSID1.dbf -> /oracle/SID2/origlogB/cntrl/cntrlSID2.dbf’ at location BrFileRename-1
BR0253W errno 18: Invalid cross-device link
BR0252W Function rename() failed for ‘/oracle/SID2/origlogB/cntrl/cntrlSID1.dbf -> /oracle/SID2/sapdata1/cntrl/cntrlSID2.dbf’ at location BrFileRename-1
BR0253W errno 18: Invalid cross-device link
The problem is that the rename commands are wrong:
sapdata1 -> origlogA (it should be sapdata1 -> sapdata1)
origlogA -> origlogB (it should be origlogA -> origlogA)
origlogB -> sapdata1 (it should be origlogB -> origlogB)
The system call “rename” does not work across file systems.
As a work around i just changed the location of the control files on the target system (initSID.ora) to be the same as the source system and reran the restore.
BEFORE CHANGE
TARGET
09:14:41 SQL> select * from v$controlfile;
NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
———————————————————————————————————————————-
/oracle/SID2/origlogA/cntrl/cntrlSID2.dbf NO 16384 1258
/oracle/SID2/origlogB/cntrl/cntrlSID2.dbf NO 16384 1258
/oracle/SID2/sapdata1/cntrl/cntrlSID2.dbf NO 16384 1258
SOURCE
NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
———————————————————————————————————————————-
/oracle/SID1/sapdata1/cntrl/cntrlSID1.dbf NO 16384 1258
/oracle/SID1/origlogA/cntrl/cntrlSID1.dbf NO 16384 1258
/oracle/SID1/origlogB/cntrl/cntrlSID1.dbf NO 16384 1258
AFTER CHANGE
TARGET
NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
———————————————————————————————————————————-
/oracle/SID2/sapdata1/cntrl/cntrlSID2.dbf NO 16384 1258
/oracle/SID2/origlogA/cntrl/cntrlSID2.dbf NO 16384 1258
/oracle/SID2/origlogB/cntrl/cntrlSID2.dbf NO 16384 1258