Home » RDBMS Server » Server Administration » startup problem pla help me out
startup problem pla help me out [message #301198] Tue, 19 February 2008 09:11 Go to next message
mandygrewalindia
Messages: 14
Registered: February 2008
Location: india
Junior Member
hi frnds
when i start databse it is mounted but not opened..
it shows following errors..
ora-01122 database file 1 failed verification check
ora-01110 datafile 1='<location of dat datafile'>
ora-01207 file is more recent than control file -old contrl file

intially it was nt getting mounted now it gets mounted but not opened.
Re: startup problem pla help me out [message #301200 is a reply to message #301198] Tue, 19 February 2008 09:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/?SQ=9ba0b232b4fc2bee21e38cab925106bf&t=search&srch=file+is+more+recent+than+control+file&btn_ submit=Search&field=all&forum_limiter=&search_logic=AND&sort_order=DESC&author=

Regards
Michel
startup problem pla help me out [message #301201 is a reply to message #301198] Tue, 19 February 2008 09:18 Go to previous messageGo to next message
mandygrewalindia
Messages: 14
Registered: February 2008
Location: india
Junior Member
i tried in this manner also
>alter database backup controlfile to trace;
database altered
>shutdown immediate

now what do i check in udump for trace files i read dis solution also:
(" You can find the file in userdump dest. Open the trace file and edit for neccesary changes")
what do i edit..

further steps: cudnt nt do since i dont know what to edit in tace files

3. Startup the database in nomount state.

SQL > startup nomoun

4. Run the controlfile script create in step 2

SQL > @cfile.sql

5. Recover the db

SQL > recover database using backup controlfile

6. Open the database.

SQL > alter database open;

Re: startup problem pla help me out [message #301214 is a reply to message #301198] Tue, 19 February 2008 10:36 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:
cudnt nt do since i dont know what to edit in tace files


you dont need to edit any thing .
check for the location of the trace file generated with the result of alter database backup controlfile..statement.

copy and paste the create controlfile statement into your sqlplus prompt.
then
alter database mount;
alter database open;

Previous Topic: Check free extents for TABLE and Index Segment
Next Topic: DML(s) related to transactions
Goto Forum:
  


Current Time: Tue Dec 06 08:36:54 CST 2016

Total time taken to generate the page: 0.06868 seconds