SQL>startup ORA-01078:failure in processing system parameters LRM-00109:
could not open parameter file, C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORA Using RMAN,
how would you respond to this error?
A. Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
B. Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.
C. Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
D. Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
E. Issue the restore spfile from autobackup command from the RMAN prompt.
答案:(C)
解析:
初始化参数文件缺失,用rman启动到nomount状态(用一个默认初始化参数文件)然后,从自动备份中把spfile转储回来。再重启数据库