On the Same Host with the Instance Configured

Create a duplicate database on the same host with the configured instance.

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.

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

2. Create a duplicate database instance on the destination host. If the database already exists on the destination host, make sure to remove the temp.dbf file before performing a restore operation.

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 will 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 same as that 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 and the Tnsnames.ora files.

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

   Make sure to use the password change_on_install when you create the password file for the auxiliary database.

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

9. Restart the Listener.

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. In the Duplicate To box select the destination instance.

18. In the Number of streams to use for restore box, select the number of data channels to be used for the restore.

    To restore to a single node, retain the default value for the number of streams.

19. Select Duplicate To. In the Pfile box, type the name of the startup parameter file for the duplicate database, or browse to the location.

20. Click OK to start the restore.