Difference between spfile and init.ora file

Oracle pfile vs spfile: Difference and Comparison. It is used for database startup. It is also called INIT file. It is a text file which contains all the main parameters for the database startup. This can be edited using notepad or Vi editor 5. The general format for the pfile is INIT. But it can be in different names. If your pfile is in different directory you can specify the file name using following format. We can create pfile from spfile using following command.

Spfile is used for database startup. We do not edit this file using an editor as it is a binary file and may get corrupted and which may lead to your database instance not starting rather it is altered by using the alter system query. The changes come into effect after running the Alter system query and we do not need to restart the database. By default our database uses pfile to start we can change that and create a spfile from a pfile or init.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Oracle DB : What is difference between spfile and init. Ask Question. Asked 6 years, 7 months ago.

Active 6 years, 7 months ago. Viewed 16k times. Malatesh Malatesh 1, 6 6 gold badges 24 24 silver badges 37 37 bronze badges. Add a comment. Active Oldest Votes. Here is a sample init. If we want to start a remote db we need a local pfile. RMAN Recovery manager which helps in data backup recovery process does not keep the backup of pfile or init. We do not need a local copy in case of spfile if we need to start a remote database.

As this file is maintained by the server the parameters are validated before they are accepted. RMAN keeps the backup of spfile. Thanks for the explanation. The difference between init. However for init.