How to recover from lost or missing database parameter files pfile or spfile by admin. Recover database issue while missing spfile or pfile an oracle instances characteristics are established by parameter specified within the initialization parameter file. Here you will get answers about question related to pfile and spfile which one is recommended and why location. Pfile can make the situation easier to solve, but if you dont have a textbased pfile or the pfile deviates from the current setting, you can use rman to solve. Asm 11gr2 instance is unable to start due to asm spfile is missing. Managing initialization parameters using a server parameter file. Create spfile on asm from pfile on filesystem grepora. I am still searching on how to do that cause in reality i would prefer my db to start from spfile. The shared server architecture enables a database server to allow many user processes to share very few server processes, so the number of users that can be supported is increased. Lost prameter file in oracle database psquare technologies. How to fix a broken asm spfile, held within asm rants. This post explains the steps required to recover when the parameter files are lost. If we were trying to change parameters in an unfamiliar database that was handed over from other dba, we have to figure it out whether the database started with spfile or pfile. The dispatcher directs multiple incoming network session requests to a.
Suppose you dont have any type of rman or autobackup also. How to restore lost spfile in oracle dbaclass dbaclass. I want to create pfile from spfile oracle\product\11. With shared server, many user processes connect to a dispatcher. What if you lost both spfile and pfile of the instance when it is up and running. The initialization parameters are either stored in pfile or spfile. How to check whether oracle instance is started using. Asm 11gr2 instance is unable to start due to asm spfile is. A pfile is static, client side text file, that can be easily updated whenever required. Oracle database startup issues part 2 spfile cannot be.
The parameter files are read at instance startup time to get instance specific characteristics. Is there a view where i can check whether an instance had been started using a pfile or an spfile. Another thing that is not usual and everytime i do, someone be surprised. When several datafiles are missing restore from local backups. How to recover from lost or missing database parameter. We will recreate the scenario by deleting the spfile. Moreover, if pfile is used, you have to know the location of pfile. The spfile is backed up automatically by rman when you back up. Recover database issue while missing spfile or pfile. This chapter describes how to configure dispatcher. But in reality i would like to have the spfile back. I basically had the pfile with me in my backup documents so i started the database using the pfile.