Rman-06172:no autobackup found or specified handle is not a valid copy or piece

Source: Internet
Author: User
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


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.