有關(guān)oracle數(shù)據(jù)庫的解決方案

1、謝謝觀賞有關(guān)oracle數(shù)據(jù)庫的解決方案1有關(guān)Oracle數(shù)據(jù)庫的解決方案問題:Oracle數(shù)據(jù)庫的OWSYSP表格被破壞,在沒有備份的情況下，它能夠以某種方式被恢復(fù)。在shell窗口下，執(zhí)行orastat命令，可以看到下列出錯信息:ORA-01115IOerrorreadingblockfromfile7ORA-01110datafile7:/owsysp_tbs.dbf解決步驟概括如下（注意:至少需要同時打開兩個xterm窗口）:1. 在xterm（1）窗口登錄進(jìn)入oracle帳號,su-oracle,sun1oracle#svrmgrlSVRMGR>connectinternalS

2、VRMGR>startupmountSVRMGR>alterdatabasedatafile'/home1/OpenWorks/oracle/dbs/owsysp_tbs.dbf'offlinedrop;SVRMGR>alterdatabaseopen;SVRMGR>droptablespaceowsyspincludingcontentscascadeconstraints;2. 在xterm（2）窗口，su-oracle,并且執(zhí)行下列命令:sun1oracle#rm/home1/OpenWorks/oracle/dbs/owsysp_tbs.dbf3

3、. 返回到xterm(1)窗口，作SVRMGR>createtablespaceOWSYSPdatafile'/home1/OpenWorks/oracle/dbs/owsysp_tbs.dbf'size1M;SVRMGR>grantDBAtoowsyspwithADMINOPTION;SVRMGR>grantcreateprocedure,createsynonym,createtable,2 >createsequence,createdatabaselink,createtrigger,3 >createsession,createviewt

4、oowsysp;4 .返回到xterm(2)窗口，作sun1oracle44#$ORACLE_HOME/bin/impowsysp/owsyspINCTYPE=restoreFULL=yFILE=/home1/OpenWorks/dat/owsys/owsysp.dmp5 .返回到xterm(1)窗口，作SVRMGR>connectowsysp/owsysp;SVRMGR>exit;Sun1oracle65#sqlplusowsysp/owsyspSQL>INSERTINTOow_sysp_prj_security2 (project_name,passwd,create_d

5、ate,create_user_id)3 VALUES4 ('OWSYS','OWSYS',SYSDATE,USER);SQL>INSERTINTOow_sysp_prj_security5 (project_name,passwd,create_date,create_user_id)6 VALUES7 ('LMSYS','LMSYS',SYSDATE,USER);注意:你必須為各個存在的工區(qū)輸入口令,為了獲得工區(qū)和口令列表,執(zhí)行下列查詢:SVRMGR>selectusername,user_id,passwordf

6、romsys.dba_users;SQL>INSERTINTOow_sysp_prj_security8 (project_name,passwd,create_date,create_user_id)9 VALUES10 ('STWTST','30CA2A3A95BA8EEE',SYSDATE,USER);注意:或者,二者選一,你能夠提交你想要的條目，然后使用它ALTERUSERIDENTIFIEDBY;改變當(dāng)前工區(qū)的口令用以匹配你上面插入的條目SQL>commit;SQL>exit;6. 你現(xiàn)在將能夠成功地啟動oracle數(shù)據(jù)庫,但是我們將

7、首先關(guān)掉它sun1oracle#dbshutsun1oracle#lsnrctlstartsun1oracle#dbstart7. 執(zhí)行orastat命令，確認(rèn)每件事情都恢復(fù)正常.如果orastat報告log文件失效,你可以按如下所說解決這個問題:8. 如果oracle數(shù)據(jù)庫正在運行，就關(guān)掉它，輸入svrmgrlsun1oracle#svrmgrlSVRMGR>connectinternalSVRMGR>startupnomountSVRMGR>alterdatabasemountexclusive;SVRMGR>select*fromv$logfile;GROUP#S

8、TATUSMEMBER1STALE/home2/oracle/dbs/logg1m1owsun1.dbf1 STALE/home1/Openworks/oracle/dbs/logg1m2owsun1.dbf2 /home2/oracle/dbs/logg2m1owsun1.dbf3 /home1/OpenWorks/oracle/dbs/logg2m2owsun1.dbf4 /home2/oracle/dbs/logg3m1owsun1.dbf3/home1/OpenWorks/oracle/dbs/logg3m2owsun1.dbfSVRMGR>alterdatabasedroplogfilegroup1;SVRMGR>alterdatabaseaddlogfilegroup12>('/home2/oracle/dbs/logg1m1owsun1.dbf','/home1/OpenWorks/oracle/dbs/logg1m2owsun1.dbf')1 >size8Mreuse;SVRMGR>exit9 .這樣將能夠照顧到log文件的失效狀態(tài)。10 .關(guān)掉oracle數(shù)據(jù)庫并重新啟動它.運行orastat