您好,欢迎访问一九零五行业门户网

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

一 其他进程 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 2013copyright (c) 1982, 2005, oracle. all rights reserved.connected to:oracle database 10g enterprise edition release 10.2.0.1.0 - productionwith the partitioning, olap and data mining optionssql> select log_mode from v$database;log_mode------------noarchivelogsql> shutdown immediate;database closed.database dismounted.oracle instance shut down.sql> startup mountoracle instance started.total system global area 838860800 bytesfixed size 1222192 bytesvariable size 788531664 bytesdatabase buffers 46137344 bytesredo buffers 2969600 bytesdatabase mounted.sql> alter database archivelog;database altered.sql> alter database open;database altered.sql> select log_mode from v$database;log_mode------------archivelogsql> exit;disconnected from oracle database 10g enterprise edition release 10.2.0.1.0 - productionwith the partitioning, olap and data mining options[oracle@localhost 桌面]$ ps -ef | grep ora_ | grep arcoracle 6644 1 0 11:22 ? 00:00:00 ora_arc0_orcloracle 6646 1 0 11:22 ? 00:00:00 ora_arc1_orcloracle 6648 1 0 11:22 ? 00:00:00 ora_arc2_orclsql> show parameter log_archive_name type value------------------------------------ ----------- ------------------------------log_archive_config stringlog_archive_dest stringlog_archive_dest_1 stringlog_archive_dest_10 stringlog_archive_dest_2 stringlog_archive_dest_3 stringlog_archive_dest_4 stringlog_archive_dest_5 stringlog_archive_dest_6 stringlog_archive_dest_7 stringlog_archive_dest_8 stringname type value------------------------------------ ----------- ------------------------------log_archive_dest_9 stringlog_archive_dest_state_1 string enablelog_archive_dest_state_10 string enablelog_archive_dest_state_2 string enablelog_archive_dest_state_3 string enablelog_archive_dest_state_4 string enablelog_archive_dest_state_5 string enablelog_archive_dest_state_6 string enablelog_archive_dest_state_7 string enablelog_archive_dest_state_8 string enablelog_archive_dest_state_9 string enablename type value------------------------------------ ----------- ------------------------------log_archive_duplex_dest stringlog_archive_format string %t_%s_%r.dbflog_archive_local_first boolean truelog_archive_max_processes integer 2log_archive_min_succeed_dest integer 1log_archive_start boolean falselog_archive_trace integer 0sql> 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 - productionwith the partitioning, olap and data mining options[oracle@localhost 桌面]$ ps -ef | grep ora_ | grep arcoracle 6644 1 0 11:22 ? 00:00:00 ora_arc0_orcloracle 6646 1 0 11:22 ? 00:00:00 ora_arc1_orcloracle 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 2013copyright (c) 1982, 2005, oracle. all rights reserved.connected to:oracle database 10g enterprise edition release 10.2.0.1.0 - productionwith the partitioning, olap and data mining optionssql> alter system switch logfile;system altered.sql> exit;disconnected from oracle database 10g enterprise edition release 10.2.0.1.0 - productionwith 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 2013copyright (c) 1982, 2005, oracle. all rights reserved.connected to:oracle database 10g enterprise edition release 10.2.0.1.0 - productionwith the partitioning, olap and data mining optionssql> 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 bebetween 1 and 30sql> 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。
我的邮箱:wgbno27@163.com 新浪微博:@wentasy27 微信公众平台:justoracle(微信号:justoracle) 数据库技术交流群:336882565(加群时验证 from csdn xxx) oracle交流讨论组:https://groups.google.com/d/forum/justoracle by larry wen
@wentasy
其它类似信息

推荐信息