Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member206552
Active Contributor
2,163

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

Labels in this area