Skip to content

Building a Physical Standby Database (11/14) - Create spfile for both primary and standby database

  • by
  • November 23, 2012August 5, 2020
Building a Physical Standby Database (10/14) - Create standby redo logs on standby database
Since the two pfiles are ready in the step 3, we can use them to create spfiles for the primary and standby database.
  1. On primary database.
  2. [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
  3. On standby database.
  4. [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

Building a Physical Standby Database (12/14) - Recover managed standby database

Leave a Reply

Your email address will not be published.