IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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 restoreCause: 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-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/
