Search This Blog

Monday, November 4, 2019

Restore spfile from autobackup

Restore SPFILE no AUTOBACKUP found RMAN-06172
Today i received an error while restoring spfile from autobackup.
RMAN> restore spfile from autobackup;
Starting restore at 04-NOV-19
using channel ORA_DISK_1
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20191104
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20191103
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20191102
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20191101
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20191031
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20191030
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20191029
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: =======================================================
RMAN-00569: ===== ERROR MESSAGE STACK FOLLOWS ======
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/04/2019 09:41:38
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

To rectify the error:
RMAN> set dbid=1551070519
RMAN> restore spfile from autobackup db_recovery_file_dest='/u01/oracle/flash_recovery_area' db_name='ORCL';

Similarly to restore controlfile from autobackup

RMAN> restore controlfile from autobackup;

No comments:

Post a Comment