Database created from ASM mirror copy, does not read correct spfile
I have created a new database using ASM mirror copy(flex diskgroup feature).
SQL> create database orcl_new using mirror copy orclcopy;
I have done the following steps:
1. Created pfile from spfile from old database(from where I took mirror copy)
2. Changed all orcl entries into orcl_new in pfile generated above:
3. Tried to startup new database in nomount state by specifying pfile explicitly:
export ORACLE_SID=orcl_new1
export ORACLE_HOME=/u01/app/oracle/product/18.3.0/dbhome_1
sqlplus / as sysdba
SQL> startup nomount pfile='/tmp/orclpfile'; <<<<if I indicate explicitely, instance starts
ORACLE instance started.
Created spfile from that pfile in orcl_new database and in $ORACLE_HOME/dbs modified initorcl_new1.ora file by the following way:
0