I have to duplicate my PROD database which is a single instance in to RAC TEST database. Please give me procedure to do that.
Prod database - Single Instance - 184.108.40.206
TEST Database - Need to create dummy instance in RAC and restore the PROD data - 220.127.116.11
Note: RMAN duplicate failed due to different patch level.
You CAN restore an 18.104.22.168 database backup into an 22.214.171.124 ORACLE_HOME. You will need to upgrade the database (data dictionary) using catupgrd.sql from the 126.96.36.199.
Conversion to RAC will be done after completing the upgrade. Essentially, this consists of adding one more Redo Log Thread and one more Undo tablespace.
Hemant K Chitale