ORA-03113 和ora-01041 的警告日志

最新推荐文章于 2021-04-08 04:18:32 发布
最新推荐文章于 2021-04-08 04:18:32 发布
阅读量318 收藏
点赞数
文章标签： 数据库 网络
ORA-376 encountered when generating server alert SMG-4120
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue May 11 20:47:42 2010
Completed: alter database open
Tue May 11 20:48:26 2010
alter database datafile 2 online
Completed: alter database datafile 2 online
alter database datafile 4 online
Completed: alter database datafile 4 online
Tue May 11 20:48:42 2010
Starting background process CJQ0
Tue May 11 20:48:42 2010
CJQ0 started with pid=36, OS id=2060
Tue May 11 21:05:31 2010
Stopping background process SMCO
Stopping background process FBDA
Shutting down instance: further logons disabled
Tue May 11 21:05:32 2010
Stopping background process CJQ0
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
Shutting down instance (immediate)
License high water mark = 9
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue May 11 21:05:43 2010
alter database close
Tue May 11 21:05:43 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue May 11 21:05:43 2010
Shutting down archive processes
Archiving is disabled
Tue May 11 21:05:43 2010
ARCH shutting down
Tue May 11 21:05:43 2010
ARCH shutting down
ARC1: Archival stopped
Tue May 11 21:05:43 2010
ARCH shutting down
ARC3: Archival stopped
Tue May 11 21:05:43 2010
ARCH shutting down
ARC0: Archival stopped
Tue May 11 21:05:43 2010
ARCH shutting down
ARC2: Archival stopped
ARC4: Archival stopped
Thread 1 closed at log sequence 79
Successful close of redo thread 1
Completed: alter database close
alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Tue May 11 21:05:49 2010
Stopping background process VKTM:
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue May 11 21:05:51 2010
Instance shutdown complete
Tue May 11 21:08:45 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in server-side spfile F:\APP\YANG\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORACL.ORA
System parameters with non-default values:
  processes                = 150
  shared_pool_size         = 116M
  memory_target            = 820M
  control_files            = "F:\APP\YANG\ORADATA\ORACL\CONTROL01.CTL"
  control_files            = "F:\APP\YANG\ORADATA\ORACL\CONTROL02.CTL"
  control_files            = "F:\APP\YANG\ORADATA\ORACL\CONTROL03.CTL"
  db_block_size            = 8192
  compatible               = "11.1.0.0.0"
  log_archive_start        = TRUE
  log_archive_dest_1       = "location=f:\app\yang\archive1
"
  log_archive_dest_2       = "location=f:\app\yang\archive2"
  log_archive_dest_state_1 = "ENABLE"
  log_archive_max_processes= 5
  log_archive_min_succeed_dest= 2
  log_archive_format       = "%s_%t_%r.log"
  db_recovery_file_dest    = "F:\app\yang\flash_recovery_area"
  db_recovery_file_dest_size= 2G
  undo_tablespace          = "UNDOTBS1"
  undo_retention           = 900
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=oraclXDB)"
  utl_file_dir             = "f:\app\yang\logminer"
  audit_file_dest          = "F:\APP\YANG\ADMIN\ORACL\ADUMP"
  audit_trail              = "DB"
  db_name                  = "oracl"
  open_cursors             = 300
  diagnostic_dest          = "F:\APP\YANG"
Deprecated system parameters with specified values:
  log_archive_start       
End of deprecated system parameter listing
Tue May 11 21:08:45 2010
PMON started with pid=2, OS id=2072
Tue May 11 21:08:45 2010
VKTM started with pid=3, OS id=2800 at elevated priority
VKTM running at (20)ms precision
Tue May 11 21:08:45 2010
DIAG started with pid=4, OS id=3848
Tue May 11 21:08:45 2010
DBRM started with pid=5, OS id=3568
Tue May 11 21:08:45 2010
PSP0 started with pid=6, OS id=924
Tue May 11 21:08:45 2010
DSKM started with pid=7, OS id=3964
Tue May 11 21:08:45 2010
DIA0 started with pid=8, OS id=2252
Tue May 11 21:08:45 2010
MMAN started with pid=7, OS id=3896
Tue May 11 21:08:45 2010
DBW0 started with pid=9, OS id=2080
Tue May 11 21:08:46 2010
LGWR started with pid=10, OS id=172
Tue May 11 21:08:46 2010
CKPT started with pid=11, OS id=3232
Tue May 11 21:08:46 2010
SMON started with pid=12, OS id=3152
Tue May 11 21:08:46 2010
RECO started with pid=13, OS id=252
Tue May 11 21:08:46 2010
MMON started with pid=14, OS id=3996
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue May 11 21:08:46 2010
MMNL started with pid=15, OS id=832
starting up 1 shared server(s) ...
ORACLE_BASE from environment = F:\app\yang
Tue May 11 21:08:46 2010
alter database mount
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 1764263393
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Tue May 11 21:08:54 2010
alter database open
LGWR: STARTING ARCH PROCESSES
Tue May 11 21:08:54 2010
ARC0 started with pid=20, OS id=3564
Tue May 11 21:08:54 2010
ARC1 started with pid=21, OS id=2140
Tue May 11 21:08:54 2010
ARC2 started with pid=22, OS id=3884
Tue May 11 21:08:54 2010
ARC3 started with pid=23, OS id=3860
ARC0: Archival started
Tue May 11 21:08:54 2010
ARC4 started with pid=24, OS id=4092
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 opened at log sequence 79
  Current log# 1 seq# 79 mem# 0: F:\APP\YANG\ORADATA\ORACL\REDO01.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC4: Becoming the heartbeat ARCH
Tue May 11 21:08:56 2010
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
Starting background process FBDA
Starting background process SMCO
Tue May 11 21:08:58 2010
FBDA started with pid=25, OS id=804
Tue May 11 21:08:58 2010
SMCO started with pid=26, OS id=3908
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Tue May 11 21:08:59 2010
QMNC started with pid=27, OS id=1380
Tue May 11 21:09:09 2010
db_recovery_file_dest_size of 2048 MB is 1.19% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue May 11 21:09:20 2010
Completed: alter database open
Stopping background process SMCO
Stopping background process FBDA
Shutting down instance: further logons disabled
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
Shutting down instance (immediate)
License high water mark = 2
Waiting for dispatcher 'D000' to shutdown
Tue May 11 21:09:30 2010
All dispatchers and shared servers shutdown
alter database close
Tue May 11 21:09:31 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue May 11 21:09:31 2010
Shutting down archive processes
Archiving is disabled
Tue May 11 21:09:31 2010
ARCH shutting down
ARC4: Archival stopped
Tue May 11 21:09:31 2010
ARCH shutting down
ARC3: Archival stopped
Tue May 11 21:09:31 2010
ARCH shutting down
ARC1: Archival stopped
Tue May 11 21:09:31 2010
ARCH shutting down
ARC2: Archival stopped
Tue May 11 21:09:31 2010
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC0: Archiving disabled
ARCH shutting down
ARC0: Archival stopped
Thread 1 closed at log sequence 79
Successful close of redo thread 1
Completed: alter database close
alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue May 11 21:09:36 2010
Stopping background process VKTM:
Tue May 11 21:09:38 2010
Instance shutdown complete
Tue May 11 21:13:19 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in server-side spfile F:\APP\YANG\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORACL.ORA
System parameters with non-default values:
  processes                = 150
  shared_pool_size         = 116M
  memory_target            = 820M
  control_files            = "F:\APP\YANG\ORADATA\ORACL\CONTROL01.CTL"
  control_files            = "F:\APP\YANG\ORADATA\ORACL\CONTROL02.CTL"
  control_files            = "F:\APP\YANG\ORADATA\ORACL\CONTROL03.CTL"
  db_block_size            = 8192
  compatible               = "11.1.0.0.0"
  log_archive_start        = TRUE
  log_archive_dest_1       = "location=f:\app\yang\archive1
"
  log_archive_dest_2       = "location=f:\app\yang\archive2"
  log_archive_dest_state_1 = "ENABLE"
  log_archive_max_processes= 5
  log_archive_min_succeed_dest= 2
  log_archive_format       = "%s_%t_%r.log"
  db_recovery_file_dest    = "F:\app\yang\flash_recovery_area"
  db_recovery_file_dest_size= 2G
  undo_tablespace          = "UNDOTBS1"
  undo_retention           = 900
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=oraclXDB)"
  utl_file_dir             = "f:\app\yang\logminer"
  audit_file_dest          = "F:\APP\YANG\ADMIN\ORACL\ADUMP"
  audit_trail              = "DB"
  db_name                  = "oracl"
  open_cursors             = 300
  diagnostic_dest          = "F:\APP\YANG"
Deprecated system parameters with specified values:
  log_archive_start       
End of deprecated system parameter listing
Tue May 11 21:13:20 2010
PMON started with pid=2, OS id=3268
Tue May 11 21:13:20 2010
VKTM started with pid=3, OS id=2840 at elevated priority
VKTM running at (20)ms precision
Tue May 11 21:13:20 2010
DIAG started with pid=4, OS id=3904
Tue May 11 21:13:20 2010
DBRM started with pid=5, OS id=3844
Tue May 11 21:13:20 2010
PSP0 started with pid=6, OS id=3184
Tue May 11 21:13:20 2010
DSKM started with pid=7, OS id=3860
Tue May 11 21:13:20 2010
DIA0 started with pid=8, OS id=4036
Tue May 11 21:13:20 2010
MMAN started with pid=7, OS id=3112
Tue May 11 21:13:20 2010
DBW0 started with pid=9, OS id=3996
Tue May 11 21:13:20 2010
LGWR started with pid=10, OS id=3480
Tue May 11 21:13:20 2010
CKPT started with pid=11, OS id=684
Tue May 11 21:13:20 2010
SMON started with pid=12, OS id=3508
Tue May 11 21:13:20 2010
RECO started with pid=13, OS id=3596
Tue May 11 21:13:20 2010
MMON started with pid=14, OS id=2440
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue May 11 21:13:20 2010
MMNL started with pid=15, OS id=3692
starting up 1 shared server(s) ...
ORACLE_BASE from environment = F:\app\yang
Tue May 11 21:13:21 2010
alter database mount
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 1764242163
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Tue May 11 21:28:24 2010
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue May 11 22:11:26 2010
alter database open
Tue May 11 22:11:26 2010
LGWR: STARTING ARCH PROCESSES
Tue May 11 22:11:26 2010
ARC0 started with pid=19, OS id=4936
Tue May 11 22:11:26 2010
ARC1 started with pid=20, OS id=2892
Tue May 11 22:11:26 2010
ARC2 started with pid=22, OS id=5572
Tue May 11 22:11:26 2010
ARC3 started with pid=21, OS id=5000
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC3: Becoming the 'no FAL' ARCH
ARC3: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Tue May 11 22:11:26 2010
ARC4 started with pid=23, OS id=3828
Thread 1 opened at log sequence 79
  Current log# 1 seq# 79 mem# 0: F:\APP\YANG\ORADATA\ORACL\REDO01.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue May 11 22:11:28 2010
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
Starting background process FBDA
Starting background process SMCO
Tue May 11 22:11:29 2010
FBDA started with pid=24, OS id=4188
Tue May 11 22:11:29 2010
SMCO started with pid=25, OS id=4200
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Tue May 11 22:11:30 2010
QMNC started with pid=26, OS id=4620
Tue May 11 22:11:55 2010
Completed: alter database open
Tue May 11 22:13:47 2010
Starting background process CJQ0
Tue May 11 22:13:47 2010
CJQ0 started with pid=39, OS id=3796
Setting Resource Manager plan SCHEDULER[0x2C0A]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Tue May 11 22:14:02 2010
Tue May 11 22:14:02 2010
Logminer Bld: Lockdown Complete.  DB_TXN_SCN is   UnwindToSCN (LockdownSCN) is 2421816
Tue May 11 22:14:06 2010
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22664653/viewspace-662469/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22664653/viewspace-662469/

cojm55771
关注
db_recovery_file_dest_size: user-specified limit
白及
02-29 5628
db_recovery_file_dest_size: user-specified limit 节点告警信息： This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and do
ORA-03113:通信通道的文件结尾 ora-03114:未连接到oracle
weixin_43974616的博客
10-12 3060
ORA-03113:通信通道的文件结尾 ORA-03114:未连接到oracleORA-07445:caughtexception
ORA-01041
Microjoey的专栏
04-25 527
h1-SQL> startup pfile=?/dbs/inith1.ora ORA-03113: end-of-file on communication channel ORA-01041: internal error. hostdef extension doesn't exist
一次ORA-01041错误诊断
ytfy12的专栏
05-19 5249
设计Oracle Form的时候编写程序单元时候遇到的，在网上找的，只要重新连接数据库就行了。 转自:http://book.51cto.com/art/201001/177547.htm 一次ORA-01041错误诊断 这也是协助别人解决的一个问题，其实这个错误并不是很复杂，不过让我感触比较多。我最开始收到的信息就是在访问数据库时出现了ORA-01041错误。 由于只有一
oracle j000 deied,一个Job运行失败导致数据库挂死
weixin_29188043的博客
04-08 611
今天上午10点多的时候，同事接到一个电话，某数据库任何连接都连不上数据库，登录主机后发现，该数据库已经挂死，sqlplus都无法登陆，在alertlog中发现大量的“PMON failed to acquire latch, see PMON dump”。无奈之下，杀掉了oracle的进程，重启了数据库。事后，我们来看看究竟是什么原因，造成了这次数据库的挂死。我们看alertlog的相关报错，我们...
Oracle错误——ORA-03113:通信通道的文件结尾
热门推荐
hu1991die的专栏
03-19 1万+
我的Oracle数据库是去年11月份安装的，然后安装好之后配置了一下，那个时候是正常的，没有什么问题，但是后来我就一直没有用自己本地的Oracle，使用的PL/SQL一直连的是同事的机子，然后今天突然想在自己的机子上做些测试，PL/SQL居然一直连不上，提示了下面这个错误。 提示ORA-03113：通信通道的文件结尾 进程 ID ：0 会话 ID：0 序列号：0之后就是一系列的度娘谷歌论坛等等折腾
ORA-00257归档日志清理问题
12-14
7. **监控与预警**：设置数据库监控，当归档日志空间接近上限时，及时收到警告，从而提前进行清理或扩展存储空间，避免出现“ORA-00257”这样的紧急情况。 8. **数据库配置优化**：考虑调整参数`LOG_ARCHIVE_DEST_n...
oracle ora27072,ORA-1652 ORA-01114 ORA-27072
weixin_30773813的博客
04-04 615
今天接到同事电话，让我帮忙处理一个TEMP表空间的问题，开始的信息很简单，我也觉得这是一个简单的CASE，后来才发现原来还有点意思。警告日志内容如下hsscena:orahsp 10> pwd/oracle/HSP/saptrace/background-rw------- 1 orahsp dba 379602 May 29 15:14 alert_HSP.lo...
ora-03113: end-of-file on comm
最新发布
05-10
3. 查看数据库的警告日志和错误日志，查找可能的故障原因。 4. 重新启动客户端进程或数据库实例，可能能够解决这个问题。 5. 如果这个问题持续发生，可以考虑升级数据库版本或者调整数据库参数配置。 需要针对...
ERWin如何连接数据库(SQL2000、Oracle 10g)
05-14
装了个ERWin，连数据库连了一个晚上，始终提示各种各样奇怪的错误，要么说我库不存在，要么说我库里没有表，这是能把人气死，后来发现只要注意到两点就可以正常连接数据库。
oracle数据库设置db_recovery_file_dest_size参数为0
11-02
当我们设置数据库的归档路径时，就没有必要在使用db_recovery_file_dest参数，可是如果db_recovery_file_dest_size的值不为0，那么该如何设置呢？
Oracle 启动故障案例之--ORA-600 [4193]错误
天涯客*Blog
12-14 7379
Oracle 启动故障案例之--ORA-600 [4193]错误 操作系统：Oracle Linux 5 数据库：    Oracle 11gR2（11.2.0.3.0） 一、故障现象： 1、在做了redo log当前日志组被破坏恢复的测试后 2、启动数据库后出现ORA-600 【4193】的错误 3、数据库被强制关闭 查看告警日志： [oracle@ocm1 ~]$ ta
【RMAN】RMAN_RAC恢复至单机时redo日志引发的“恐慌”
crygaj7140的博客
10-29 475
一、概括 其实这个问题确切来说由于自己的疏忽所造成，之前做过RAC到单机的恢复实验，生产环境并无涉足，当时测试环境为Redhat5.4+Oracle11g+RAC，存储方式为ASM；生产环境为hpux+Orac...
db_recovery_file_dest_size 修改大一点及删除归档日志
冷月宫主的专栏
11-19 1万+
今天给客户测 试问题，让客户把数据发过来了。解压缩后一看，他们还是用的oracle 815版本的(他们exp导出时，带了导出日志，从导出日志中看出来是oracle 815版本的)，不过没有关系，低版本的exp是可以用高版本的imp导入到高版本数据库中的。一看是导入还很正常，导入到其中某个表的时候，突然就不动 了。一开始我还没有弄明白怎末回事。后来，无意中看到了 计算机管理--事件查看器中 ，有很多
oracle 11203 ora32701,love wife love life —Roger的Oracle/MySQL数据恢复博客
weixin_39831170的博客
04-07 617
前几天某客户的一个数据库出现故障，需要我们紧急救援支持。了解了一下环境，着实也吓了一跳，数据量55TB左右。首先我们来看看故障的信息：Fri Mar 25 22:57:10 2016Errors in file /oracle/app/oracle/diag/rdbms/njsdb/njsdb1/trace/xxxx1_dia0_30474350.trc (incident=640081):OR...
Trace文件过量生成问题解决
ciqu9915的博客
03-23 318
随着Oracle技术本身的不断发展，“自动化”和“智能化”的数据库时代已经来临。无论是运维管理、开发调试，传统DBA们的工作内容都已经发生了很大变化。一些诸如内存池划分调整、归档日志管理等功能，都已经被Or...
用oracle的ADRCI功能查看日志
clhljaa02293633的博客
09-06 512
oracle11g中提供了一个查看日志文件的命令行工具：Automatic Diagnostic Repository Command-Interpreter,包含在oracle database 11g中引入的故障可诊断性基础...
oracle启动，关闭过程
weixin_30732825的博客
11-06 146
1，oracle启动过程 nomount(instance started) -> mount(database mounted) -> open(database opened) SQL> startup ORACLE instance started. Total System Global Area 599785472 bytes ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值