restore rman backup from windows to linux

[Arsalan]

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], [], [], [], [], [], [], [], [], [], []

[ErmanArslansOracleBlog]

Hi,

Probably, this is caused by a redolog related problem.. during recovery I mean..

Here is the fact -> "Redo application is not supported between Linux and Windows except with a standby database. This means that the backup must be a cold (consistent) backup, which requires no redo application! If redo apply is required to recover the database on the new platform it will fail. Using consistent (cold) backup method should be used for duplicating cross platform." *******

Please check the MOS note -> RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support (Doc ID 1079563.1) & Restore From Windows To Linux using RMAN Fails (Doc ID 2003327.1)

[Arsalan]

I want to migrate oracle 12c R1 from window 2016 to oracle linux 7.9
in window i face below error


RMAN> CONVERT DATABASE NEW DATABASE 'afgprod'
2> transport script 'D:\Clone\transport.sql'
3> db_file_name_convert 'D:\app\arsala\Oradata\Afgprod\Datafiles'
4> 'D:\Clone' to platform 'Linux x86 64-bit';

Starting conversion at source at 31-JAN-22
using channel ORA_DISK_1

External table SYS.OPATCH_XML_INV found in the database

Directory SYS.DUMPFILE found in the database
Directory SYS.DUMPFIL found in the database
Directory SYS.P6_DIR found in the database
Directory SYS.OPATCH_INST_DIR found in the database
Directory SYS.OPATCH_SCRIPT_DIR found in the database
Directory SYS.OPATCH_LOG_DIR found in the database
Directory SYS.ORACLE_BASE found in the database
Directory SYS.ORACLE_HOME found in the database
Directory SYS.PREUPG_OUTPUT_DIR found in the database
Directory SYS.QUEST_SOO_UDUMP_DIR found in the database
Directory SYS.QUEST_SOO_CDUMP_DIR found in the database
Directory SYS.QUEST_SOO_BDUMP_DIR found in the database
Directory SYS.BK found in the database
Directory SYS.PREUPGRADE_DIR found in the database
Directory SYS.ORACLE_OCM_CONFIG_DIR2 found in the database
Directory SYS.DUMPBACKUP found in the database
Directory SYS.QUEST_SOO_ADUMP_DIR found in the database
Directory SYS.XML_DIR found in the database
Directory SYS.QUEST_SOO_DIR_1 found in the database
Directory SYS.EXPORT_DIR found in the database
Directory SYS.DUMPBKR found in the database
Directory SYS.ORACLE_OCM_CONFIG_DIR found in the database

User SYS with SYSDBA and SYSOPER privilege found in password file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of conversion at source command on ORA_DISK_1 channel at 01/31/2022 14:43:58
ORA-19926: Database cannot be converted at this time

RMAN>

[ErmanArslansOracleBlog]

Please check your db with "dbms_tdb.check_db" and ensure that there is nothing that can prevent the conversion ..

See -> Cross-Platform Database Migration (across same endian) using RMAN Transportable Database (Doc ID 1401921.1)

[Arsalan]

Hi Arslan,

Just share steps if there are any issue i must solve then go for next  please check.


SQL> alter database open read only;

Database altered.

SQL> set serveroutput on
SQL> declare
  2  v_return boolean;
  3  begin
  4  v_return:=dbms_tdb.check_db('Linux x86 64-bit');
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL> set serveroutput on
SQL> set serveroutput on
SQL> declare
  2  v_return boolean;
  3  begin
  4  v_return:=dbms_tdb.check_db('Linux x86 64-bit');
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL> declare
  2  v_return boolean;
  3  begin
  4  v_return:=dbms_tdb.check_external;
  5  end;
  6  /
The following external tables exist in the database:
SYS.OPATCH_XML_INV
The following directories exist in the database:
SYS.DUMPFILE, SYS.DUMPFIL, SYS.P6_DIR, SYS.OPATCH_INST_DIR,
SYS.OPATCH_SCRIPT_DIR, SYS.OPATCH_LOG_DIR, SYS.ORACLE_BASE, SYS.ORACLE_HOME,
SYS.PREUPG_OUTPUT_DIR, SYS.QUEST_SOO_UDUMP_DIR, SYS.QUEST_SOO_CDUMP_DIR

PL/SQL procedure successfully completed.

[Arsalan]

-after delete external directory still i have errore

RMAN> CONVERT DATABASE NEW DATABASE 'afgprod'
2> transport script 'D:\Clone\transport.sql'
3> db_file_name_convert 'D:\app\arsala\Oradata\Afgprod\Datafiles'
4> 'D:\Clone' to platform 'Linux x86 64-bit';

Starting conversion at source at 01-FEB-22
using channel ORA_DISK_1

User SYS with SYSDBA and SYSOPER privilege found in password file
channel ORA_DISK_1: starting datafile conversion
input datafile file number=00007 name=D:\APP\ARSALA\ORADATA\AFGPROD\DATAFILES\IRD_DATA_LARGE01.DBF
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of conversion at source command on ORA_DISK_1 channel at 02/01/2022 11:14:57
ORA-19699: cannot make copies with compression enabled

[ErmanArslansOracleBlog]

send me the output of rman -> show config  and rman ->show DEVICE TYPE;

[Arsalan]

Sir, the problem was in compress was enable in rman configuration.

after run below command it wok.


CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;


Thanks for support.

[ErmanArslansOracleBlog]

Yes.. Good..
That's why I wanted those rman outputs from you :) I suspected from this.. I was also skeptical that this might be the cause.