-
编辑 删除
ORA-25153 临时表空间错误
SQL> @e:\oracle\product\10.2.0\db_1\RDBMS\admin\awrextr.sql~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Disclaimer: This ...
-
编辑 删除
使用SQL_TRACE进行数据库诊断
SQL_TRACE是Oracle提供的用于进行SQL跟踪的手段，是强有力的辅助诊断工具.在日常的数据库问题诊断和解决中，SQL_TRACE是非常常用的方法。本文就SQL_TRACE的使用作简单探讨，并通过具体案例对sql_trace的使用进行说...
-
编辑 删除
在线重做日志损坏，故障恢复
statup mountalter system set "_allow_resetlogs_corruption"=true scope=spfile;shutdown immediatestartup mountSQL> select name,status from v$datafile;NAME----------------------------------------------...
-
编辑 删除
切换10g归档日志导致的ora-16179和ora-32017
SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startup mountORACLE instance started.Total System Global Area 285212672 bytesFixed Size &nbs...
-
编辑 删除
重做日志损坏，故障处理
因为那个日志组是当前日志组，正在使用的，造成数据库不能启动，这时不管时添加日志组成员还是删除，由于数据库不能启动到open，因些使用alter database switch logfile;alter database clear logfile group 1;等都...
-
编辑 删除
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.Therefore, to disable the sendmail service in Solaris 10;1) Check that SendMail is under SMF c...
-
编辑 删除
solaris svcs命令
1.# svcs -a显示系统上所有的服务及其它们的状态.1. disabled Apr_18 svc:/network/rpc/keyserv:default 2. disabled Apr_18 svc:/network/rpc/nisplus:default 3. disabled Apr_18 svc:/application/print/server:d...
-
编辑 删除
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/oracle $ srvctl start instance -d RAC –i RAC1PRKP-1001 : Error starting instance...
-
编辑 删除
rman中copy 功能使用
一. COPY功能使用1.COPY DATABASERMAN> backup as copy database format ‘/u01/orabak/whole_db_cp_%s_%t.bak’;Starting backup at 20090910062411allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=28 d...
-
编辑 删除
利用Oracle threshold(度量阀值)监控表空间(转)
This group of metrics gives you the availability and status of the managed database. Metrics include:Database Status、Database Process Check、aximum # of sessions since startup and Availability. ...
