You can recover the RAC database after restoring the application data and logs from the disk using the RMAN script through the command line. Make sure to install an Oracle Agent with a Restore only option on the nodes of the RAC and configure the Oracle RAC client that you are using for recovering the database.
Use the following parameters in the RMAN script for device type SBT_TAPE to recover the RAC database from the backup pieces restored to disk:
-
CV_media : This parameter is used to specify RMAN to use backup pieces on disk for device type sbt_tape.
-
BACKUP_DIR :This parameter is used along with CV_media to specify the directory from which backup pieces can be read.
RMAN Script example:
run {
allocate channel ch1 type 'sbt_tape'
PARMS="ENV=(CV_media=FILE,BACKUP_DIR=C:\RestoreToDisk\783406\Data)";
allocate channel ch2 type 'sbt_tape'
PARMS="ENV=(CV_media=FILE,BACKUP_DIR=C:\RestoreToDisk\783406\Data)";}
restore database;
recover database ;
alter database open resetlogs;
}