Restore RMAN full backup on different server skiping set of tablespaces
This is a 10 step guide on restoring/recovering a set tablespaces on different server from RMAN full backup. OS – RHEL -4 DB - 10.2.0.4.0 Step 1 – Start from dummy parameter file RMAN> startup force Step 2 – Restore spfile from backup set RMAN> restore spfile from '<FULL_PATH_TO_BACKUP_PIECE>'; Here you can find the backup piece containing parameter file by looking at the backup log or simply it is the smallest backup piece in backupset. Step 3 – Create pfile from spfile and do the required changes SQL> create pfile from spfile; After creating the pfile you can edit the settings of parameters so that it would suite the new server. Most of these parameter values are PATHs that need to be changed according to new server Oracle Home. 1.audit_file_dest 2.background_dump_dest 3.control_files 4.core_dump_dest 5.log_archive_dest_1 6.user_dump_dest Step 4 – Create spfile from pfile, Shut Down, Startup Nomount SQL>