rman target /
RMAN>shutdown immediate;
RMAN>set dbid=xxx;
RMAN>startup force nomount;
RMAN>restore spfile from '/rmanbackups/SP_xxx_xxx';
RMAN>startup;
1.如果rman没有备份,并且数据库还在运行。
create spfile ='/tmp/spfile.ora' from memory;
2.如果数据库关闭,且备份pfile。
startup pfile='/xxx/xxx';
create spfile from pfile='/xxx/xxx';