Home » RDBMS Server » Backup & Recovery » RMAN-06172: no AUTOBACKUP found... ( Databse 11G R2,window 7 ultimate)
RMAN-06172: no AUTOBACKUP found... [message #635151] Mon, 23 March 2015 05:17 Go to next message
Messages: 151
Registered: May 2009
Location: Tanzania
Senior Member
Hello Buddies.I'm getting this error when trying to restore the database.

RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece.
Surprisingly yesterday I could restore successful but today It doesnt work.

Thank you all.

This is the workflow I done so far.
ON backup

RMAN >connect target CMX/secret --(CMX has DBA privilege)
RMAN > list backup summary;
RMAN > backup database include current controlfile;

it executes successful and the buckup is in C:\oracle\Administrator\flash_recovery_area\KGB\BACKUPSET\2015_03_23.


RMAN >connect target CMX/secret;--(CMX has DBA privilege)
RMAN >shutdown abort;
RMAN >startup nomount;
RMAN >restore controlfile from ' C:\oracle\Administrator\flash_recovery_area\KGB\BACKUPSET\2015_03_23\O1_MF_NCNNF_TAG20150323T124956_BJZRK5HN_.BKP';

RMAN >alter database mount;
RMAN >restore database;
RMAN >recover database;
RMAN >alter database open resetlogs;
Re: RMAN-06172: no AUTOBACKUP found... [message #635152 is a reply to message #635151] Mon, 23 March 2015 05:28 Go to previous messageGo to next message
Messages: 1114
Registered: November 2010
Location: Bedwas, UK
Senior Member
Please post the output from the following command:
RMAN> list backup;
Re: RMAN-06172: no AUTOBACKUP found... [message #635153 is a reply to message #635151] Mon, 23 March 2015 06:10 Go to previous message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

(CMX has DBA privilege)

He must have SYSDBA privilege; hope this is not an application account.

ALWAYS post the complete log of your failed session.

Please read How to use [code] tags and make your code easier to read.

Previous Topic: RMAN - 01009 don't know why error?
Next Topic: object recovery
Goto Forum:

Current Time: Mon Mar 27 06:23:22 CDT 2023