Versions Compared

Old Version 10

changes.mady.by.user Vijayganesh Sivaprakasam

Saved on

compared with

New Version Current

changes.mady.by.user Jakub Sejba

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

If the Primary database has a mix of OMF and non-OMF data files then ensure that the below parameters are properly configured before create the standby database in the Manage Oracle Parameters section.

db_create_file_dest

db_recovery_file_dest

db_file_name_convert

log_file_name_convert

db_create_online_log_dest_n

...

4. Create Standby Database on Oracle Database Appliance (ODA)

...

When creating the standby database in either ODA Bare Metal or ODA KVM environment you need to manually change the following parameters:

  1. Click Manage Oracle Parameters

    Image RemovedImage Added

  2. Locate log_archive_dest_1 and log_archive_dest_10 parameters

  3. Escape the comma character in both parameters, i.e. set the following:

    1. log_archive_dest_1 to LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES\,ALL_ROLES) MAX_FAILURE=1 REOPEN=5 DB_UNIQUE_NAME=TEST03 ALTERNATE=log_archive_dest_10

    2. log_archive_dest_10 to LOCATION=+DATA/TEST03/arc10 VALID_FOR=(ALL_LOGFILES\,ALL_ROLES) DB_UNIQUE_NAME=TEST03 ALTERNATE=log_archive_dest_1

  4. Locate use_large_pages parameter

  5. Change the parameter value to FALSE (see also the following KB article for more details https://support.dbvisit.com/hc/en-us/articles/4973573379727-CSD-failed-with-ORA-27125)

...