首页 > 数据库 > Oracle > Oracle数据库日常维护手册
select tablespace_name,
count(*) chunks ,
max(bytes/1024/1024) max_chunk
from dba_free_space
group by tablespace_name;
TABLESPACE_NAME CHUNKS MAX_CHUNK
-------------------- ---------- ----------
INDX 1 57.9921875
RBS 3 490.992188
RMAN_TS 1 16.515625
SYSTEM 1 207.296875
TEMP 20 70.8046875
TOOLS 1 11.8359375
USERS 67 71.3671875
alter tablespace 表空间名 coalesce;
select sid,serial#,username,program,machine,status
from v$session;
SID SERIAL# USERNAME PROGRAM MACHINE STATUS
---- ------- ---------- ----------- --------------- --------
1 1 ORACLE.EXE WORK3 ACTIVE
2 1 ORACLE.EXE WORK3 ACTIVE
3 1 ORACLE.EXE WORK3 ACTIVE
4 1 ORACLE.EXE WORK3 ACTIVE
5 3 ORACLE.EXE WORK3 ACTIVE
6 1 ORACLE.EXE WORK3 ACTIVE
7 1 ORACLE.EXE WORK3 ACTIVE
8 27 SYS SQLPLUS.EXE WORKGROUPWORK3 ACTIVE
11 5 DBSNMP dbsnmp.exe WORKGROUPWORK3 INACTIVE
alter system kill session 'SID,SERIAL#';
alter database
backup controlfile to '/home/backup/control.bak';
alter database
backup controlfile to trace;
select file_name,status
from dba_data_files;
select job,log_user,last_date,failures
from dba_jobs;
ORA-01578: ORACLE data block corrupted (file # 7, block # )
ORA-01110: data file : '/oracle1/oradata/V920/oradata/V816/users01.dbf'
SELECT tablespace_name,
segment_type,
owner,
segment_name
FROM dba_extents
WHERE file_id =
AND
between block_id AND block_id+blocks-1;
exec DBMS_REPAIR.SKIP_CORRUPT_BLOCKS(' ','');
create table corrupt_table_bak
as
select * from corrupt_table;
drop table corrup_tatble;
alter table corrupt_table_bak
rename to corrupt_table;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/262387/viewspace-851592/,如需转载,请注明出处,否则将追究法律责任。