- 博客(10)
- 收藏
- 关注
转载 ORA-25153 临时表空间错误
SQL> @e:\oracle\product\10.2.0\db_1\RDBMS\admin\awrextr.sql~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~...
2009-12-16 16:59:19 178
转载 使用SQL_TRACE进行数据库诊断
SQL_TRACE是Oracle提供的用于进行SQL跟踪的手段,是强有力的辅助诊断工具.在日常的数据库问题诊断和解决中,SQL_TRACE是非常常用的方法。本文就SQL_TRACE的使用作简单探讨,并通过具体案例对sql_t...
2009-12-12 01:03:20 132
转载 在线重做日志损坏,故障恢复
statup mountalter system set "_allow_resetlogs_corruption"=true scope=spfile;shutdown immediatestartup mountSQL&...
2009-12-12 00:37:28 128
转载 切换10g归档日志导致的ora-16179和ora-32017
SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startup mountORACL...
2009-12-12 00:35:08 108
转载 重做日志损坏,故障处理
因为那个日志组是当前日志组,正在使用的,造成数据库不能启动,这时不管时添加日志组成员还是删除,由于数据库不能启动到open,因些使用alter database switch logfile;alter database cle...
2009-12-08 10:58:42 880
转载 Unable to Qualify My own Domain name
If DNS is not configured on your server, then I'll make the assumption that sendmail is not needed at all.Therefor...
2009-10-22 15:48:58 896
转载 solaris svcs命令
1.# svcs -a显示系统上所有的服务及其它们的状态.1. disabled Apr_18 svc:/network/rpc/keyserv:default 2. disabled Apr_18 svc:/network/r...
2009-10-22 15:47:06 135
转载 Srvctl start gives crs-0223 and crs-1028.
When you try to start a database using srvctl you get the error below. What is the problem and how to fix ?/home/...
2009-09-30 10:06:08 114
转载 rman中copy 功能使用
一. COPY功能使用1.COPY DATABASERMAN> backup as copy database format ‘/u01/orabak/whole_db_cp_%s_%t.bak’;Star...
2009-09-30 09:38:45 173
转载 利用Oracle threshold(度量阀值)监控表空间(转)
This group of metrics gives you the availability and status of the managed database. Metrics include:Database Stat...
2009-09-30 09:36:12 244
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人