I won't be able to connect using sqlplus and it always says 'oracle shutdown in progress' and when I did the following I got 'File 2 needs media recovery error'.
net start OracleServiceSID /y
sqlplus /nolog
set instance SID
connect /as sysdba
startup pfile'/xx/init.ora'
You can still try to recover. If you are lucky the file can be recovered from online redo logs. If not, your only option is to restore everything from your last cold backup.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Originally posted by sudheer_nm I won't be able to connect using sqlplus and it always says 'oracle shutdown in progress' and when I did the following I got 'File 2 needs media recovery error'.
You all missed an important point.. Sudheer_nm since it says "oracle shutdown in progress" abort the database. Make sure all processes connected with the database are down.
Your database is in No archive log mode so here is what you have to do.
If you've backed up your control file to trace we can get this thing recovered (if your datafile is not phyically corrupted).
Lets try this the easy way first and hopefully that will work.
1.start up the database (yea you'll get the .dbf needs recovery that's ok.
2. issue recover database
3. It's going to ask you for an archive log file. Give it the path of your first redo log file. If it doesn't work give it the next redo log file until there are no log files or your database recovers itself.
More than likely your datafile(s) have gotten out of sync and he's looking for a sequence #.
If this doesn't work then we'll have to get down and dirty with it the most important thing is if you have a control file backed up to trace we can get it recovered.
Oracle it's not just a database it's a lifestyle!
-------------- BTW....You need to get a girlfriend who's last name isn't .jpg
Reply With Quote
Bookmarks