Site icon IT Tutorial

RMAN-06729: no backup of the SPFILE found to restore

Hi,

Sometimes You can get “RMAN-06729: no backup of the SPFILE found to restore ” error.

 

Details of error are as follows.

RMAN-06729: no backup of the SPFILE found to restore
Cause: A SPFILE restore could not proceed because no backup of the SPFILE was found.
It may be the case that a backup of this file exists but does not satisfy the criteria specified in the user’s restore operands.
Action: Modify options for the SPFILE restore.
RMAN-06026: some targets not found – aborting restore
RMAN-06729: no backup of the SPFILE found to restore

RMAN>


To solve this error, Use the restore spfile from autobackup and restore it as follows.

RMAN> run {
allocate channel c1 type sbt_tape PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/oracle/app/lib/libddobk.so,ENV=(STORAGE_UNIT=192.168.63.21,BACKUP_HOST=192.168.63.34,ORACLE_HOME=/oracle/app/product/dbhome1)';
set dbid = 683024484
restore spfile from autobackup;
release channel c1;
}

allocated channel: c1
channel c1: SID=1045 device type=SBT_TAPE
channel c1: Data Domain Boost API

channel c1: AUTOBACKUP found: c-8654738568-20190609-03
channel c1: restoring spfile from AUTOBACKUP c-8654738568-20190609-03
channel c1: SPFILE restore from AUTOBACKUP complete
Finished restore at 14-JUN-17
released channel: c1

RMAN>

 

 

 

Do you want to learn more details about RMAN, then read the following articles.

https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/

 

Exit mobile version