Oracle 修改快速恢复区没有指定大小,无法启动,
SQL> startup
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
1、查看是否有pfile(没有就很尴尬)
2、查看spfile的配置,复制出来,手动创建pfile
#查看
strings spfilePROD.ora
编辑pfile,复制进去,删除DB_RECOVERY_FILE_DEST的配置
vi initPROD.ora
保存退出
3、指定pfile启动
SQL> startup pfile='/u01/app/oracle/product/19.3.0/dbhome_1/dbs/initPROD.ora'
ORACLE instance started.
Total System Global Area 1493169040 bytes
Fixed Size 9134992 bytes
Variable Size 436207616 bytes
Database Buffers 1040187392 bytes
Redo Buffers 7639040 bytes
Database mounted.
Database opened.
这就起来了
4、把pfile的配置复制到spfile
SQL> create spfile from pfile;
File created.
然后重启就ok了