$sqlplus /nolog;
SQL>connect / as sysdba;
SQL>startup nomount;
SQL>exit;
$rman target / nocatalog
RMAN>set dbid=147749264
RMAN>run
{
allocate channel d1 type disk;
set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘$ORACLE_BASE/oradata/rman_backup/control%F’;
Restore spfile from autobackup;
Release channel d1;
}
Here is the error info: RMAN-06564: rman must use the t0 clause when the instance is started with spfile
This error info implies that you were using default SPFILE [...]
Filed under: Q & A | Tagged: Auto Backup, Restore, RMAN, Spfile | Leave a Comment »
