Database Startup Fails with ORA-01113, ORA-01110

rongshiyuan發表於2012-08-08
DatabaseAI
Database Startup Fails with ORA-01113, ORA-01110 errors [ID 146039.1]轉到底部轉到底部
修改時間:2012-4-27型別:PROBLEM狀態:PUBLISHED優先順序:3
沒有任何註釋註釋 (0)為此文件評級通過電子郵件傳送此文件的連結在新視窗中開啟文件可列印頁
***Checked for relevance on 26-Apr-2012*** 
    


  • fact: Oracle Server - Enterprise Edition

  • symptom: Database startup fails

  • symptom: ORA-01113: file %s needs media recovery

  • symptom: ORA-01110: data file %s: '%s'

  • symptom: Database in archive log mode

  • symptom: Backup available

  • symptom: Datafile requiring media recovery is not needed

  • change: The following command was issued:
SQL> alter database datafile offline;

  • cause: Datafile was taken offline while the database was up. Therefore, the 
database is expecting media recovery for that datafile.




fix:

Do the following only if the datafile requiring recovery is not needed and can be dropped.

1.  Mount the database:
       startup mount pfile=xxxxx.ora

2.  Offline drop the datafile needing media recovery:
       alter database datafile 'full path filename' offline drop;

3.  Open the database:
       alter database open;

4.  Export the objects out of the remaining datafiles belonging to the affected tablespace.

5.  Drop the affected tablespace:
       drop tablespace  including contents;

6.  Recreate the tablespace.

7.  Import the objects into the new tablespace from the export dump file.

Please note that this will only work if the tablespace remains online. If it is taken offline for any reason (eg manually, by ALTER TABLESPACE xxxx OFFLINE 
IMMEDIATE or automatically by Oracle) then you will not be able to bring it back online unless you recover ALL the datafiles.



			
			
                                                            

                    

                                                    來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-740331/，如需轉載，請註明出處，否則將追究法律責任。
                                            


                




相關文章