手误修改了spfile导致实例重启失败

最新推荐文章于 2024-07-21 22:23:56 发布

我是东山

最新推荐文章于 2024-07-21 22:23:56 发布

阅读量143

点赞数 2

文章标签：数据库 oracle

本文链接：https://blog.csdn.net/huainianxiaowei/article/details/137876475

版权

手误修改了spfile参数文件

数据库启动使用的是SPFILE，修改参数文件误修改了SPFILEORCL.ora。导致数据库启动失败。
```

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/u01/app/oracle/product/19.3.0/dbhome_1/dbs/initorcl.ora’
```

解决方案

使用strings命令将spfile参数重定向到initorcl.ora。在启动数据库服务。

$ strings spfileorcl.ora >>initorcl.ora

$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Apr 17 15:56:38 2024
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup pfile='/u01/app/oracle/product/19.3.0/dbhome_1/dbs/initorcl.ora'
ORACLE instance started.

Total System Global Area 2147481656 bytes
Fixed Size                  8898616 bytes
Variable Size            1426063360 bytes
Database Buffers          704643072 bytes
Redo Buffers                7876608 bytes
Database mounted.
Database opened.

重建SPFILE

SQL> create spfile from pfile;

File created.

重启数据库，使用SPFILE启动，数据库启动参数优先级 SPFILE>initorcl.ora

调整手动修改参数

SQL> show parameter target

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target                   integer     0
db_big_table_cache_percent_target    string      0
db_flashback_retention_target        integer     1440
fast_start_io_target                 integer     0
fast_start_mttr_target               integer     0
memory_max_target                    big integer 0
memory_target                        big integer 0
parallel_servers_target              integer     64
pga_aggregate_target                 big integer 512M
sga_target                           big integer 1536M
target_pdbs                          integer     0
SQL> alter system set memory_max_target=1024 scope=spfile;

System altered.

SQL>
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/19.3.0
                                                 /dbhome_1/dbs/spfileorcl.ora