RMAN-06172:未找到自动备份或指定的句柄不是有效的副本或片段

Question

作为从12c数据库(TEST44)的Simpana备份到其副本(TEST15)的克隆过程的第一步，我正在尝试恢复一个spfile。已使用Simpana成功备份源数据库。已设置自动备份：

CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

我可以列出还原正在使用的备份集：

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
30      Full    128.50M    SBT_TAPE    00:00:04     18-JUN-18
        `BP Key: 30   Status`: AVAILABLE  Compressed: NO  Tag: TAG20180618T164547
        Handle: c-958109427-20180618-03   Media: V_453862_1340469
  SPFILE Included: Modification time: 18-JUN-18
  SPFILE db_unique_name: TEST44
  Control File Included: Ckp SCN: 975546       Ckp time: 18-JUN-18

目标数据库已挂载。我需要先恢复spfile，然后才能恢复控制文件，但我遇到了以下错误：

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 
executing command: SET DBID
database name is "TEST44" and DBID is 958109427

allocated channel: a1
channel a1: SID=254 device type=SBT_TAPE
channel a1: CommVault Systems for Oracle: Version 10.0.0(BUILD116)

allocated channel: a2
channel a2: SID=317 device type=SBT_TAPE
channel a2: CommVault Systems for Oracle: Version 10.0.0(BUILD116)

allocated channel: a3
channel a3: SID=380 device type=SBT_TAPE
channel a3: CommVault Systems for Oracle: Version 10.0.0(BUILD116)

allocated channel: a4
channel a4: SID=442 device type=SBT_TAPE
channel a4: CommVault Systems for Oracle: Version 10.0.0(BUILD116)

Starting restore at 18-JUN-18

channel a1: no AUTOBACKUP in 7 days found
channel a2: no AUTOBACKUP in 7 days found
channel a3: no AUTOBACKUP in 7 days found
channel a4: no AUTOBACKUP in 7 days found
released channel: a1
released channel: a2
released channel: a3
released channel: a4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/18/2018 17:48:39
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

RMAN> 

Recovery Manager complete.


Running: restore spfile to '/u01/app/oracle/product/12.1.0.2/dbs/spfileTEST15.ora' from 'c-958109427-20180618-03

为了解决这个问题，我应该看什么?有什么建议吗？非常感谢。

Answer 1

此问题是由于目标主机上的Commvault客户端安装配置不正确造成的。使用Commcell GUI可以看到主机未处于可用状态。完全卸载并重新安装CV客户端解决了此问题。