restore rman backup from windows to linux

Posted by Arsalan on Jan 30, 2022; 8:03am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/restore-rman-backup-from-windows-to-linux-tp10600.html


Hello Arsalan,

I want to restore rman backup from window to oracle linux i face some problem

source db 12c R1
window 2016

target db 12c R1
Oracle Linux 7.9 version

----------------------

After mount database then i run below command


{
        set newname for datafile 1 to '/u01/app/oracle/Oradata/Afgprod/Datafiles/SYSTEM01.DBF';
        set newname for datafile 2 to '/u01/app/oracle/Oradata/Afgprod/Datafiles/SYSAUX01.DBF';
        set newname for datafile 3 to '/u01/app/oracle/Oradata/Afgprod/Datafiles/UNDOTBS01.DBF';
        set newname for datafile 4 to '/u01/app/oracle/Oradata/Afgprod/Datafiles/USERS01.DBF';
        set newname for datafile 5 to '/u01/app/oracle/Oradata/Afgprod/Datafiles/AUDIT_TRAIL01.DBF';
        set newname for datafile 6 to '/u01/app/oracle/Oradata/Afgprod/Datafiles/IRD_BASE01.DBF';
        set newname for datafile 7 to '/u01/app/oracle/Oradata/Afgprod/Datafiles/IRD_DATA_LARGE01.DBF';
        set newname for datafile 8 to '/u01/app/oracle/Oradata/Afgprod/Datafiles/IRD_INDEXES01.DBF';
        set newname for datafile 9 to '/u01/app/oracle/Oradata/Afgprod/Datafiles/GGS_DATA01.DBF';
        set newname for datafile 10 to '/u01/app/oracle/Oradata/Afgprod/Datafiles/UNDOTBS2.DBF';
        set newname for datafile 11 to  '/u01/app/oracle/Oradata/Afgprod/Datafiles/IRD_DATA_LARGE02.DBF';
        restore database;
        switch datafile all;
        recover database;
}
-----------------------------------------------------------------------
give below error



archived log for thread 1 with sequence 132847 is already on disk as file /u01/app/oracle/Recovery_area/Afgprod/AFGPROD/archivelog/2022_01_12/o1_mf_1_132847_jxxdxmdv_.arc
archived log file name=/u01/app/oracle/Recovery_area/Afgprod/AFGPROD/archivelog/2022_01_12/o1_mf_1_132847_jxxdxmdv_.arc thread=1 sequence=132847
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/12/2022 15:57:50
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/u01/app/oracle/Recovery_area/Afgprod/AFGPROD/archivelog/2022_01_12/o1_mf_1_132847_jxxdxmdv_.arc'
ORA-00283: recovery session canceled due to errors
ORA-10562: Error occurred while applying redo to data block (file# 1, block# 11675)
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: '/u01/app/oracle/Oradata/Afgprod/Datafiles/SYSTEM01.DBF'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 5834
ORA-00600: internal error code, arguments: [ktbrcl:NOOP incompat_opt], [196], [], [], [], [], [], [], [], [], [], []