Spfile Missing - Create from pfile - FS / OracleRestart / RAC
1. spfile missing - create spfile from pfile - FS
2. spfile missing - create spfile from pfile - Oracle Restart
3. spfile missing - create spfile from pfile - RAC
1. spfile missing - create spfile from pfile - FS
- create it from pfile under $ORACLE_HOME/dbs location
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>
SQL> create spfile from pfile;
File created.
SQL>
SQL> create spfile from pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDEVDB.ora';
File created.
SQL>
SQL> create spfile from pfile='$ORACLE_HOME/dbs/initDEVDB.ora';
File created.
SQL>
2. spfile missing - create spfile from pfile - Oracle Restart
- create it from pfile under DISK_GROUP location
SQL> create spfile from pfile;
File created.
SQL>
[oracle@oraclelab2 dbs]$ srvctl modify database -d TESTDB -spfile '+DATA/spfileTESTDB.ora'
[oracle@oraclelab2 dbs]$ srvctl config database -d TESTDB
Database unique name: TESTDB
Database name: TESTDB
Oracle home: /u01/app/oracle/product/19.0.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/spfileTESTDB.ora
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA,RECO
Services:
OSDBA group: oinstall
OSOPER group: oinstall
Database instance: TESTDB
[oracle@oraclelab2 dbs]$
SQL> create spfile='+DATA/TESTDB/PARAMETERFILE/spfileTESTDB.ora' from pfile;
File created.
SQL>
[oracle@oraclelab2 dbs]$ srvctl modify database -d TESTDB -spfile '+DATA/TESTDB/PARAMETERFILE/spfileTESTDB.ora'
[oracle@oraclelab2 dbs]$ srvctl config database -d TESTDB
Database unique name: TESTDB
Database name: TESTDB
Oracle home: /u01/app/oracle/product/19.0.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/spfileTESTDB.ora
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA,RECO
Services:
OSDBA group: oinstall
OSOPER group: oinstall
Database instance: TESTDB
[oracle@oraclelab2 dbs]$
3. spfile missing - create spfile from pfile - RAC
- create it from pfile under DISK_GROUP location
SQL> create spfile from pfile;
File created.
SQL>
ASMCMD [+] > cd DATA
ASMCMD [+DATA] > ls -l
Type Redund Striped Time Sys Name
Y DEVDB/
Y host-clu/
PARAMETERFILE UNPROT COARSE MAR 04 00:00:00 N spfileDEVDB1.ora => +DATA/DEVDB/PARAMETERFILE/spfile.320.1162687239
ASMCMD [+DATA] > rm spfileDEVDB1.ora
SQL> create spfile='+DATA/DEVDB/PARAMETERFILE/spfileDEVDB.ora' from pfile;
File created.
SQL>
[oracle@hostnode1 dbs]$ asmcmd -p
cdASMCMD [+] > DATA
ASMCMD [+DATA] > ls -l
Type Redund Striped Time Sys Name
Y DEVDB/
Y host-clu/
ASMCMD [+DATA] > cd DEVDB/
ASMCMD [+DATA/DEVDB] > cd PARAMETERFILE/
ASMCMD [+DATA/DEVDB/PARAMETERFILE] > ls -l
Type Redund Striped Time Sys Name
PARAMETERFILE UNPROT COARSE MAR 04 00:00:00 Y spfile.320.1162687333
PARAMETERFILE UNPROT COARSE MAR 04 00:00:00 N spfileDEVDB.ora => +DATA/DEVDB/PARAMETERFILE/spfile.320.1162687333
ASMCMD [+DATA/DEVDB/PARAMETERFILE] >
Regard,
Mallik
No comments:
Post a Comment