-
I couldn't able to connect to this database due to this error so recovering is not possible.
-
Connect locally using svrmgrl (or sqlplus 9i). Mount the database. Recover it.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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'
-
yes that's where you have to recover the datafile. I hope you have the archive logs to recover.
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 SANJAY_G
Connect locally using svrmgrl (or sqlplus 9i). Mount the database. Recover it.
Jeff Hunter
-
My database is in NOARCHIEVELOG mode and more over I am doing cold backup.
-
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
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
|