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
kilimanjaro
Messages: 134
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.

on RESTORING

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
gazzag
Messages: 907
Registered: November 2010
Location: Bristol, 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: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
(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: Sat Jan 20 06:01:35 CST 2018

Total time taken to generate the page: 0.08601 seconds