有关oracle数据库的解决方案

1、谢谢观赏有关oracle数据库的解决方案1有关Oracle数据库的解决方案问题:Oracle数据库的OWSYSP表格被破坏,在没有备份的情况下，它能够以某种方式被恢复。在shell窗口下，执行orastat命令，可以看到下列出错信息:ORA-01115IOerrorreadingblockfromfile7ORA-01110datafile7:/owsysp_tbs.dbf解决步骤概括如下（注意:至少需要同时打开两个xterm窗口）:1. 在xterm（1）窗口登录进入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,并且执行下列命令: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);注意:你必须为各个存在的工区输入口令,为了获得工区和口令列表,执行下列查询: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;改变当前工区的口令用以匹配你上面插入的条目SQL>commit;SQL>exit;6. 你现在将能够成功地启动oracle数据库,但是我们将

7、首先关掉它sun1oracle#dbshutsun1oracle#lsnrctlstartsun1oracle#dbstart7. 执行orastat命令，确认每件事情都恢复正常.如果orastat报告log文件失效,你可以按如下所说解决这个问题:8. 如果oracle数据库正在运行，就关掉它，输入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文件的失效状态。10 .关掉oracle数据库并重新启动它.运行orastat