Recreating Controlfile With New Database Name Fails ORA-01503_ 109502.1

rongshiyuan發表於2014-01-09
DatabaseAI
Recreating Controlfile With New Database Name Fails With ORA-01503, ORA-01161 And ORA-01110 (Doc ID 109502.1)

***Checked for relevance on 16-Jan-2012***
    
	
	
  • 
		fact: Oracle Server - Enterprise Edition
		
  • 
			symptom: Recreating controlfile with new database name fails
			
  • 
				symptom: ORA-01503: CREATE CONTROLFILE failed
				
  • 
					symptom: ORA-01161: database name %s in file header does not match given 
name of %s
					
  • 
						symptom: ORA-01110: data file %s: '%s'
						
  • 
							cause: Missing SET in command CREATE CONTROLFILE DATABASE  
RESETLOGS NOARCHIVELOG
						
    • 

							

fix:

To create the new controlfile for the new database you must use the word 'SET'  
in the CREATE CONTROLFILE COMMAND. The SET DATABASE command is what enables the 
changes to the name of the database.    

The correct syntax is:

CREATE CONTROLFILE SET DATABASE "newdbname" RESETLOGS NOARCHIVELOG




							

								
							


                                                            

                    

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


                




相關文章