oracle增加归档日志
an -DEMSTATE=/oracle/10.2/db_1/PMIS_DB_server_mzpmis -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/oracle/10.2/db_1/oc4j/j2ee/OC4J_DBConsole_PMIS_DB_server_mzpmis/config/jazn.xml -Djava.security.policy=/oracle/10.2/db_1/oc4j/j2ee/OC4J_DBConsole_PMIS_DB_server_mzpmis/config/java2.policy -Djava.security.properties=/oracle/10.2/db_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/oracle/10.2/db_1/PMIS_DB_server_mzpmis -Dsysman.md5password=true -Drepapi.oracle.home=/oracle/10.2/db_1 -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /oracle/10.2/db_1/oc4j/j2ee/home/oc4j.jar -config /oracle/10.2/db_1/oc4j/j2ee/OC4J_DBConsole_PMIS_DB_server_mzpmis/config/server.xml
oracle 2457776 2412760 0 20ê±16·?31?? pts/2 0:00 grep java
PMIS_DB_server:/oracle/10.2/db_1/dbs>ps -ef|grep ora_
oracle 540834 2412760 0 20ê±16·?41?? pts/2 0:00 grep ora_
oracle 2265320 1 0 9??10 - 2:38 ora_arc0_mzpmis
oracle 2338948 1 0 9??10 - 0:02 ora_reco_mzpmis
oracle 2429116 1 0 9??10 - 39:11 ora_lgwr_mzpmis
oracle 2633734 1 0 9??10 - 17:36 ora_smon_mzpmis
oracle 3117218 1 0 9??10 - 20:38 ora_dbw0_mzpmis
oracle 3203278 1 0 9??10 - 3:11 ora_psp0_mzpmis
oracle 3211412 1 0 9??10 - 27:52 ora_pmon_mzpmis
oracle 3289276 1 0 9??10 - 25:00 ora_ckpt_mzpmis
oracle 3305540 1 0 9??10 - 4:04 ora_arc1_mzpmis
oracle 3326156 1 0 9??10 - 3:05 ora_mman_mzpmis
PMIS_DB_server:/oracle/10.2/db_1/dbs>kill -9 2633734
PMIS_DB_server:/oracle/10.2/db_1/dbs>ps -ef|grep ora_
oracle 3326158 2412760 0 20ê±16·?57?? pts/2 0:00 grep ora_
PMIS_DB_server:/oracle/10.2/db_1/dbs>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Sat Feb 19 20:17:03 2011
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1.0217E+10 bytes
Fixed Size 2089672 bytes
Variable Size 1610616120 bytes
Database Buffers 8589934592 bytes
Redo Buffers 14684160 bytes
Database mounted.
ORA-16038: log 3 sequence# 40757 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/oradata/mzpmis/redo03.log'
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
PMIS_DB_server:/oracle/10.2/db_1/dbs>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Sat Feb 19 20:18:02 2011
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Minin
由于如果在创建数据库时指明是 Archive Mode 的话,会增加约 20%的创建时间,而...ORACLE 数据库日志及归档模式设置, 这种情况下, 做好数据库的定期备份 (有 热...
修改Oracle归档日志大小_计算机软件及应用_IT/计算机_专业资料。修改Oracle归档日志大小改变归档日志大小只有改变日志组的大小。 方法:加入新的大的日志文件,然后删掉...
oracle 归档日志相关设置查看目录的归档情况: 1、查看目录的归档情况: ARCHIVE ... Oracle 归档日志 暂无评价 8页 免费 oracle增加归档日志 4页 免费...
oracle 归档日志管理 在 Oracle 中,数据一般是存放在数据文件中,不过数据库与 ...归档进程.通过改变初始化参数 LOG_ARCHIVE_MAX_PROCESS 的值,可以动态地 增加或...
oracle归档日志管理_IT/计算机_专业资料。ORACLE的日志管理 2002-10 余枫 ...oracle (增加oracle的组/或者用groupadd) 3、#passwd oracle 敲两次口令,给...
确认日志工作模式: 1.查询 v$database 查询 SQL> select log_mode from v$... oracle增加归档日志 4页 免费 oracle日志归档模式改变 暂无评价 8页 免费...
oracle归档日志管理_IT/计算机_专业资料。归档日志(Archive Log)是非活动的重做...通过改变初始化参数 LOG_ARCHIVE_MAX_PROCESS 的值,可以动态地增加或降低归档进...
Oracle数据库归档日志日常管理与建议_计算机软件及应用_IT/计算机_专业资料。...增加了归档日志、归档目录等方面的管理与维护,以及系统 hang 住的隐患。 3. ...
oracle归档日志满后处理方法_IT/计算机_专业资料。两种方法: 1、配置RMAN自动管理ARCHIVELOG。也可在RMAN中将数据备份到磁带上,然后将过期的ARCHIVELOG删除; 2、...
上述结果告诉我们,归档位置用的是默认值,放在 flash_recovery_area 下(F:\oracle\product\10.2.0/flash_recovery_area) 转移或清除对应的归档日志, 删除一些不...
热门文档