Hi,
I have a problem with my control files not matched. I checked my alert log and noted the following error message ' ORA-214 signalled during: alter database mount exclusive...'
I did an err on ORA-214 and noted the following:
00214, 00000, "control file '%s' version %s inconsistent with file '%s' version "
// *Cause: Versions of control files and datafiles/logfiles mismatch
// *Action: Use same version of control files and datafiles/logfiles
How do i make both control files equal?
Thankyou for your help.
3 17425
HI
Use a consistent set of control files, datafiles, and redo log files. That is, all the files must be for the same database and from the same time period.
With Regards
Captain
Hi,
I have a problem with my control files not matched. I checked my alert log and noted the following error message ' ORA-214 signalled during: alter database mount exclusive...'
I did an err on ORA-214 and noted the following:
00214, 00000, "control file '%s' version %s inconsistent with file '%s' version "
// *Cause: Versions of control files and datafiles/logfiles mismatch
// *Action: Use same version of control files and datafiles/logfiles
How do i make both control files equal?
Thankyou for your help.
HI
Use a consistent set of control files, datafiles, and redo log files. That is, all the files must be for the same database and from the same time period.
With Regards
Captain
Thanks Captain. The actual problem was: a restore was done from a full system backup by the sys admin. However, after the restore, i noticed that my datafiles and one of my control files were of the latest date and are located in /u10 directory. The redo logs and the other control file are located in /U00 directory. I copied the latest control file from /u10 over to /u00 but the database is now complaining of the following error:
ORA-00314: log 1 of thread 1, expected sequence# 1057 doesn't match 1039
ORA-00312: online log 1 thread 1: '/u00/oradata/FINP01/redo01.log'
I have all my redo logs in /u00. Any ideas on how i can recover/recreate my redo logs? My latest archive log is 1039 and do not have the rest of the logs after that.
Thanks Captain. The actual problem was: a restore was done from a full system backup by the sys admin. However, after the restore, i noticed that my datafiles and one of my control files were of the latest date and are located in /u10 directory. The redo logs and the other control file are located in /U00 directory. I copied the latest control file from /u10 over to /u00 but the database is now complaining of the following error:
ORA-00314: log 1 of thread 1, expected sequence# 1057 doesn't match 1039
ORA-00312: online log 1 thread 1: '/u00/oradata/FINP01/redo01.log'
I have all my redo logs in /u00. Any ideas on how i can recover/recreate my redo logs? My latest archive log is 1039 and do not have the rest of the logs after that.
HI , Try to switch your data fie using RMAN switch command .
cheers
SN
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Shino |
last post by:
Hi,
Can anyone help with this error: "ORA-00904: invalid column name"?
Thanks!
SQL> create view PPFa as
2 SELECT L.UserID AS LecID, U.Name, U.Email, I.IntakeID, S.UserID
AS StudID
3 FROM User_Lecturer L, User_Student S, TBL_Intake I, Users U
4 WHERE L.UserID=S.InitialSupervisorID And L.UserID=U.UserID And
|
by: Galina |
last post by:
Hello
I have created a trigger not to let records with certain fields null
to be inserted into the table:
BEGIN
IF :new.RUL_CODE is null or
:new.FES_UINS_CODE is null or
:new.FES_UIO_CALOCC is null then
RAISE_APPLICATION_ERROR(-20000,'Record is not saved. Check course
record and try to save again.');
end if;
|
by: John |
last post by:
Hi
Right password -> ORA-12154: TNS:Could not resolve service name
wrong password => ORA-01017: invalid username/password; logon denied
Tested on a Windows XP client connecting to Oracle on an AIX server.
Using toad and sqlplusw
Everything working fin connecting to other 8.1.7 Oracle servers on windows
|
by: Cherrish Vaidiyan |
last post by:
Hello all,
A warm Xmas greetings to all. I have a small problem with starting up
the database. Here my strategy.
I have installed Oracle 9i R 2 on Red Hat 9. i created two database on
this system. And the two datasbe is working perfectly. Now i needed
another RH9 system to work on Oracle 9i. So I was guided to copy the
oracle home folder and that the oracle will be up for work. I even got
such a response from Google Group. I copied...
|
by: Brett Baloun |
last post by:
Hello,
I received this error message when I issue the drop statement. We are
using a 9.2.0.3 DB on UNIX OS. I have been able to drop other users
within the same session, but this particular user is causing problems.
I flushed the shared pool, but I still received the same error
message. Thank you in advance for your assistance.
drop user DW_031000 cascade
*
| |
by: Paul Green |
last post by:
What might cause the following behavior?
We have a set of front-end programs accessing an Oracle database on
the server.
Things work fine on our older computers and mostly OK on our new
computers - except one particular program, after being used for a few
minutes gives errors like ORA-12571, ORA-03114.
This suggests the network is disconnected, but tnsping shows the
Oracle DB is still there, and the other programs in the suite still
work.
|
by: smita81 |
last post by:
Hi,
I have a problem while trying to login to toad.
My operating system is WINDOWS XP.
I have Oracle 9i at my system. I installed the Toad into the system.When I start the Toad "Toad Server Login Version 7.5.2.0" pop up opens.
It asks to enter : Database or(user @database)
User/Schema :
Password :
Connection as :,here three options given .They are
NORMAL ,SYSDBA...
|
by: hemantmudaliar |
last post by:
The Trigger is giving following exception
java.sql.SQLException: ORA-04091: table PSCONTENT.VGNASCHANNEL is mutating, trigger/function may not see it ORA-06512: at "PSCONTENT.CHECK_CHANNEL_UNPUBLISH", line 4 ORA-06512: at "PSCONTENT.CHECK_CHANNEL_UNPUBLISH_TR", line 1 ORA-04088: error during execution of trigger ................................
// Trigger
CREATE OR REPLACE TRIGGER check_channel_unpublish_tr
before delete
ON...
|
by: Nitvar |
last post by:
When i am trying to connect to oracle it is giving me these two errors
ORA-12224: TNS:no listener
ORA-01034: ORACLE not available
I am new to oracle ,plz help
I am using solaris 5.6 and oracle 8.0.5 version
I am posting my listener.ora and Tnsname
|
by: nabh4u |
last post by:
HI everyone,
I an getting the following errors when i execute my procedure.
SQL> exec PROCEDURE_NAME
BEGIN PROCEDURE_NAME; END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "PROCEDURE_NAME", line 164
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |