Hey there,
Trying to move a database from Windows to Linux.
Source:
OS: Windows 2003 server 32bits
Oracle Version: 10.2.0.3.0 -- select version from v$instance
Oracle Platform: Microsoft Windows IA (32-bit) -- select platform_name from v$database
Destination:
OS: Oracle Linux 5.11 64bits
Oracle Version: 10.2.0.5.0
Oracle Platform: Linux x86 64-bit
I'm trying to use RMAN's convert database and following this guide. So far I managed to:
- Export my database with convert in the source system.
- Use the transport script to start the database in NOMOUNT on the target system.
- Create the control file on the target system with the converted data files and three log files.
The problem arise when I try to open my database with 'ALTER DATABASE OPEN RESETLOGS'. This is the error I'm getting:
SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
On my alert file I see the following error:
Tue Jun 28 18:58:39 CST 2016
ALTER DATABASE OPEN RESETLOGS
Tue Jun 28 18:58:39 CST 2016
Errors in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_5065.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/ORCL/redo01a.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Now the file /u01/app/oracle/oradata/ORCL/redo01a.log was create when I created the database and it does exist with a size of 51M. So I'm a bit lost here. No idea what else to do. Any advice is welcome.