Since the two pfiles are ready in the step 3, we can use them to create spfiles for the primary and standby database.
- On primary database.
[oracle@primary01 ~]$ srvctl stop database -d compdb
[oracle@primary01 ~]$ sqlplus / as sysdba
...
SQL> create spfile='+data/compdb/spfileprimdb.ora' from pfile='/tmp/init-prim.ora';
File created.
SQL> exit;
...
[oracle@primary01 ~]$ srvctl start database -d compdb - On standby database.
[oracle@standby01 ~]$ srvctl stop database -d compdb
[oracle@standby01 ~]$ sqlplus / as sysdba
...
SQL> create spfile='+data/compdb/spfilestandb.ora' from pfile='/tmp/init-stan.ora';
File created.
SQL> exit;
...
[oracle@standby01 ~]$ srvctl start database -d compdb -o mount