Oracle control file DO NOT restore in RAC mode !
Dear masters ,
I have a scenario to try backup/restore of tablespaces on my production Oracle servers.
my environment : Oracle 11g-R2 (OEL 5.5) - Netbackup 18.104.22.168
I'm able to backup successfully without any error but when try to restore the instance completely or restore a deleted
tablespace i face errors..
This is important to mention that my procedure is SUCCESSFUL for FS (file system mode) Oracle databases BUT not for
my procedure :
1- enabling controlfile autoback "on" and configuring channels (RMAN)
2- backing up of control file and tablespaces
3- creating of touch file (NO.RESTRICTION) on Netbackup server
4- startup nomount of instance (SQLPLUS)
5- set DBID (RMAN)
6- typing of RMAN commands on RUN (please refer to attached screenshot)
this procedure is OK for FS Oracle DB but I face the error ORA-06172 for RAC databases..
I tried to specify the correct piece handle name by the command :
5> restore controlfile from '/ctrl_xxxxxxxxx';
but the result was unsuccessful...
I will appreciate your comments...