利用alertSID.log文件生成参数文件来启动数据库

利用alertSID.log文件生成参数文件来启动数据库
[oracle@orcl11 trace]$ cd /u01/app/oracle/diag/rdbms/orcl/orcl/trace/
[oracle@orcl11 trace]$ vi alert_orcl.log
将以下参数复制
-----System parameters with non-default values:---------
  processes                = 150
  sga_max_size             = 700M
  memory_target            = 1528M
  control_files            = "/u01/app/oracle/oradata/orcl/control01.ctl"
  control_files            = "/u01/app/oracle/fast_recovery_area/orcl/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.4.0"
  db_recovery_file_dest    = "/u01/app/oracle/fast_recovery_area"
  db_recovery_file_dest_size= 4182M
  fast_start_mttr_target   = 260
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  job_queue_processes      = 1000
  audit_file_dest          = "/u01/app/oracle/admin/orcl/adump"
  audit_trail              = "DB"
  db_name                  = "orcl"
  open_cursors             = 300
  pga_aggregate_target     = 900M
  diagnostic_dest          = "/u01/app/oracle"

[oracle@orcl11 trace]$ cd $ORACLE_HOME
[oracle@orcl11 dbs]$ ll
total 32
-rw-rw----  1 oracle oinstall 1544 Jun 11 13:27 hc_dgdemo.dat
-rw-rw----. 1 oracle oinstall 1544 Jun 23 12:43 hc_orcl.dat
-rw-r-----  1 oracle oinstall   24 Jun 11 13:24 lkDGDEMO
-rw-r-----. 1 oracle oinstall   24 Jun  9 19:16 lkORCL
drwxr-xr-x  2 oracle oinstall 4096 Jun 22 13:26 old
-rw-r-----  1 oracle oinstall 1536 Jun 11 13:26 orapwdgdemo
-rw-r-----. 1 oracle oinstall 1536 Jun  9 22:41 orapworcl
-rw-r-----  1 oracle oinstall 3584 Jun 23 12:52 spfileorcl.ora
[oracle@orcl11 dbs]$ vi qyy.ora
  processes                = 150
  sga_max_size             = 700M
  memory_target            = 1528M
  control_files            = "/u01/app/oracle/oradata/orcl/control01.ctl"
  control_files            = "/u01/app/oracle/fast_recovery_area/orcl/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.4.0"
  db_recovery_file_dest    = "/u01/app/oracle/fast_recovery_area"
  db_recovery_file_dest_size= 4182M
  fast_start_mttr_target   = 260
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  job_queue_processes      = 1000
  audit_file_dest          = "/u01/app/oracle/admin/orcl/adump"
  audit_trail              = "DB"
  db_name                  = "orcl"
  open_cursors             = 300
  pga_aggregate_target     = 900M
  diagnostic_dest          = "/u01/app/oracle"

[oracle@orcl11 dbs]$ dba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 23 13:49:13 2021

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  730714112 bytes
Fixed Size            2256832 bytes
Variable Size          322961472 bytes
Database Buffers      402653184 bytes
Redo Buffers            2842624 bytes
Database mounted.
Database opened.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup pfile=$ORACLE_HOME/dbs/qyy.ora
ORACLE instance started.

Total System Global Area  730714112 bytes
Fixed Size            2256832 bytes
Variable Size          318767168 bytes
Database Buffers      406847488 bytes
Redo Buffers            2842624 bytes
Database mounted.
Database opened.
SQL>