将spfile文件系统迁移到asm存储

oracle数据库启动默认顺序为spfile ,pfile。但是在asm存储中，我们需要将spfile迁移到asm存储上。以下是操作过程：

1、用pfile，启动库到nomount

SQL> startup nomount pfile='/home/oracle/app/oracle19c/dbs/initorcl.ora';

ORACLE instance started.

Total System Global Area 339734864 bytes

Fixed Size 9134416 bytes

Variable Size 272629760 bytes

Database Buffers 50331648 bytes

Redo Buffers 7639040 bytes

2、创建spfile文件到asm存储路径

SQL> create spfile='+DATA/orcl/spfileorcl.ora' from pfile;

File created.

3、同时更改默认spfile到新路径

SQL> alter system set spfile='+DATA/orcl/spfileorcl.ora';

System altered.

4、重启库使用默认spfile

SQL> startup force;

ORACLE instance started.

Total System Global Area 339734864 bytes

Fixed Size 9134416 bytes

Variable Size 272629760 bytes

Database Buffers 50331648 bytes

Redo Buffers 7639040 bytes

Database mounted.

Database opened.

5、确认spfile路径

SQL> show parameter spfile

NAME TYPE VALUE

---

spfile string +DATA/orcl/spfileorcl.ora