Failure in restoring Oracle RAC 12.2 to an Oracle standalone instance
一、environmental information:
production machine:2-node RAC using ASM storage, with backup pieces as follows:
[root@449c65cd test]# /usr/openv/netbackup/bin/bplist -C peer1 -t 4 -b -l -R /
-rw-rw---- oracleora oracledba 19922944 Jul 02 16:52 /c-4025591446-20250702-02
-rw-rw---- oracleora oracledba 19922944 Jul 02 16:50 /cntrl_22_1_1205427004
-rw-rw---- oracleora oracledba 19922944 Jul 02 16:49 /c-4025591446-20250702-01
-rw-rw---- oracleora oracledba 262144 Jul 02 16:49 /al_20_1_1205426929
-rw-rw---- oracleora oracledba 2883584 Jul 02 16:48 /al_19_1_1205426891
-rw-rw---- oracleora oracledba 12582912 Jul 02 16:48 /al_18_1_1205426891
-rw-rw---- oracleora oracledba 19922944 Jul 02 16:47 /c-4025591446-20250702-00
-rw-rw---- oracleora oracledba 369098752 Jul 02 16:40 /bk_16_1_1205426033
-rw-rw---- oracleora oracledba 288358400 Jul 02 16:33 /bk_15_1_1205426033
二、question:
Failed to restore to another standalone instance using /c-4025591446-xxxx
Allocated channel: CH0
Channel CH0: SID=136 device type=SBT_TAPE
Channel CH0: Veritas NetBackup for Oracle - Release 9.1 (2021052518)
Command sent to channel: CH0
Starting restore at 2025-07-03 19:36:54
Channel CH0: restoring control file
Released channel: CH0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: restore command failed at 07/03/2025 19:52:00
ORA-19870: error while restoring backup piece /c-4025591446-20250702-00
ORA-19507: failed to retrieve sequential file, handle="/c-4025591446-20250702-00", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Non-RMAN media manager error. Vendor-specific error text:
Failed to open backup file for restore.
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: sql statement command failed at 07/03/2025 19:52:00
ORA-00205: error in identifying control file, check alert log for details