- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-17 12:36:10
|
查看: 1739 |
回复: 0
select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARC STATUS
------ ---------- --- ----------------
1 53 NO ACTIVE
2 54 NO CURRENT
3 0 YES CLEARING
当我第一次强行切换的时候alater system switch logfile;
可以很顺利的执行,但是当再执行一次的时候就没有反映了,
查看了一下我的日志文件,现在是这样,这到底是什么原因导致的啊,
希望高手们给指点一下.
看了,是noarchivelog模式的,
SQL> archive log list
数据库日志模式 非存档模式
自动存档 禁用
存档终点 d:\oracle\ora92\RDBMS
最早的概要日志序列 54
当前日志序列 55
Thread 1 advanced to log sequence 55
Current log# 1 seq# 55 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Jul 04 15:21:26 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_1408.trc:
执行完的结果
__________________________
TKPROF: Release 9.2.0.1.0 - Production on 星期二 7月 4 17:22:18 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Trace file: crcl_ora_1408.trc
Sort options: default
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
Trace file: crcl_ora_1408.trc
Trace file compatibility: 9.00.01
Sort options: default
1 session in tracefile.
0 user SQL statements in trace file.
0 internal SQL statements in trace file.
0 SQL statements in trace file.
0 unique SQL statements in trace file.
2702 lines in trace file.
有一次,我的库出现了问题,我用了alter database clear datafile group 3,之后就是这样了,
我把第三组的删除了,查询后是这样的,
> select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARC STATUS
------- ---------- --- ----------------
1 55 NO INACTIVE
2 56 NO CURRENT
3 0 YES CLEARING
我在创建的时候出现了下面的错误,但是实际上我已经从磁盘上删除了啊,
SQL> alter database add logfile group 3('D:\oracle\oradata\orcl\REDO03.LOG') size 100m;
alter database add logfile group 3('D:\oracle\oradata\orcl\REDO03.LOG') size 100m
*
ERROR 位于第 1 行:
ORA-01184: 日志文件组3已经存在
我在执行这个话的时:alter database clear logfile group 3;
系统自动的给我创建了一个组,不明白是什么意思,
问题已经解决,谢谢你们~!
现在是:
SQL> select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
1 55 NO INACTIVE
2 56 NO CURRENT
3 0 YES UNUSED
SQL> alter system switch logfile;
系统已更改。
SQL> select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
1 55 NO INACTIVE
2 56 NO ACTIVE
3 57 NO CURRENT
我是从磁盘是直接的删除的, |
|