Dear Experts,
Questions are regarding Standalone database Migration to ASM Diskgroups from File System.
DB : 11.2.0.4 on LINUX
1) My spfile has been placed in ASM Diskgroup.
>>
SYS>show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/orcl/spfileorcl.ora
If i move/rename pfile in file system , Oracle DB is NOT started automatically/manually.
Steps what i have done , please have a look
$ mv initorcl.ora initorcl.ora.bkp
$ ls -l initorcl*
-rw-r--r-- 1 oracle asmadmin 35 Sep 28 18:42 initorcl.ora.bkp
SYS>shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS>startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora'
# init 6
After reboot, I am waiting at least 15 mins - still my rbbms instance not started automatically.
$ ps -ef | grep pmon
grid 5502 1 0 21:01 ? 00:00:00 asm_pmon_+ASM
oracle 5746 5645 0 21:11 pts/2 00:00:00 grep pmon
so what i conclude , without initorcl.ora file (located in file system) , it is not possible to start my database.
********************************************
>> To migrate spfile from file system to ASM Diskgroup , i have followed following steps
SYS> CREATE PFILE='$ORACLE_HOME/dbs/initorcl.ora' FROM SPFILE='$ORACLE_HOME/dbs/spfileorcl.ora';
File created.
>> Create new SPFILE in an ASM Diskgroup:
SYS> CREATE SPFILE='+DATA/ORCL/spfileORCL.ora' FROM PFILE='$ORACLE_HOME/dbs/initorcl.ora';
File created.
>>
SYS> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
>>
$ cd $ORACLE_HOME/dbs
$ mv spfileorcl.ora spfileorcl.ora.bkp
>>
$ ls -l *.ora*
-rw-r--r-- 1 oracle asmadmin 37 Sep 25 16:38 initorcl.ora
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r----- 1 oracle asmadmin 2560 Sep 25 16:33 spfileorcl.ora.bkp
>> Update the text-based init<SID>.ora file with the new location of the SPFILE in ASM:
$ echo "SPFILE='+DATA/ORCL/spfileORCL.ora'" > $ORACLE_HOME/dbs/initorcl.ora
>>
$ cat /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora.bkp
SPFILE='+DATA/ORCL/spfileORCL.ora'
>>
SYS>startup;
ORACLE instance started.
Total System Global Area 1255473152 bytes
..
....
Database mounted.
Database opened.
>>
SYS>show parameter spf;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/orcl/spfileorcl.ora
>>
After renamed the pfile file (initorcl.ora to initorcl.ora.bkp ) once i bounce the database , not able to start up the rdbms instance.
$ mv initorcl.ora initorcl.ora.bkp
$ ls -l initorcl*
-rw-r--r-- 1 oracle asmadmin 35 Sep 28 18:42 initorcl.ora.bkp
SYS> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora'