RMAN-Backup and Recovery : part -1 (pfile/spfile) ! ** The Most Essential But The Most Ignored **

•Operating System

–Red Hat Enterprise Linux AS release 4 (Nahant Update 2)

–Windows XP SP-2

•Database

–Oracle Database 11g Release 2 (11.2.0.1)

–Oracle Database 10g Release 2 Patch 3 (10.2.0.4)

–Data Block Size – 8K

–Archive Log Mode

Loss of Parameter File (PFILE/SPFILE)

Loss of Parameter File Scenario’s

•SPF1: Loss of PFILE/SPFILE When No Backup Exists

•SPF2: Restore SPFILE From Autobackup

•SPF3: Restore SPFILE From Autobackup in FRA

•SPF4: Restore SPFILE Using Recovery Catalog

SPF1: Loss of PFILE/SPFILE When No Backup Exists

•Problem:

–Loss of PFILE/SPFILE

–You don’t have PFILE/SPFILE backup

•Solution(s):

1)Check database alert.log bottom-up

2)When database is UP

1)PFILE   à   Query V$PARAMETER2 view

2)SPFILE   à  Query V$SPPARAMETER

3)Create PFILE/SPFILE from memory (Oracle 11g)

1)  When Oracle instance starts, all non-default parameters are recorded in the database alert.log

2)  Output from V$PARAMETER2

•Revert all the modified parameters to original values

•Construct a PFILE

•Create a SPFILE from the PFILE

•Backup the recovered PFILE/SPFILE

3)  Create PFILE/SPFILE from memory (Oracle 11g)

–PFILE

–SPFILE

SPF2: Restoring SPFILE From Autobackup

•Problem:

–Database is DOWN

–SPFILE is lost

–Autobackup is configured

•Solution:

–Start database instance in NOMOUNT mode without a parameter file

–Set DBID

–Restore SPFILE from Autobackup

•Start database instance in NOMOUNT mode without a parameter file

•Set DBID

•Restore SPFILE from Autobackup

SPF3: Restoring SPFILE From FRA 

•Problem:

–Database is DOWN

–SPFILE is lost

–FRA is enabled

•Solution:

–Start database instance in NOMOUNT mode without a parameter file

–Restore SPFILE from FRA

•Start database instance in NOMOUNT mode without a parameter file

•Restore SPFILE from FRA

SPF4: Restore SPFILE Using Recovery Catalog

•Problem:

–Database is DOWN

–SPFILE is lost

–Recovery Catalog Database is configured

•Solution:

–Start database instance in NOMOUNT mode without a parameter file

–Restore SPFILE

•Restore SPFILE

cont.  👇👨👇   

Loss of Control File :    

cont.  👇👨👇   

Loss of Redo log Files :