Can RMAN restore to a different Instance on the same Host?
I have a 2-node RAC database (DB1) using ASM for the datafiles. I created a copy of the database (DB2) and its structure (no data for now) as a single instance using DBCA on one of the two nodes that contain the RAC database. The name of the tablespaces are the same but the sizes were made smaller in order to fit on the remaining space of the ASM disk group (I have limited space left on the SAN, but these resized tablespaces are still large enough to hold the data from the original database).
I just want to perform a test of a recovery procedure from DB1 to DB2. RMAN was used to perform a backup of DB1 and no catalog was used only the databases' control file. The backup is not an image copy just backup pieces. For this test, I am not interested in doing a full recovery, I am only backing up a few large tablespaces in DB1 and will attempt to restore them in DB2. We are doing this to test a 3rd party compression tool that is integrated with RMAN and just want to be sure that we have no problems