[20171106]修改show spparameter的展现宽度.txt

[20171106]匡正show spparameter的彰显宽度.txt

[20171110]_allow_read_only_corruption参数.txt

–//很齐人有好猎者前做的,改过show parameter的来得宽度.
–//链接: [20121023]改换show
parameter的突显宽度.txt=>

–//明天在改过查询隐含参数脚本时意识八个参数_allow_read_only_corruption,感到应该能够在特别关闭的场地下以read
only张开.
–//本身测量试验看看.

–//前日察觉show
spparameter展现上涨的幅度亦不是很合理,校正看看,并做多少个笔录:

1.环境:

1.环境:
SYS@book> @ &r/ver1
PORT_STRING                    VERSION        BANNER

SYS@book> @ &r/ver1
PORT_STRING                    VERSION        BANNER





x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g
Enterprise Edition Release 11.2.0.4.0 – 64bit Production

x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g
Enterprise Edition Release 11.2.0.4.0 – 64bit Production

SYS@book> show spparameter control_files
SID      NAME                         
TYPE                                     VALUE

SYS@book> @ &r/hide _allow_read_only_corruption
NAME                       
DESCRIPTION                                      DEFAULT_VALUE


SESSION_VALUE SYSTEM_VALUE



_allow_read_only_corruption allow read-only open even if database is
corrupt TRUE          FALSE         FALSE

2.测量检验前计划:

SYS@book> create pfile=’/tmp/init@.ora’ from spfile ;
File created.

–//改良 /tmp/initbook.ora文件,插足如下内容:
*._allow_澳门金沙vip,read_only_corruption=true

–//做三个那些关闭数据库.
SYS@book> shutdown abort ;
ORACLE instance shut down.

SYS@book> startup mount pfile=’/tmp/init@.ora’
ORACLE instance started.
Total System Global Area  634732544 bytes
Fixed Size                  2255792 bytes
Variable Size             197133392 bytes
Database Buffers          427819008 bytes
Redo Buffers                7524352 bytes
Database mounted.

SYS@book> show parameter allow
NAME                        TYPE    VALUE


_allow_read_only_corruption boolean TRUE

–//表明只要配置了参数在参数文件中,隐含参数实际上也得以利用show
parameter.不过像前边带2个下划线参数,show parameter依然无
–//法查询.比如:
SYS@book> show parameter __java_pool_size
SYS@book> @ &r/hide __java_pool_size
NAME              DESCRIPTION                       DEFAULT_VALUE
SESSION_VALUE SYSTEM_VALUE



__java_pool_size  Actual size in bytes of java pool FALSE        
4194304       4194304

SYS@book> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16005: database requires recovery

–//能够发掘不行.也许需求_allow_resetlogs_corruption参数合营.

3.三番两次测量试验:
–//改良 /tmp/initbook.ora文件,插足如下内容:
*._allow_resetlogs_corruption=true

SYS@book> @ &r/logfile
GROUP# STATUS     TYPE       MEMBER                           IS_
GROUP# THREAD# SEQUENCE#       BYTES BLOCKSIZE MEMBERS ARC STATUS    
FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE# NEXT_TIME




     1            ONLINE     /mnt/ramdisk/book/redo01.log     NO      
1       1       728    52428800       512       1 NO  CURRENT     
13277659048 2017-11-09 16:18:09 2.814750E+14
     2            ONLINE     /mnt/ramdisk/book/redo02.log     NO      
2       1       726    52428800       512       1 YES INACTIVE    
13277630208 2017-11-09 09:54:47  13277632611 2017-11-09 10:18:14
     3            ONLINE     /mnt/ramdisk/book/redo03.log     NO      
3       1       727    52428800       512       1 YES INACTIVE    
13277632611 2017-11-09 10:18:14  13277659048 2017-11-09 16:18:09
     4            STANDBY    /mnt/ramdisk/book/redostb01.log  NO
     5            STANDBY    /mnt/ramdisk/book/redostb02.log  NO
     6            STANDBY    /mnt/ramdisk/book/redostb03.log  NO
     7            STANDBY    /mnt/ramdisk/book/redostb04.log  NO
7 rows selected.

$ mv /mnt/ramdisk/book/redo01.log /mnt/ramdisk/book/redo01.log_xxx

–//这样防止找到redo文件.或许假象redo01.log文件损坏了.
SYS@book> shutdown abort ;
ORACLE instance shut down.

SYS@book> startup mount pfile=’/tmp/init@.ora’
ORACLE instance started.
Total System Global Area    634732544 bytes
Fixed Size                    2255792 bytes
Variable Size               197133392 bytes
Database Buffers            427819008 bytes
Redo Buffers                  7524352 bytes
Database mounted.

SYS@book> @ &r/hide allow_r%corrupt%
NAME                       
DESCRIPTION                                      DEFAULT_VALUE