Thursday, December 26, 2024

RMAN-06172: no AUTOBACKUP found or the specified handle is not a valid copy or piece

     

RMAN> restore controlfile from '/home/oracle/current.257.1073287779_20240609_0030'; 

  

Starting restore at 12-JUN-24 

using target database control file instead of recovery catalog 

allocated channel: ORA_DISK_1 

channel ORA_DISK_1: SID=2049 device type=DISK 

  

RMAN-00571: ============================================== ============= 

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== 

RMAN-00571: ============================================== ============= 

RMAN-03002: failure of restore command at 06/12/2024 08:38:03 

RMAN-06172: no AUTOBACKUP found or the specified handle is not a valid copy or piece 


Reason of this error is wrong path or/and name of the backup of controlfile that you mentioned in the restore command. You should either provide correct controlfile backup in RESTORE CONTROLFILE command, or there must exist and AUTOBACKUP of the controlfile because RMAN tries to restore controlfile from AUTOBACKUP if backup path is wrong in the command. After providing the correct path of the controlfile, RMAN should be able to retore the controlfile from the backup.

RMAN> restore controlfile from '/home/oracle/salman/current.257.1073287779_20240609_0030'; 

  

Starting restore at 12-JUN-24 

using channel ORA_DISK_1 

  

channel ORA_DISK_1: copied control file copy 

output file name=+DATAC1/SALMAN/CONTROLFILE/current.5159.1171442311 

Finished restore at 12-JUN-24 

  

RMAN> exit 

No comments:

Post a Comment

Popular Posts - All Times