• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How to move spfile from ASM to filesystem

by admin

The post example shows how to delete the SPFILE in the +ASM DISKGROUP and relocate it to the $ORACLE_HOME/dbs directory. This process needs an instance restart and thus an outage.

1. Create pfile from the spfile

First, we will create pfile in filesystem from the existing spfile in ASM.

$ . oraenv a
ORACLE_SID = [testdb] ? testdb
SQL> create pfile=’$ORACLE_HOME/dbs/initINFPRD.ora’  
from spfile='+DG_ARCH/TESTDB/spfileINFPRD.ora';

2. Remove the spfile from ASM

We can now connect the the ASM instance and remove the spfile residing in ASM disk group.

$ . oraenv a
ORACLE_SID = [+ASM] ? +ASM
ASMCMD> rm +DG_ARCH/testdb/spfiletestdb.ora

3. Recreate the spfile

Next step is to shutdown the database and recreate the spfile.

$ . oraenv a
ORACLE_SID = [testdb] ? tesdb
SQL> shutdown immediate
SQL> create spfile=’$ORACLE_HOME/dbs/spfileINFPRD.ora'  
from pfile='$ORACLE_HOME/dbs/initINFPRD.ora’;

4. Start the database using new spfile

When you start the database, it will use the new spfile in filesystem that you have just created in the step 3.

SQL> startup
Note: You can also use the pfile created in step 1 located at $ORACLE_HOME/dbs. Do not perform rest of the steps if you want to use pfile.

Filed Under: ASM, oracle

Some more articles you might also be interested in …

  1. How to determine which user is using what rollback segment?
  2. How to upgrade RMAN catalog SCHEMA from 11g to 12.1.0.2 without upgrading the catalog database
  3. Oracle 11g New Feature – Archived Redo Log Failover
  4. How to upgrade Oracle database to 12c Pluggable database (Multitenant) using Transportable tablespace(TTS) method
  5. How to Create and Manage Snapshot Standby Database
  6. ORA-39170: Schema expression ‘OPS’ does not correspond to any schemas
  7. Basics of client connectivity in Oracle Data Guard configuration
  8. How to Connect to an Oracle Pluggable Database (PDB)
  9. Oracle Database : What Is The Search Order For The LDAP.ORA File
  10. Script to monitor RMAN Backup and Restore Operations

You May Also Like

Primary Sidebar

Recent Posts

  • “aws s3 mv” Command Examples
  • “aws s3 mb” Command Examples
  • “aws s3 ls” Command Examples
  • “aws s3 cp” Command Examples

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright