oracle ora16433,recovering migrated database

Hello

using windows server 2003, X86 based system,oracle version we are using is 10.2.0.1.0

i have a linux 5.7 installed on a 32 bit machine with oracle 11.2.0.1.0

the migration process was done using rman

SQL> select status from v$instance;

STATUS

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

MOUNTED

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1:

'/home/oracle/u01/app/oracle/oradata/linux/data_files/O1_MF_SYSTEM_82N5T2TV_.DBF

'

SQL> recover database;

ORA-00283: recovery session canceled due to errors

ORA-16433: The database must be opened in read/write mode.

*

*

pfile of the migrated database

# Please change the values of the following parameters:

allowresetlogs_corruption = true

control_files = '/home/oracle/u01/app/oracle/oradata/linux/control_files/linux_control01.ctl','/home/oracle/u01/app/oracle/oradata/linux/control_files/linux_control02.ctl'

db_create_file_dest = '/home/oracle/u01/app/oracle/oradata/linux/data_files/'

db_recovery_file_dest = '/home/oracle/u01/app/oracle/oradata/linux/fra/'

db_recovery_file_dest_size = 2147483648

audit_file_dest = '/home/oracle/u01/app/oracle/oradata/linux/adump/'

core_dump_dest = '/home/oracle/u01/app/oracle/oradata/linux/cdump/'

db_name = "LINUX"

# Please review the values of the following parameters:

__shared_pool_size = 88080384

__large_pool_size = 4194304

__java_pool_size = 4194304

__streams_pool_size = 8388608

__db_cache_size = 390070272

remote_login_passwordfile= "EXCLUSIVE"

db_domain = ""

# The values of the following parameters are from source database:

processes = 150

shared_pool_size = 88080384

large_pool_size = 4194304

java_pool_size = 4194304

"newly.ora" 61L, 1523C

*

*

SQL> recover database using backup controlfile until cancel;

ORA-00283: recovery session canceled due to errors

ORA-16433: The database must be opened in read/write mode.

SQL> sho parameter allow

NAME TYPE VALUE

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

allowresetlogs_corruption boolean TRUE

*

*

sql>select HXFIL File_num,substr(HXFNM,1,40) File_name,FHTYP Type,HXERR Validity,

FHSCN SCN, FHTNM TABLESPACE_NAME,FHSTA status ,FHRBA_SEQ Sequence

from X$KCVFH;

FILE_NUM FILE_NAME TYPE VALIDITY SCN TABLESPACE_NAME STATUS SEQUENCE

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

1 /home/oracle/u01/app/oracle/oradata/linu 3 0 *1880106* SYSTEM 8196 1

2 /home/oracle/u01/app/oracle/oradata/linu 3 0 *1880106* UNDO 4 1

3 /home/oracle/u01/app/oracle/oradata/linu 3 0 *1880106* SYSAUX 4 1

4 /home/oracle/u01/app/oracle/oradata/linu 3 0 *1880106* TEST 4 1

please suggest the approach to open the database

thanks in advance

Edited by: 946207 on Aug 21, 2012 10:23 AM

Tagged: