|Subject:||(S)PFiles in genaral [Oracle 9i] (Newbie)|
|Posted by:||Joachim Hofmann (speich…@freenet.de)|
|Date:||Thu, 10 Nov 2005|
I read on (S)Pfiles in a book, but I think I didnt get this topic.
Some databases seem to have a text pfile including the parameters
and some only have a binary spfile.
(1) What is the main difference between a "normal" init file and a sp-initfile?
(2) How do I decide if the database has to work with a "normal" init file or a
I did a BACKUP of a spfile with a playground database as described in the Backup
and Recovery Manual:
SQL>CREATE PFILE = 'initmydb.ora.bak' FROM SPFILE;
The format seems to be an text excerpt of the binary spfile, but it has not the
same format like a real text pfile.
(3) What is the purpose of this backup file ? Could I restore this in case of
emergency and how would I do this ?