Configuring the Source and Destination Hosts for Cross-Machine Restores

Use this procedure to configure the source and destination host before you restore the Oracle database to a different location, for example a cross-machine restore.

Before You Begin

Verify the following in both the source and destination hosts:

  1. The connection specifications (host, service name, port) in the tnsnames.ora file on both the source and destination hosts must be different.
  2. There is enough disk space on the destination host for the restored database.
  3. The source and destination hosts must have the same:
    • Operating systems
    • Oracle version
    • ORACLE_SID
    • Processor (32-bit or 64-bit)
    • Datafile directory structures

Procedure

  1. On the destination host, install the Oracle Agent and configure it as a client in the source host CommCell Console.
  2. On the destination host CommCell Console, create and configure a new Oracle instance, with the same name as the source instance.
  3. Copy the pfile from the source host to the destination host. If the sp file does not exist on the source host, restore the sp file on the source host and then copy the file to the destination.

    For information on restoring the sp file, see Restoring the Oracle SP file.

  4. On the destination host, in the recovery catalog, create a new user account with recovery catalog owner permission.

    The destination host must use a different username from the source host.

    Example

    SQL>create user username identified by password
    2>temporary tablespace <temp_tablespace_name>
    3>default tablespace <default_tablespace_name>
    4>quota unlimited on <default_tablespace_name>;
    Statement processed.
    SQL>grant connect, resource, recovery_catalog_owner to <username>;
    Statement processed.

  5. Manually transfer the Oracle password file orapw<Oracle SID name> from the source host, to the destination host.

    The orapw<Oracle SID name> file is usually located in the ORACLE_HOME/dbs directory.

  6. On the RMAN command line, export the recovery catalog data for the catalog user.

    For example, if the user ID for the recovery catalog owner is user1, export the database backup information for user1.

  7. Import the recovery catalog data to the new user account for the destination host.

    Example using IMPORT CATALOG Command:

    RMAN>IMPORT CATALOG user1/user1@src;

  8. Copy the source host recovery catalog’s connect string entry in the tnsnames.ora file to the destination host.

    <service_name> =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = <protocol>)(HOST = <host>) (PORT = <##>))
    (CONNECT_DATA = (SID = <Recovery Catalog database>)))

  9. Configure the ORACLE_SID and ORACLE_HOME on the destination host.

    UNIX

    #export ORACLE_SID= <target database SID>
    #export ORACLE_HOME= <Oracle home directory>

    Windows

    C:\set ORACLE_SID= <target database SID>
    C:\set ORACLE_HOME= <Oracle home directory>

  10. Put the destination instance in NOMOUNT mode.