Posts

Showing posts from July 24, 2014

Oracle 11g:RMAN restore database with skip tablespace

Image
Oracle 11g:RMAN restore database with skip tablespace Dear User, Sometime we need to restore particular tablespace from rman full backup. Sometime we need some data from one particular tablespace not whole database. Oracle allow selection of tablespaces to be excluded from restoration. Follow below steps for do testing. 1.Restore database with different database. Set db_name=orcl set db_unique_name=orcl1. 2.Start database in nomount.Restore controlfile from backup. rman target / startup nomount restore controlfile from '/u01/backup/ctl_c-1381347609-20140723-00'; channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/u01/oradata/orcl1/control01.ctl output file name=/u01/oradata/orcl1/control02.ctl Finished restore at 24-JUL-14 RMAN>  3.Catalog backup pieces. rman target / catalog start with '/u01/backup'  4.Create restore recover scrip