This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
info:oracle:spfile_and_pfiles [2013-02-04 22:17] 127.0.0.1 external edit |
info:oracle:spfile_and_pfiles [2013-03-01 20:36] (current) andunix |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Oracle: SPFile and PFiles ====== | ====== Oracle: SPFile and PFiles ====== | ||
- | This page was moved to http://andunix.net/info/oracle/spfile_and_pfiles | + | |
+ | Oracle reads its parameters from a file called " | ||
+ | You can't change it directly as it's a binary file. | ||
+ | Additionally, | ||
+ | |||
+ | ===== Create PFile ===== | ||
+ | |||
+ | To export the SPFiles | ||
+ | |||
+ | <code sql> | ||
+ | CREATE PFILE FROM SPFILE; | ||
+ | </ | ||
+ | |||
+ | It will create a PFile '' | ||
+ | |||
+ | ===== Import PFile ===== | ||
+ | |||
+ | To import the parameters from the PFile to the SPFile, you have to boot the instance from the PFile and the write the SPFile. You have to enter the path to the PFile instead of ${PATH_TO_PFILE}. | ||
+ | |||
+ | <code sql> | ||
+ | SHUTDOWN IMMEDIATE; | ||
+ | STARTUP NOMOUNT PFILE=' | ||
+ | CREATE SPFILE FROM PFILE; | ||
+ | SHUTDOWN IMMEDIATE; | ||
+ | </ | ||
+ | |||
+ | If your PFile is located at ''/ | ||
+ | |||
+ | <code sql> | ||
+ | STARTUP NOMOUNT PFILE='/ | ||
+ | </ | ||
+ | |||
+ | ===== Initialization Parameters ===== | ||
+ | |||
+ | ==== Flash Recovery Area ==== | ||
+ | |||
+ | === DB_RECOVERY_FILE_DEST_SIZE === | ||
+ | |||
+ | The parameter '' | ||
+ | |||
+ | * For more inforamtion, | ||
+ | |||
+ | Example: Set flash recovery area to 8GB. The usage of '' | ||
+ | |||
+ | <code sql> | ||
+ | ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=8G SCOPE=BOTH SID=' | ||
+ | </ | ||
+ | |||
+ | {{tag> |