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

最新推荐文章于 2024-03-16 20:27:59 发布

425569387

最新推荐文章于 2024-03-16 20:27:59 发布

阅读量226

点赞数

分类专栏： oracle 文章标签： oracle

本文链接：https://blog.youkuaiyun.com/qq_35435160/article/details/122532533

版权

oracle 专栏收录该内容

49 篇文章

订阅专栏

本文介绍如何从alertSID.log文件中提取参数并创建参数文件qyy.ora，利用该文件启动Oracle 11g数据库实例的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

利用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

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>