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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |