Problem Description:
Restore SPFile always reports Rman-06172:no autobackup found or specified handle is not a valid copy or piece when the database is restored to the same machine through Rman
rman> restore SPFile from '/tmp/bak/db_14_1_928703445 ';
Starting restore at 24-nov-16
using target database control file instead of recovery catalog allocated Channel:or
A_disk_1
Channel ora_disk_1:sid=18 device Type=disk RMAN-00571
: ========================================== =================
RMAN-00569: =============== ERROR message STACK follows =============== RMAN-00571
: ======= ====================================================
rman-03002:failure of Restore command at 11/24/2016 21:14:18
rman-06172:no autobackup found or specified handle are not a valid copy or piece
Resolution process:
Collected a lot of great God's solutions on the Internet.
https://www.veritas.com/support/en_US/article.000013420
http://407882.blog.51cto.com/397882/282259
The last thing I found was a problem with my file permission settings.
The resolution process is as follows:
[oracle@ocm2 ~]$ ll/tmp/bak/total
388192
-rwxr-x--x 1 root 67405824 Nov 21:11 3/>-rwxr-x--x 1 root 1034752 Nov 21:11 arch_15_1_928703448-rwxr-x--x
1 root root 327557120 Nov-21:11 D b_13_1_928703380
-rwxr-x--x 1 root 1097728 Nov 21:11 db_14_1_928703445
[oracle@ocm2 ~]$ Su-
Password:
[root@ocm2 ~]# chown oracle:oinstall/tmp/bak/*
[root@ocm2 ~]#
[root@ocm2 ~]#-ll/tmp/bak/ Total
388192
-rwxr-x--x 1 Oracle oinstall 67405824 Nov 21:11 arch_12_1_928703365-rwxr-x--x
1 Oracle Oinstall 1034752 Nov 21:11 arch_15_1_928703448
-rwxr-x--x 1 Oracle oinstall 327557120 Nov-21:11 db_ 13_1_928703380
-rwxr-x--x 1 Oracle oinstall 1097728 Nov 21:11 db_14_1_928703445
[root@ocm2 ~]# Su-ora Cle