Thiago_corporative
asked on
ORA-1122
Hi.
I'm with some problems to start a database in open stage... it's giving ORA-1122. I saw that, possibly, this is a datafile problem.
Could soumeone help?
I put the alert here to you guys see more information
alert.txt
I'm with some problems to start a database in open stage... it's giving ORA-1122. I saw that, possibly, this is a datafile problem.
Could soumeone help?
I put the alert here to you guys see more information
alert.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>alter database close normal
This is usually done as a 2nd part of a backup script that had already closed the database with abort or immediate, then opened in restricted mode to allow instance recovery to happen to make the database consistent. This is fine to do this.
What I do see is possibly you created a new controlfile for a new instance and your paths weren't created properly?
Were you cloning a database, or is this recovery of an existing database?
This is usually done as a 2nd part of a backup script that had already closed the database with abort or immediate, then opened in restricted mode to allow instance recovery to happen to make the database consistent. This is fine to do this.
What I do see is possibly you created a new controlfile for a new instance and your paths weren't created properly?
Were you cloning a database, or is this recovery of an existing database?
// *Cause: The information in this file is inconsistent with information
// from the control file. See accompanying message for reason.
// *Action: Make certain that the db files and control files are the correct // files for this database.