Home » RDBMS Server » Backup & Recovery » datbase not opened (merged)
datbase not opened (merged) [message #341963] Wed, 20 August 2008 22:38 Go to next message
shahzad-ul-hasan
Messages: 634
Registered: August 2002
Senior Member
Dear
i am facing problem that my data base is in mount state abut not opened. it will gives me the following error. that conrtol file has older than newer. when i replace these files
TMP1ORCL.ora
USR1ORCL.ORA
CTl1ORCL.Ora
it will only gives me this error.
that USR1ORCL has not the reset LOG.
pls help . i have not successed in getting backup of my all applications.
SVRmgr30
connect internal/oracle
connected.
startup
...
...
...
...
datbase monuted.
C:\orant\database\USR1ORCL.ORA Failed
.

advised.
regards
Shahzad

Re: Database mount [message #341970 is a reply to message #341963] Wed, 20 August 2008 23:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I hope you have accepted the sad reality, if you do not have good backups & tested & documented restoration procedure that all you have is an obsolete paperweight.
datbase not opened [message #342299 is a reply to message #341963] Thu, 21 August 2008 23:43 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 634
Registered: August 2002
Senior Member
Dear
i am facing problem that my data base is in mount state abut not opened. it will gives me the following error. that conrtol file has older than newer. when i replace these files
TMP1ORCL.ora
USR1ORCL.ORA
CTl1ORCL.Ora
it will only gives me this error.
that USR1ORCL has not the reset LOG.
pls help . i have not successed in getting backup of my all applications.
SVRmgr30
connect internal/oracle
connected.
startup
...
...
datbase mounted.
ORA-01110: data file 4: 'C:\orant\database\USR1ORCL.ORA'
ORA-01207: file is more recent than controlfile - old controlfile

.

advised.
regards
Shahzad
Re: datbase not opened [message #342303 is a reply to message #342299] Thu, 21 August 2008 23:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

Yes, you have a problem.
Do you adequate backups & documented & tested restoration procedures?

If so, proceed.
If not, you've lost the DB & I wish you the best.
Re: datbase not opened [message #342309 is a reply to message #342299] Fri, 22 August 2008 00:20 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Don't start a new topic for the same question.

Regards
Michel
Previous Topic: Error while config RMAN
Next Topic: accidentally deleted data file
Goto Forum:
  


Current Time: Mon Nov 25 23:09:21 CST 2024