Preparing for a Database Copy for SAP for Oracle

Updated

On this page

Prepare the database to perform the database copy operation.

Procedure

  1. Verify the following:

    • On the source host and the destination host, The connection specifications (host, service name, port) in the tnsnames.ora file must be different.

    • On the source host and the destination host, the following must be the same:

      • Operating systems

      • Oracle version

      • Processor (32-bit or 64-bit)

    • The destination host must have enough disk space for the restored database.

  2. On the destination host, verify that the following Oracle initialization files are present:

    • init<SID>.ora

    • init<SID>.sap

    • spfile<SID>.ora

  3. On the destination host, install the SAP on Oracle application and then create an empty instance. The SAPDATA_HOME path on the destination host can be the same path or a different path from the source, but the directory structure inside the SAPDATA_HOME path must be the same.

  4. Verify that the specification of the CONTROL_FILES parameter in the database initialization parameter file (init<SID>.ora) for the destination database corresponds to the specification for the source database. All control file mirror locations for the destination database must correspond to the similar specification for the source database.

    Control file locations specified in the source database and the destination database init<SID>.ora files should be similar to the following example.

    Source:

    CONTROL_FILES = (/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf

    /oracle/PRD/origlogA/cntrl/cntrlPRD.dbf

    /oracle/PRD/mirrorA/cntrl/cntrlPRD.dbf)

    Destination:

    CONTROL_FILES = (/oracle/CER/sapdata1/cntrl/cntrlCER.dbf

    /oracle/CER/origlogA/cntrl/cntrlCER.dbf

    /oracle/CER/mirrorA/cntrl/cntrlCER.dbf)
  5. On the destination host, create a SAP for Oracle instance in the CommCell Console.

    Note: You must have the source host and the destination host configured as clients in the same CommCell Console.

  6. On the destination host, create the SPFILE (spfile<SID>.ora) from the Oracle initialization file. Go to the $ORACLE_HOME (for UNIX configurations) or %ORACLE_HOME%\database (on Windows configuration), and then type the following command:

    ssqlplus / as sysdba 

    SQL> startup nomount pfile= init<SID>.ora;

    SQL> create spfile from pfile;

    Note: Do not modify this file after you create it.

  7. If you have more than 1000 logs, then to the SAP Oracle client, add the nBRRECOVER_NUMOFLOGSTORESTORE additional setting as shown in the following table.

    For instructions about adding an additional setting from the CommCell Console, see Adding an Additional Setting from the CommCell Console.

Property

Value

Name

nBRRECOVER_NUMOFLOGSTORESTORE

Category

OracleSapAgent

Type

Integer

Value

The number of logs that you need to restore.

  • Verify that the log_archive_dest or log_archive_dest_1 path and the log_archive_format parameters on the destination client and the source client are set based on SAP prerequisites for database copy restore. For more information, see SAP note 1003028.