你首先看下你的数据库空间的使用情况: select sum(bytes)/1024/1024||'M',tablespace_name from dba_Data_files group by tablespace_name;这个是表空间的大小,然后在查看剩余空间的情况 select sum(bytes)/1024/1024||'M',tablespace_name from dba_free_space group by tablespace_name; 如果是临时表空间过大,就先建立个临时表空间然后将ORACLE临时表空间切换,删除原来表空间及文件,然后在看其他空间的情况,把他们列出来,看是不是ORACLE的问题
group by tablespace_name;这个是表空间的大小,然后在查看剩余空间的情况 select sum(bytes)/1024/1024||'M',tablespace_name from dba_free_space
group by tablespace_name;
如果是临时表空间过大,就先建立个临时表空间然后将ORACLE临时表空间切换,删除原来表空间及文件,然后在看其他空间的情况,把他们列出来,看是不是ORACLE的问题
---
现在数据库没法启动起来啊不要乱做,把你的归档日志清空就可以了,然后重新启动数据库,就ok!
---
请问如何清空归档日志,不好意思我才学oracle没多久
再查看一下Oracle安装目录下bdump中的alert_***.log,找出出现的异常问题,
再分析原因。
$ df -v
安装 Dir 文件系统 块 用了 空闲 %使用
/ /dev/dsk/c1t0d0 4133838 1846521 2245979 46%
/usr /dev/dsk/c1t0d0 1988887 1058369 870852 55%
/proc /proc 0 0 0 0%
/dev/fd fd 0 0 0 0%
/etc/mntta mnttab 0 0 0 0%
/var /dev/dsk/c1t0d0 1988887 50560 1878661 3%
/var/run swap 1473331 3 1473328 1%
/tmp swap 1473333 5 1473328 1%
/opt /dev/dsk/c1t0d0 10086988 1788322 8197797 18%
/data-cent /dev/md/dsk/d0 211727437 9 209610154 1
/export/ho /dev/dsk/c1t0d0 44068002 43362339 264983 100%
Tue Dec 14 11:52:26 2004
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water = 7
Tue Dec 14 11:53:10 2004
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water = 7
Wed Dec 15 10:17:47 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 117440512
large_pool_size = 16777216
java_pool_size = 117440512
control_files = /export/home/oracle/oradata/ora92/control01.ctl, /export/home/oracle/oradata/ora92/control02.ctl, /export/home/oracle/oradata/ora92/control03.ctl
db_block_size = 8192
db_cache_size = 33554432
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = ora92
dispatchers = (PROTOCOL=TCP) (SERVICE=ora92XDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /export/home/oracle/admin/ora92/bdump
user_dump_dest = /export/home/oracle/admin/ora92/udump
core_dump_dest = /export/home/oracle/admin/ora92/cdump
sort_area_size = 524288
db_name = ora92
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Dec 15 10:17:49 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
我用archive log list 查看归档模式为noARCHIVELOG,自动归档模式也是禁用的.
我在oradata目录下看到好多大文件如下:
-rw-r----- 1 oracle dba 2023424 12月 14 11:54 control01.ctl
-rw-r----- 1 oracle dba 2023424 12月 14 11:54 control02.ctl
-rw-r----- 1 oracle dba 2023424 12月 14 11:54 control03.ctl
-rw-r--r-- 1 oracle dba 20979712 12月 14 02:25 cwmlite01.dbf
-rw-r--r-- 1 oracle dba 20979712 12月 14 02:25 drsys01.dbf
-rw-r--r-- 1 oracle dba 156639232 12月 14 02:25 example01.dbf
-rw-r--r-- 1 oracle dba 26222592 12月 14 02:25 indx01.dbf
-rw-r--r-- 1 oracle dba 20979712 12月 14 02:25 odm01.dbf
-rw-r----- 1 oracle dba 104858112 12月 14 01:54 redo01.log
-rw-r----- 1 oracle dba 104858112 12月 14 11:51 redo02.log
-rw-r----- 1 oracle dba 104858112 12月 12 20:10 redo03.log
-rw-r--r-- 1 oracle dba 650125312 12月 14 11:51 system01.dbf
-rw-r--r-- 1 oracle dba 22321045504 8月 13 20:27 temp01.dbf
-rw-r--r-- 1 oracle dba 10493952 12月 14 02:25 tools01.dbf
-rw-r--r-- 1 oracle dba 1263542272 12月 14 11:51 undotbs01.dbf
-rw-r--r-- 1 oracle dba 5942484992 12月 14 02:25 users01.dbf
-rw-r----- 1 oracle dba 209723392 2003 1月 27 users02.dbf
-rw-r--r-- 1 oracle dba 39985152 12月 14 02:25 xdb01.dbf
我算了一下总大小是31003846144单位如果是字节的话就有28.8G了会不会是它们,该怎 么办啊?
将某个数据库文件offlinesvrmgr>alter database dafafies '数据文件' offline drop;
svrmgr>startup mount;
alter database dafafies '数据文件' online drop?
谢谢
我用select sum(bytes)/1024/1024||'M',tablespace_name from dba_Data_files group by tablespace_name;查询后如下:
1 20M CWMLITE
2 20M DRSYS
3 149.375M EXAMPLE
4 25M INDX
5 20M ODM
6 620M SYSTEM
7 10M TOOLS
8 1205M UNDOTBS1
9 5667.1875M USERS
10 38.125M XDB
用select sum(bytes)/1024/1024||'M',tablespace_name from dba_free_space group by tablespace_name;查询后如下:
1 10.625M CWMLITE
2 10.3125M DRSYS
3 .5M EXAMPLE
4 24.9375M INDX
5 10.625M ODM
6 6.875M SYSTEM
7 9.9375M TOOLS
8 1183.6875M UNDOTBS1
9 5010.5625M USERS
10 .1875M XDB
现在该怎么做啊?谢谢