- 博客(6)
- 收藏
- 关注
转载 RMAN backupset renaming or relocation
version : Oracle 10g R2 Here is the solution if in case we need to restore the backup from diffrent location in RMAN. Scenerio is given below...... 1.we took backup on /u01 for our Database. 2.we copi
2006-10-17 18:48:00 526
转载 Display locked objects in a 10g database
-- Search for locked objects-- To be executed under the SYSTEM account-- Compatible with Oracle10.1.x and higherselect distinct to_name object_lockedfrom v$object_dependency where to_address in(sel
2006-10-09 21:38:00 497
转载 Creating OS authenticated external user in windows
How to create external user in simple steps:---- 1.start--->settings--->control panel--->administrative tools---->computer management-->user Now create new user 2.clik on groups---->add to ora_dba the
2006-10-09 21:34:00 487
原创 redo坏了
第一种情况:redo坏了是在数据库关闭后SQL>recover database until cancel;SQL>alter database open resetlogs;第二种情况:多于member在group中, 如果有多于一个则还是可以直接clear 好了
2006-10-02 19:45:00 483
转载 我对PGA、sharedpool 、library cache的理解
我对PGA、sharedpool 、library cache的理解现在比较清楚了,现总结一下,以便其他人能参考。请大家指正当SQL开始执行时:1、首先在PGA中进行语法、语义检查,(当然还有打开CURSOR等),通过检查后,消耗CPU资源进行SQL HASH VALUE的计算。2、计算出HASH VALUE后,申请library cache latch,到library cache中检查是否
2006-10-02 19:29:00 994
原创 Rman中如何注销目录中已注册的数据库
注销数据库需要db_key和db_id两个值$sqlplus rman/rmanSQL>select * from db;SQL> exec dbms_rcvat.unregisterdatabase(db_key,db_id)
2006-10-02 19:28:00 612
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人