您正在查看 "Oracle" 分类下的文章
2008-06-18 10:46
参考：http://www.eygle.com/archives/2005/10/oracle_hidden_allow_resetlogs_corruption.html
完全恢复数据库，启动的时候报错，system01.dbf文件不同步。
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
System altered.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global |
2008-04-30 17:27
rman备份
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/control_file_backup/sales_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default |
2008-02-01 09:58
问题：
RMAN-03009: failure of backup command on ORA_DISK_4 channel at 02/01/2008 08:58:07
ORA-19504: failed to create file "/mnt/saleslog_1_1915_20080201"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
正确的选项为: -o rw,bg,hard,intr,proto=tcp,vers=3,rsize=32768,wsize=32768,timeo=600 |
2008-01-29 14:41
载自oracle中文技术论坛。从整体上介绍了一个dba的职责和任务等等。
ORACLE数据库管理员应按如下方式对ORACLE数据库系统做定期监控：
(1). 每天对ORACLE数据库的运行状态,日志文件,备份情况,数据
库的空间使用情况,系统资源的使用情况进行检查,发现并解决
问题。
(2). 每周对数据库对象的空间扩展情况,数据的增长情况进行监控,对数据库做健康检查,对数据库对象的状态做检查。
(3). 每月对表和索引等进行Analyze,检查表 |
2008-01-16 13:45
使用命令查看数据文件实际使用的大小和占有率
检查剩余空间
select sum(bytes)/(1024*1024) as free_space,tablespace_name
from dba_free_space
group by tablespace_name;
检查总共容量
Select bytes/(1024*1024) as total_space,name
from v$datafile;
显示百分比
select A.tablespace_name,(1-(A.total)/B.total)*100 used_percent
from (select tablespace_name,sum(bytes) to |
|
| 
