Hello,
We recently migrated the database files to new diskgroup and dropped the old diskgroups.
However, we still get the error below;
2019-07-31T07:30:13.109262-07:00 | ORA-17503: ksfdopn:2 Failed to open file +DG_PRD_DATA_01/db01p/spfiledb01p.ora
2019-07-31T07:30:13.109262-07:00 | ORA-15001: diskgroup "DG_PRD_DATA_01" does not exist or is not mounted
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DG_PRD_DATA_SSD_01/db01p/spfiledb01p.ora
SQL> quit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ncwd2 db01p> srvctl config database -d db01p
Database unique name: db01p
Database name:
Oracle home: /app/oracle/product/12.2.0.1/db
Oracle user: oracle
Spfile: +DG_PRD_DATA_SSD_01/db01p/spfiledb01p.ora
Password file:
Domain: calwin
Start options: open
Stop options: immediate
Database role: PHYSICAL_STANDBY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DG_PRD_DATA_SSD_01,DG_PRD_FLASH_SSD_01
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: dba
Database instances: db01p1,db01p2
Configured nodes: ncwd1,ncwd2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
Much appreciate your view , thoughts and advise on resolving this.
Thanks, SivaOra