On a Different Host with the Instance Configured

Create a duplicate database on a host that is different than the host containing the configured instance. Make sure that the instance is configured on a different host in the CommCell Console.

If you are restoring from a lower version of Oracle to a higher version, use the STARTUP UPGRADE command. After STARTUP UPGRADE, refer to the Oracle documentation for detailed instructions.

Procedure

1. Perform a full backup, including the log files, on the original database.

2. On the destination host, make sure to remove the temp.dbf file from the existing database instance.

3. Manually copy the init<SID>.ora file from the source computer to the destination computer.

   On UNIX:

   $ORACLE_HOME

   On Windows:

   %ORACLE_HOME%

4. Update the database name, dump files, archive logs and the control file locations in the init<SID>.ora file for the duplicate database instance.

5. Add the DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT parameters in the init<SID>.ora file. These parameters redirect the datafiles, temp files, and log files to the auxiliary instance.

   Make sure that all the other parameters in the init<SID>.ora file are the same as in the original database.

   On UNIX:

   DB_FILE_NAME_CONVERT=(source_of_df_path/,dup_of_df_path/,``source_of_temp_path/,dup_of_temp_path/,...)``LOG_FILE_NAME_CONVERT=(source_of_log_path/redo,dup_of_log_path/redo)

   On Windows:

   DB_FILE_NAME_CONVERT=('source_of_df_path/','dup_of_df_path/',``'source_of_temp_path/','dup_of_temp_path/',...)``LOG_FILE_NAME_CONVERT=('source_of_log_path/redo','dup_of_log_path/redo')

   (When using these parameters on a Windows computer, the file paths should be entered in uppercase.)

6. On Windows clients, restart Oracle services.

   Skip this step, if you are using a UNIX client.

7. Add the duplicate database instance name in the Listener.ora file on the destination host and add the TNS entry in the Tnsnames.ora files on the source and destination hosts.

8. Add the source database name in the Tnsnames.ora file on the destination host.

   DUPDB =``DESCRIPTION =``ADDRESS = (PROTOCOL = TCP)(HOST = powerpc02)(PORT = 1521))``(CONNECT_DATA =``(SERVER = DEDICATED)``(SERVICE_NAME = dupdb)``)``)

9. Restart the Listener.

   $ lsnrctl reload

10. Provide a valid connect string for the auxiliary channel.

    Example:

    sys/sys@<SID name>

11. Start up the duplicate database instance in NOMOUNT mode.

12. From the CommCell Browser, go to Client Computers > RAC client.

13. Right-click the instance, then go to All Tasks > Browse and Restore.

    The Browse and Restore Options dialog box appears.

14. Select Latest Backup, and then click the View Content button.

15. Select the database, and then click the Recover All Selected button.

    The Oracle Restore Options dialog box appears.

16. Click RMAN Duplicate DB, and then click Next.

    The Oracle RMAN Duplicate DB Options dialog box appears.

17. On the General tab, select the Destination Client from the list.

18. In the Duplicate To box, select the destination instance.

19. In the Duplicate DB Options area, select Duplicate To. In the Pfile box, type the full path to the startup parameter file for the duplicate database.

20. On the Stream tab, double click the number of streams to use for each Oracle RAC instance in the Stream column, and enter the number of streams.

21. On the Stream tab, click Refresh All to verify that the status of the duplicate database is STARTED.

22. Click OK to start the restore.