Thanks for replays , I restored controlfile from same backup set ..... And also I tried to duplicate DB, in this case I didn't restored controlfile Oracle do this. Now I thinking about exp imp of DB..... *-----------------* *Tiran* *Best RegardsStay in touch...* On 4 April 2014 16:00, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote: > The issue is not with the missing logfiles. Thats normal, Oracle will > re-create the redo logs. The error 1152 indicates that the file was not > restored from a sufficiently old backup. Sometimes that means you restored > the wrong controlfile and you need to restore an earlier one. > > > On Fri, Apr 4, 2014 at 4:37 AM, Outsider <mufc01666@xxxxxxxxx> wrote: > >> Dear, >> >> I wonder if somebody can help to solve this problem. I opened SR in >> Oracle and after week I got answer like they cannot help me and again they >> ask logs. >> >> I just wanted to restore primary DB to another host to make duplicate of >> that DB. >> I tried with DB duplicate with RMAN and also just restore DB. >> After ALTER DATABASE OPEN RESETLOGS In got a lot errors. >> >> Oracle said that >> >> >> *The data dictionary is corrupt which is the reason we see the ORA-00942 >> errors. * >> >> here what I did.... >> >> >> run { >> ALLOCATE CHANNEL 't11' type 'sbt_tape' >> parms="ENV=(TDPO_OPTFILE=/u01/app/oracle/admin/csrdev1/tsm207/tdpo.opt)"; >> restore controlfile from 'c-517364674-20140323-01'; >> } >> run { >> ALLOCATE CHANNEL 't11' type 'sbt_tape' >> parms="ENV=(TDPO_OPTFILE=/u01/app/oracle/admin/csrdev1/tsm207/tdpo.opt)"; >> SET UNTIL TIME "to_date('03/23/14 4:00:00','mm/dd/yy hh24:mi:ss')"; >> restore database; >> recover database; >> } >> >> *result * >> >> ------------------ >> Finished recover at Mar 27 2014 18:14:59 >> released channel: t11 >> >> RMAN> alter database open resetlogs; >> >> RMAN-00571: =========================================================== >> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== >> RMAN-00571: =========================================================== >> RMAN-03002: failure of alter db command at 03/27/2014 18:17:06 >> ORA-01092: ORACLE instance terminated. Disconnection forced >> ORA-00604: error occurred at recursive SQL level 1 >> ORA-00942: table or view does not exist >> Process ID: 30035 >> Session ID: 19 Serial number: 21 >> RMAN-00571: =========================================================== >> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== >> RMAN-00571: =========================================================== >> ORA-03114: not connected to ORACLE >> RMAN-00571: =========================================================== >> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== >> RMAN-00571: =========================================================== >> RMAN-03002: failure of alter db command at 03/27/2014 18:17:06 >> ORA-01092: ORACLE instance terminated. Disconnection forced >> ORA-00604: error occurred at recursive SQL level 1 >> ORA-00942: table or view does not exist >> Process ID: 30035 >> Session ID: 19 Serial number: 21 >> >> >> *from alert log * >> Full restore complete of datafile 10 >> /u02/app/oracle/oradata/CSRDEV1/datafile/o1_mf_psai_9m8pdd9o_.dbf. Elapsed >> time: 0:03:57 >> checkpoint is 516215190 >> Thu Mar 27 18:13:50 2014 >> Signalling error 1152 for datafile 1! >> Signalling error 1152 for datafile 2! >> Signalling error 1152 for datafile 3! >> Signalling error 1152 for datafile 4! >> Signalling error 1152 for datafile 5! >> Signalling error 1152 for datafile 6! >> Signalling error 1152 for datafile 7! >> Signalling error 1152 for datafile 8! >> Signalling error 1152 for datafile 9! >> Signalling error 1152 for datafile 10! >> Signalling error 1152 for datafile 11! >> Signalling error 1152 for datafile 12! >> Signalling error 1152 for datafile 13! >> Signalling error 1152 for datafile 14! >> Signalling error 1152 for datafile 15! >> Signalling error 1152 for datafile 16! >> Signalling error 1152 for datafile 17! >> Checker run found 1 new persistent data failures >> Thu Mar 27 18:13:51 2014 >> alter database recover datafile list clear >> Completed: alter database recover datafile list clear >> alter database recover datafile list >> 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15 , 16 , 17 >> Completed: alter database recover datafile list >> 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15 , 16 , 17 >> alter database recover if needed >> start until time 'MAR 23 2014 04:00:00' using backup controlfile >> Media Recovery Start >> Serial Media Recovery started >> ORA-279 signalled during: alter database recover if needed >> start until time 'MAR 23 2014 04:00:00' using backup controlfile >> ... >> Thu Mar 27 18:14:23 2014 >> alter database recover logfile >> '/u01/app/oracle/fast_recovery_area/CSRDEV1/archivelog/2014_03_27/o1_mf_1_12348_9m8q395c_.arc' >> Media Recovery Log >> /u01/app/oracle/fast_recovery_area/CSRDEV1/archivelog/2014_03_27/o1_mf_1_12348_9m8q395c_.arc >> ORA-279 signalled during: alter database recover logfile >> '/u01/app/oracle/fast_recovery_area/CSRDEV1/archivelog/2014_03_27/o1_mf_1_12348_9m8q395c_.arc'... >> alter database recover logfile >> '/u01/app/oracle/fast_recovery_area/CSRDEV1/archivelog/2014_03_27/o1_mf_1_12349_9m8q39fz_.arc' >> Media Recovery Log >> /u01/app/oracle/fast_recovery_area/CSRDEV1/archivelog/2014_03_27/o1_mf_1_12349_9m8q39fz_.arc >> ORA-279 signalled during: alter database recover logfile >> '/u01/app/oracle/fast_recovery_area/CSRDEV1/archivelog/2014_03_27/o1_mf_1_12349_9m8q39fz_.arc'... >> Thu Mar 27 18:14:58 2014 >> alter database recover logfile >> '/u01/app/oracle/fast_recovery_area/CSRDEV1/archivelog/2014_03_27/o1_mf_1_12350_9m8q3vbd_.arc' >> Media Recovery Log >> /u01/app/oracle/fast_recovery_area/CSRDEV1/archivelog/2014_03_27/o1_mf_1_12350_9m8q3vbd_.arc >> Incomplete Recovery applied until change 516220911 time 03/23/2014 >> 04:00:10 >> Media Recovery Complete (csrdev1) >> Completed: alter database recover logfile >> '/u01/app/oracle/fast_recovery_area/CSRDEV1/archivelog/2014_03_27/o1_mf_1_12350_9m8q3vbd_.arc' >> >> >> *AND also what I found from trace files* >> >> AND FROM trace file >> >> DDE: Problem Key 'ORA 312' was flood controlled (0x1) (no incident) >> ORA-00312: online log 3 thread 1: >> '/u01/app/oracle/fast_recovery_area/CSRDEV1/onlinelog/o1_mf_3_84vs73jk_.log' >> ORA-27037: unable to obtain file status >> Linux-x86_64 Error: 2: No such file or directory >> Additional information: 3 >> ORA-00312: online log 3 thread 1: >> '/u02/app/oracle/oradata/CSRDEV1/onlinelog/o1_mf_3_84vs738x_.log' >> ORA-27037: unable to obtain file status >> Linux-x86_64 Error: 2: No such file or directory >> Additional information: 3 >> DDE: Problem Key 'ORA 313' was flood controlled (0x1) (no incident) >> ORA-00313: open failed for members of log group 3 of thread 1 >> ORA-00312: online log 3 thread 1: >> '/u01/app/oracle/fast_recovery_area/CSRDEV1/onlinelog/o1_mf_3_84vs73jk_.log' >> ORA-27037: unable to obtain file status >> Linux-x86_64 Error: 2: No such file or directory >> Additional information: 3 >> ORA-00312: online log 3 thread 1: >> '/u02/app/oracle/oradata/CSRDEV1/onlinelog/o1_mf_3_84vs738x_.log' >> ORA-27037: unable to obtain file status >> Linux-x86_64 Error: 2: No such file or directory >> Additional information: 3 >> ORA-00313: open failed for members of log group 3 of thread 1 >> ORA-003 >> >> *I don't understand why the names of online logs are wrong.... the path >> is correct but the names are wrong.....* >> >> Thank you for your time. >> >> *-----------------* >> *Tiran* >> >> *Best Regards Stay in touch...* >> > > > > -- > Andrew W. Kerber > > 'If at first you dont succeed, dont take up skydiving.' >