Re: ALTER DATABASE OPEN RESETLOGS
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: Tiran Harutyunyan <mufc01666@xxxxxxxxx>
- Date: Fri, 4 Apr 2014 09:00:58 -0500
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.'
Other related posts:
