how to find database is running on PFILE or SPFILE

Below script will tells us if the database is running on PFILE or SPFILE

 SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile';

OR


SQL> show parameter spfile;
NAME TYPE VALUE
—— —— ————————————————
spfile string /u01/apps/oracle/10g/dbs/spfileorclkhan.ora


parameter will tell you the location where the SPFILE is present as well.

Comments

Post a Comment

Welcome to the Oracle DBA Blog.

Stay Hungry Stay Foolish

Popular posts from this blog

ORACLE BACKUP AND RECOVERY

WHAT IS BACKUP AND RECOVERY IN ORACLE ·         Backup Strategy -           Whole DB backup -           Partial DB backup ·         Backup Type -           Full DB backup -           Incremental DB Backup ·         Backup Mode -           Online( Inconsistent ) DB backup -           Offline ( Closed/Consistent ) DB Backup Consistent and Inconsistent Backups A consistent backup is one in which the files being backed up contain all changes up to the same system change number (SCN) . This means that the files in the backup contain all the data taken from a same point in time. Unlike an inconsistent backup, a consistent whole database backup does not require recovery after it is restored. The only way to make a consistent whole database backup is to shut down the database with the NORMAL , IMMEDIATE , or TRANSACTIONAL options and make the backup while the database is closed. The important point is that you can open the database after restoring a consistent who
Read more