Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Ask DBA › Question Id: 3963 | Permalink

About parameter file

Question ID: 3963
Created By: 2010-MAR-18 20:43:26 [Singireddidba]
Updated By: 2010-MAR-19 15:01:14 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
11176
2010-MAR-18 20:43:26
User
 
 
Registered On: Feb 2010
Total Posts: 24
Hi Vital,,,good morning 
here what my question was?
. At one time you lost parameter file accidentally and you don't have any 
backup. How you will recreate a new parameter file with the parameters set to 
previous values.
Can u plz tell me ...How we can proceed in this situation?
11184
2010-MAR-19 14:59:27
Moderator
 
 
Registered On: Mar 2006
Total Posts: 289
You don't want to loose your SPFILE.  You should always use SPFILE for 
production -- PFILE should only be used temporary for clones/moves etc..

When you use SPFILE and RMAN backups (the ONLY right way) you should also 
enable RMAN control and spfile autobackup using this command:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

This way everytime you take RMAN backup it will automatically include SPFILE 
and CONTROL file in the backup set.  You'll never loose it this way.

If you inherit a bunch of COLD datafiles and no SPFILE to go with them then 
there's nothing you can do to get the original SPFILE values back.  Instead you 
just bring up the database with default PFILE and go from there ... trial and 
error kind of thing -- not a good scenario to be in.
[edited by: Vitaliy at 15:01 (CST) on Mar. 19, 2010]