inconsistent log [message #74503] |
Tue, 21 December 2004 05:34 |
ramya
Messages: 87 Registered: August 2002
|
Member |
|
|
hi frnds
when i am trying to recreate the control file i got these errors.Iam not getting any idea to what to do.
SQL> @ctl
CREATE CONTROLFILE REUSE DATABASE "ZAK2" NORESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01229: data file 67 is inconsistent with logs
ORA-01110: data file 67: '/oradatazak2/oradata/img/img15ZAK2.dbf'
with regards
ramya
|
|
|
|
Re: inconsistent log [message #74508 is a reply to message #74504] |
Tue, 21 December 2004 09:53 |
ramya
Messages: 87 Registered: August 2002
|
Member |
|
|
1)i am using this controlfile script in standby database.If i reset the logs the previous all backups will be invalid?.Is there any way to over come this error
) i have an dought if i am doing the switchover to a primary database to standby which controlfile should be read
with regards
|
|
|
Re: inconsistent log [message #74509 is a reply to message #74508] |
Tue, 21 December 2004 22:40 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
I don't quite understand what you are trying to do. However, you should never recreate the standby database's control file! Create a new standby controlfile (ALTER DATABASE CREATE STANDBY CONTROLFILE ...) on the primary site, and copy it across to the standby site's control file locations.
Best regards.
Frank
|
|
|
Re: inconsistent log [message #74511 is a reply to message #74509] |
Wed, 22 December 2004 05:38 |
ramya
Messages: 87 Registered: August 2002
|
Member |
|
|
hi frank
i done same created standby controlfile and copied but i got erros in recovery so i tried with recreating the controlfiles in standby server as normal database mode(notstandby ) and to try whether its working or no.
with regards
ramya
|
|
|