-
startup failed , ora-1122
did a startup. got the below
ORA-01122: database file 7 failed verification check
ORA-01110: data file 7: '/oracle/SID/data10/myfile/myfile.data1'
ORA-01207: file is more recent than controlfile - old controlfile
select * from v$recover_file;
got 15 rows selected.
what can i do to get it started up?
-
You're going to have to do some media recovery as its likely your datafiles and controlfiles are out of sync:
start the DB up using the current controlfile
Apply media recovery if the current archive logs are available
Or
restore a backup of the controlfile and perform media recovery using the USING BACKUP CONTROLFILE COMMAND
-
more importantly what cause this error? did you have some sort of failure? abnomral termination of instance? what happened?
I'm stmontgo and I approve of this message
-
its abnormal termination of instance. it went down just like that.
checked my alert file, lots of ora-600 before it went down
-
Originally posted by yls177
its abnormal termination of instance. it went down just like that.
checked my alert file, lots of ora-600 before it went down
Don't waste time here, raise a iTAR.
Amar
"There is a difference between knowing the path and walking the path."
-
mine is on sap environment. still can raise itar?
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
|