Database Startup Fails with ORA-01113, ORA-01110 errors (Doc ID 146039.1)

rongshiyuan發表於2014-01-09
DatabaseAIError
Database Startup Fails with ORA-01113, ORA-01110 errors (Doc ID 146039.1)

***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-1068872/，如需轉載，請註明出處，否則將追究法律責任。
                                            


                




相關文章