...
| Note |
|---|
When running a primary database using ASM and you are looking at creating a standby database using a normal Filesystem based storage, you need to make sure you review the following parameters:
When using ASM these values can be set to specific ASM disk groups on the primary server. But when you are creating the standby database, you need to update these parameters to reflect the standby filesystem structure. Example, this is the parameters on a primary database using ASM:
Now when creating the standby database, you will lets say use d:\oracle\oradata as your primary datafile location (the database files will be created in d:\oracle\oradata\DB_NAME example d:\oracle\oradata\prod where prod is the database name). And with regards to the Flash/Fast recovery area you might be using d:\oracle\fast_recovery_area. The following adjustments to the db_create_file_dest and db_recovery_file_dest should be made:
If you have the db_create_online_log_dest_n values set you have to adjust them as well. |
| No Format |
|---|
------------------------------------------------------------------------------- You choose to create a non ASM standby database. Please change all Oracle database parameters values pointing to ASM locations to point to valid filesystem locations on the standby server. Primary database contains Oracle Managed Files (OMF). These files will be created as OMF files on the standby server. Please make sure creating of OMF files is enabled on the standby by setting up parameters db_create_file_dest, db_create_online_log_dest_n and db_recovery_file_dest to point to valid filesystem locations. Refer to Oracle documentation for information how to enable creating of OMF files. The following oracle database parameters will be set in the standby database pfile or spfile: ------------------------------------------------------------------------------- audit_file_dest /u01/app/oracle/admin/TSTRAC/adump compatible 11.2.0.4.0 db_block_size 8192 db_create_file_dest +DATA db_name TSTRAC db_recovery_file_dest +FRA db_recovery_file_dest_size 16106127360 diagnostic_dest /u01/app/oracle dispatchers (PROTOCOL=TCP) (SERVICE=TSTRACXDB) memory_max_target 788529152 memory_target 788529152 open_cursors 300 processes 150 remote_login_passwordfile EXCLUSIVE sga_max_size 788529152 spfile OS default standby_file_management MANUAL undo_tablespace UNDOTBS1 ------------------------------------------------------------------------------- What would you like to do: 1 - Proceed with creating the standby database 2 - Edit oracle database parameters for the standby database pfile/spfile 3 - Terminate processing Please enter your choice [1]: 2 Enter full parameter name: []: db_create_file_dest WARNING: Do NOT use single or double quotes to enclose parameter values! Separate multiple values with a comma. If a comma is part of a value, escape it with a backslash. Enter new value (leave blank to set to null or default Oracle value): []: /u01/app/oracle/oradata/tstrac Validating ... please wait The following oracle database parameters will be set in the standby database pfile or spfile: ------------------------------------------------------------------------------- audit_file_dest /u01/app/oracle/admin/TSTRAC/adump compatible 11.2.0.4.0 db_block_size 8192 db_create_file_dest /u01/app/oracle/oradata/tstrac db_name TSTRAC db_recovery_file_dest +FRA db_recovery_file_dest_size 16106127360 diagnostic_dest /u01/app/oracle dispatchers (PROTOCOL=TCP) (SERVICE=TSTRACXDB) memory_max_target 788529152 memory_target 788529152 open_cursors 300 processes 150 remote_login_passwordfile EXCLUSIVE sga_max_size 788529152 spfile OS default standby_file_management MANUAL undo_tablespace UNDOTBS1 ------------------------------------------------------------------------------- What would you like to do: 1 - Proceed with creating the standby database 2 - Edit oracle database parameters for the standby database pfile/spfile 3 - Terminate processing Please enter your choice [1]: 2 Enter full parameter name: []: db_recovery_file_dest WARNING: Do NOT use single or double quotes to enclose parameter values! Separate multiple values with a comma. If a comma is part of a value, escape it with a backslash. Enter new value (leave blank to set to null or default Oracle value): []: /u01/app/oracle/flash_recovery_area Validating ... please wait The following oracle database parameters will be set in the standby database pfile or spfile: ------------------------------------------------------------------------------- audit_file_dest /u01/app/oracle/admin/TSTRAC/adump compatible 11.2.0.4.0 db_block_size 8192 db_create_file_dest /u01/app/oracle/oradata/tstrac db_name TSTRAC db_recovery_file_dest /u01/app/oracle/flash_recovery_area db_recovery_file_dest_size 16106127360 diagnostic_dest /u01/app/oracle dispatchers (PROTOCOL=TCP) (SERVICE=TSTRACXDB) memory_max_target 788529152 memory_target 788529152 open_cursors 300 processes 150 remote_login_passwordfile EXCLUSIVE sga_max_size 788529152 spfile OS default standby_file_management MANUAL undo_tablespace UNDOTBS1 ------------------------------------------------------------------------------- What would you like to do: 1 - Proceed with creating the standby database 2 - Edit oracle database parameters for the standby database pfile/spfile 3 - Terminate processing Please enter your choice [1]: 1 Validating oracle database parameters... please wait SUCCEEDED |
...