登录  /  注册

Oracle体系结构及备份(十七)bg-others

php中文网
发布: 2016-06-07 15:08:30
原创
1044人浏览过

一 其他进程 Archiver (ARCn) Oneor more archiver processes copy the redo log files to archival storage whenthey are full or a log switch occurs. Recoverer (RECO) The recoverer process is used to resolvedistributed transactions that are pend

一 其他进程

 

        Archiver (ARCn)

        Oneor more archiver processes copy the redo log files to archival storage whenthey are full or a log switch occurs.

 

        Recoverer (RECO)

        The recoverer process is used to resolvedistributed transactions that are pending because of a network or systemfailure in a distributed database. At timed intervals, the local RECO attemptsto connect to remote databases and automatically complete the commit or rollbackof the local portion of any pending distributed transactions.

 

        Dispatcher (Dnnn)

        Dispatchers are optional backgroundprocesses, present only when the shared server configuration is used.

 

        Global Cache Service (LMS)

        In an Oracle Real Application Clustersenvironment, this process manages resources and provides inter-instanceresource control.

 

 

二 操作示例


[oracle@localhost 桌面]$ ps -ef | grep ora_ | grep arc
[oracle@localhost 桌面]$ sqlplus / as sysdba;

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 6 11:21:32 2013

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  838860800 bytes
Fixed Size		    1222192 bytes
Variable Size		  788531664 bytes
Database Buffers	   46137344 bytes
Redo Buffers		    2969600 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL> exit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost 桌面]$ ps -ef | grep ora_ | grep arc
oracle    6644     1  0 11:22 ?        00:00:00 ora_arc0_orcl
oracle    6646     1  0 11:22 ?        00:00:00 ora_arc1_orcl
oracle    6648     1  0 11:22 ?        00:00:00 ora_arc2_orcl

SQL> show parameter log_archive_

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
log_archive_config		     string
log_archive_dest		     string
log_archive_dest_1		     string
log_archive_dest_10		     string
log_archive_dest_2		     string
log_archive_dest_3		     string
log_archive_dest_4		     string
log_archive_dest_5		     string
log_archive_dest_6		     string
log_archive_dest_7		     string
log_archive_dest_8		     string

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_9		     string
log_archive_dest_state_1	     string	 enable
log_archive_dest_state_10	     string	 enable
log_archive_dest_state_2	     string	 enable
log_archive_dest_state_3	     string	 enable
log_archive_dest_state_4	     string	 enable
log_archive_dest_state_5	     string	 enable
log_archive_dest_state_6	     string	 enable
log_archive_dest_state_7	     string	 enable
log_archive_dest_state_8	     string	 enable
log_archive_dest_state_9	     string	 enable

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
log_archive_duplex_dest 	     string
log_archive_format		     string	 %t_%s_%r.dbf
log_archive_local_first 	     boolean	 TRUE
log_archive_max_processes	     integer	 2
log_archive_min_succeed_dest	     integer	 1
log_archive_start		     boolean	 FALSE
log_archive_trace		     integer	 0

SQL> alter system set log_archive_max_processes = 2;

System altered.

SQL> exit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost 桌面]$ ps -ef | grep ora_ | grep arc
oracle    6644     1  0 11:22 ?        00:00:00 ora_arc0_orcl
oracle    6646     1  0 11:22 ?        00:00:00 ora_arc1_orcl
oracle    6648     1  0 11:22 ?        00:00:00 ora_arc2_orcl
[oracle@localhost 桌面]$ sqlplus / as sysdba;

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 6 11:24:42 2013

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> alter system switch logfile;

System altered.

SQL> exit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost 桌面]$ sqlplus / as sysdba;

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 6 11:24:59 2013

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> alter system set log_archive_max_processes=32;
alter system set log_archive_max_processes=32
*
ERROR at line 1:
ORA-00068: invalid value 32 for parameter log_archive_max_processes, must be
between 1 and 30


SQL> alter system set log_archive_max_processes=30;

System altered.

SQL> alter system set log_archive_max_processes=2;

System altered.
登录后复制


三 总结

 

        1.其他进程包括ARCn、RECO、Dnnn、LMS;

        2.归档进程在归档模式下有效;

        3.可以动态调整归档进程的大小,但不能超过30。



<span><span>我的邮箱</span></span><span>:</span>wgbno27@163.com <span> <span>新浪微博</span></span><span>:</span>@Wentasy27
  <span>微信公众平台</span>:JustOracle(微信号:justoracle)
  <span>数据库技术交流群</span>:336882565(加群时验证 From CSDN XXX)
  <span>Oracle交流讨论组</span>:https://groups.google.com/d/forum/justoracle
  <span><strong>By Larry Wen</strong></span>
登录后复制


Oracle体系结构及备份(十七)bg-others Oracle体系结构及备份(十七)bg-others Oracle体系结构及备份(十七)bg-others
@Wentasy
智能AI问答
PHP中文网智能助手能迅速回答你的编程问题,提供实时的代码和解决方案,帮助你解决各种难题。不仅如此,它还能提供编程资源和学习指导,帮助你快速提升编程技能。无论你是初学者还是专业人士,AI智能助手都能成为你的可靠助手,助力你在编程领域取得更大的成就。
来源:php中文网
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
最新问题
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 意见反馈 讲师合作 广告合作 最新更新
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习
PHP中文网抖音号
发现有趣的

Copyright 2014-2024 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号