-
help me regarding " database file 1 failed verification check" error
hi all
I tried to exceute the
1.Alter index ORDERLINEITEMJOURNAL_IX1 rebuild;
2.Alter index ORDERLINEITEMJOURNAL_PK rebuild;
on my database on the database server which is at remote location ,so i am accessing it through putty.During the second alter indexd command my server got hanged so i closed the the session(putty) and when again i tried to start the oracle, i got the following error
SQL> startup
ORACLE instance started.
Total System Global Area 227455136 bytes
Fixed Size 73888 bytes
Variable Size 58576896 bytes
Database Buffers 167772160 bytes
Redo Buffers 1032192 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/data1/seek01/system01.dbf'
ORA-01207: file is more recent than controlfile - old controlfile
can anybody please help me to solve this error. is there any recovery option? so that i am able to start the oracle as it was working fine befor running the alter index command. It's very urgent.
Regards
pandurang
-
why was the database down - what did you do to get it into that state
-
oerr ORA 1207
01207, 00000, "file is more recent than controlfile - old controlfile"
// *Cause: The controlfile change sequence number in the data file is
// greater than the number in the controlfile. This implies that
// the wrong controlfile is being used. Note that repeatedly causing
// this error can make it stop happening without correcting the real
// problem. Every attempt to open the database will advance the
// controlfile change sequence number until it is great enough.
// *Action: Use the current controlfile or do backup controlfile recovery to
// make the controlfile current. Be sure to follow all restrictions
// on doing a backup controlfile recovery.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
actually the database not got down the whole server got down as we are facing the problem from last few days. please tell me the solution how to recover from those errors
-
you need to explain what you did to get it into that state (and dont say nothing)
-
What's your backup/recovery strategy?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
as i am not able to recover the current database but i have backup of whole database so i am thinking to create the new database eventhough i have current database on my database server.
Whether it will crash my oracle if i will create new database in addition to database that i have not able to recover
-
Shall we understand that you have a cold backup?
Is it good enough for you?
Have you previously tested your recovery strategy?
You can have multiple Oracle instances in your box pointing to the same ORACLE_HOME, no problem.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
can you will tell me steps how to create the new database in oracle which is on linux through command mode as i am not able to access the UI mode of the linux.can i able to create the new sid for this new database through the command mode. please help me it is really critical
regards
pandurang
-
i have the backup as dmp file of my whole database
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|