Forum Discussion

lzm's avatar
lzm
Level 3
9 days ago

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  

 

6 Replies

  • can you upload the log in bphdb , it will be under /usr/opev/netbackup/logs/bphdb
    I am not expert but , I remember did it once for one of our clients with support engineer , we used below code :

    Alter database mount;

    run {
    ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
    ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
    send 'NB_ORA_SERV=<MasterserverName>,NB_ORA_CLIENT=<oracle RacName>';
    restore database;
    recover database;
    RELEASE CHANNEL CH00;
    RELEASE CHANNEL CH02;
    }

    I hope it is useful for you.

     

  • Thank you for your suggestion. Currently, no valuable information has been found.
    Add some environmental information:
    Oracle installation user is not the default oracle, but oracleoracle. The following two figures show the installation user information of RAC and the destination machine, respectively

     

    • lzm's avatar
      lzm
      Level 3

      I followed the steps in the reference document for the operation, but the problem still exists

       

      • quebek's avatar
        quebek
        Moderator

        Hi

        So what is in alert.log file and bphdb, Oracle etc...

        Did you link the libobk?