Standby database spfile/pfile

Owned by KrupeshD (Deactivated)
Last updated: Nov 30, 2012Version comment
1 min read

The spfile.ora (pfile.ora for Oracle database version less than 9) is created for the standby database the using init.ora or spfile.ora file from the primary database. Oracle database parameters for the standby database can be customised. If an existing init.ora or spfile.ora file is already present on the standby server, it will be overwritten. The Create Standby Database wizard will guide the process for customizing of the Oracle standby database during the creation process. The settings can be saved as a template for future use. If a standby database template has been created previously, this can be used to create the standby database. No further questions will be asked.

The example shown here are for Linux/UNIX, but this is the same for Windows. For Windows, the Oracle Windows service will be automatically created on the standby server if this does not exist.