Skip to Content
Author's profile photo Marius Burger

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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.