Home » RDBMS Server » Backup & Recovery » cannot start my 10g database on RAC after point in time recovery using RMAN. (Oracle database 10g 10.2.0.3, Solaris X86 64 bits)
cannot start my 10g database on RAC after point in time recovery using RMAN. [message #419858] Tue, 25 August 2009 15:00 Go to next message
alexberi
Messages: 16
Registered: May 2009
Junior Member
I cannot start my 10g database on SUN after point in time recovery using RMAN.
In alert log can see for each datafile errors like :
Errors in file /u01/oracle/admin/ORCL/udump/orcl1_ora_28201.trc:
ORA-01177: data file does not match dictionary - probably old incarnation
ORA-01110: data file 6: '+DGDB/blue_auto_indx01.dbf'
Error 1177 happened during db open, shutting down database
USER: terminating instance due to error 1177

I used next RMAN commands and there was no error during restore:
RMAN> run
2> {
3> set until time ="to_date('08/18/2009 15:00:00','mm/dd/yyyy hh24:mi:ss')";
4> RESTORE DATABASE ;
5> RECOVER DATABASE ;
6> }

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

Somehow I tried to restore controlfile to the time of the recovery:
RMAN> restore controlfile until time = "to_date('08/18/2009 15:00:00','mm/dd/yyyy hh24:mi:ss')" validate;
Starting restore at 25-AUG-09
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/25/2009 19:58:54
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time

When I do list incarnation I see current is more recent than August 08, time when I recoverd the datafiles:
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ORCL 1222317784 PARENT 1 04-JUN-07
2 2 ORCL 1222317784 PARENT 533217 10-AUG-09
3 3 ORCL 1222317784 PARENT 4428470 12-AUG-09
4 4 ORCL 1222317784 CURRENT 5389938 25-AUG-09

Please help me on this.
I have database working with ASM, in archive log mode and with flash recovery area.

Report message to a moderator

Re: cannot start my 10g database on RAC after point in time recovery using RMAN. [message #419859 is a reply to message #419858] Tue, 25 August 2009 15:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
 
01177, 00000, "data file does not match dictionary - probably old incarnation"
// *Cause:  When comparing the control file with the data dictionary after
//          a CREATE CONTROLFILE or OPEN RESETLOGS, it was noted that this
//          datafile was inconsistent with the dictionary. Most likely the
//          file is a backup of a file that was dropped from the database,
//          and the same file number was reused for a new file. It may also
//          be that an incomplete recovery stopped at a time when this file
//          number was used for another datafile.
// *Action: Do a CREATE CONTROLFILE with the correct file or none at all.

Does this accurately describe what has happened to this DB?

Report message to a moderator

Re: cannot start my 10g database on RAC after point in time recovery using RMAN. [message #419862 is a reply to message #419859] Tue, 25 August 2009 15:23 Go to previous messageGo to next message
alexberi
Messages: 16
Registered: May 2009
Junior Member
1) Thanks alot, but you can imagine I saw the error message.
But please tell me how to restore the controlfile.

2) I have control file (and all database files) on a RAC ASM storage with two nodes. Is it not possible to fix the problem without recreate of control file?

3) Also can you tell me what is the problem with my RMAN restore script? I did not get any error when running the script, but ALTER DATABASE OPEN RESETLOGS make my database not to start anymore.

[Updated on: Tue, 25 August 2009 15:28]

Report message to a moderator

Re: cannot start my 10g database on RAC after point in time recovery using RMAN. [message #419864 is a reply to message #419858] Tue, 25 August 2009 15:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I wanted to get a better understanding of your situation.

If wrong actions occur during recovery, a bad situation can be made worse.

I suggest you submit a Service Request with Metalink.

Report message to a moderator

Re: cannot start my 10g database on RAC after point in time recovery using RMAN. [message #419872 is a reply to message #419864] Tue, 25 August 2009 17:11 Go to previous messageGo to next message
alexberi
Messages: 16
Registered: May 2009
Junior Member
Thanks alot.
Can you tell me what is wrong with my restore commands?
Maybe I must include RMAN commands to restore also control file?
Something like:

RMAN> run{
set until time 'Apr 12 2009 11:05:00';
restore controlfile to '/usr/local/oracle/local/rman/recover/ctl/cntrlTEMP.dbf';
replicate controlfile from '/usr/local/oracle/local/rman/recover/ctl/cntrlTEMP.dbf';
sql "alter database mount";
restore database;
recover database;
sql "alter database open resetlogs";
}

Report message to a moderator

Re: cannot start my 10g database on RAC after point in time recovery using RMAN. [message #419882 is a reply to message #419872] Tue, 25 August 2009 22:31 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member
 
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


Post your alert log entry

Report message to a moderator

Re: cannot start my 10g database on RAC after point in time recovery using RMAN. [message #419904 is a reply to message #419882] Wed, 26 August 2009 02:31 Go to previous message
alexberi
Messages: 16
Registered: May 2009
Junior Member
Dictionary check beginning
Tue Aug 25 22:40:02 2009
Errors in file /u01/oracle/admin/ORCL/udump/orcl1_ora_16790.trc:
ORA-01177: data file does not match dictionary - probably old incarnation
ORA-01110: data file 6: '+DGDB/blue_auto_indx01.dbf'
Error 1177 happened during db open, shutting down database
USER: terminating instance due to error 1177
Tue Aug 25 22:40:02 2009
Errors in file /u01/oracle/admin/ORCL/bdump/orcl1_lms1_16396.trc:
ORA-01177: data file does not match dictionary - probably old incarnation
Tue Aug 25 22:40:02 2009
Errors in file /u01/oracle/admin/ORCL/bdump/orcl1_lms2_16409.trc:
ORA-01177: data file does not match dictionary - probably old incarnation
Tue Aug 25 22:40:02 2009
Errors in file /u01/oracle/admin/ORCL/bdump/orcl1_lms3_16413.trc:
ORA-01177: data file does not match dictionary - probably old incarnation
Tue Aug 25 22:40:02 2009
Errors in file /u01/oracle/admin/ORCL/bdump/orcl1_lms0_16379.trc:
ORA-01177: data file does not match dictionary - probably old incarnation
Tue Aug 25 22:40:02 2009
Errors in file /u01/oracle/admin/ORCL/bdump/orcl1_lmd0_16364.trc:
ORA-01177: data file does not match dictionary - probably old incarnation
Instance terminated by USER, pid = 16790
ORA-1092 signalled during: ALTER DATABASE OPEN...
Tue Aug 25 22:42:16 2009

Report message to a moderator

Previous Topic: A special instance recovery
Next Topic: Unable to register database in RMAN
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 03:18:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.