<div>
It is not possible to recover the AUXILIERY tablespace.<br />
Because it is extension of the SYSTEM tablespace.<br />
So you have to fix the clone script and to have corerct one.
</div>


<div>
Unfortunately recloning the database isn't an option as this has moved as it has only just become apparent after 3 weeks. data has moved on in the meantime. Import/export remains an option but looking at a quicker solution if possible?<br />
<br />

</div>


<div>
Unfortuntaely mine did not recover using the recover statement . errrors are listed below.<br />
<br />
SQL&gt; alter database recover datafile 8<br />
&nbsp; 2 &nbsp;/<br />
alter database recover datafile 8<br />
*<br />
ERROR at line 1:<br />
ORA-00283: recovery session canceled due to errors<br />
ORA-00600: internal error code, arguments: [krhpfh_03-1202], [fno =], [8],<br />
[fhcrt =], [658583574], [cptim =], [0], []<br />
ORA-01110: data file 8: 'E:\ORADB\RBLIVE\RBLIVESYS<wbr />AUX01.DBF'<wbr /><br />

</div>


<div>
Did you instal same version and same upgrade of Oracle as the original DB?<br />
<br />
Also think about Import way.
</div>


<div>
<div class="content wysiwyg-content">
Moving a database from one server to another an incorrect clone script has been used. The only issue being is that the sysaux tablespace has been created by oracle but is not pointing at the datafile. an alter databse statement below is successful<br />
alter database rename file 'C:\ORACLE\PRODUCT\10.2.0\<wbr />DB_1\DATAB<wbr />ASE\MISSIN<wbr />G00003' .to 'C:\ORACLE\PRODUCT\10.2.0\<wbr />ORADATA\OR<wbr />CLTEST\SYS<wbr />AUX01.DBF'<wbr /><br />
<br />
However when the datafile is recovered using :-<br />
SQL&gt; RECOVER DATAFILE 3<br />
ORA-00283: recovery session canceled due to errors<br />
ORA-00600: internal error code, arguments: [krhpfh_03-1202], [fno =], [3],<br />
[fhcrt =], [567697849], [cptim =], [0], []<br />
ORA-01110: data file 3:<br />
'C:\ORACLE\PRODUCT\10.2.0\<wbr />ORADATA\OR<wbr />CLTEST\SYS<wbr />AUX01.DBF'<wbr /><br />
<br />
It errors out with the errors as seen above
</div>
</div>


Moving a database from one server to another an incorrect clone script has been used. The only issue being is that the sysaux tablespace has been created by oracle but is not pointing at the datafile. an alter databse statement below is successful
alter database rename file 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\MISSING00003' .to 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLTEST\SYSAUX01.DBF'

However when the datafile is recovered using :-
SQL> RECOVER DATAFILE 3
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [krhpfh_03-1202], [fno =], [3],
[fhcrt =], [567697849], [cptim =], [0], []
ORA-01110: data file 3:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLTEST\SYSAUX01.DBF'

It errors out with the errors as seen above

Sysaux datafile not created on clone script on 10g database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.