合 Oracle配置隐含参数_allow_resetlogs_corruption用来忽略一致性检查强制启动数据库
Tags： Oracle隐含参数一致性检查强制_allow_resetlogs_corruption
👉 本文共约22个字，系统预计阅读时间或需1分钟。
目录
常用SQL
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 | SELECT * FROM gv$parameter a WHERE a.NAME like '_%' escape '' ; SELECT * FROM gv$parameter a WHERE a.NAME like '=_%' escape '=' ; recover database using backup controlfile until cancel; alter system set "_allow_resetlogs_corruption"=true scope=spfile; alter system set "_allow_resetlogs_corruption"=false scope=spfile; -- 默认 alter system reset "_allow_resetlogs_corruption" scope=spfile sid='*'; SET PAGESIZE 9999 SET LINE 9999 COL NAME FORMAT A40 COL KSPPDESC FORMAT A50 COL KSPPSTVL FORMAT A20 SELECT A.INDX, A.KSPPINM NAME, A.KSPPDESC, B.KSPPSTVL FROM X$KSPPI A, X$KSPPCV B WHERE A.INDX = B.INDX AND LOWER(A.KSPPINM) LIKE LOWER('%&PARAMETER%'); alter system set "_allow_resetlogs_corruption"=true scope=spfile; recover database using backup controlfile until cancel; alter database open resetlogs; startup force alter database open resetlogs; alter system set "_allow_resetlogs_corruption"=false scope=spfile; alter system reset "_allow_resetlogs_corruption" scope=spfile sid='*'; |
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
