Shulou(Shulou.com)06/01 Report--

This article mainly explains the "oracle hidden parameters of the view and use", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "oracle hidden parameters of the view and use" it!

Today, in the forum, a friend asked a question, in non-archive mode, one of the data files will be offline, and then the database has switched a lot of logs, restarted, has not been backed up, and now want to online the previous data files, the results can be imagined, how to analyze and deal with them?

In a situation like this, it almost never happens in a general production environment, but if you encounter it, you have to face the analysis and solve it. My first intuition tells me that you need to use the hidden parameters of oracle for forced recovery. Of course, there are other means. Here, how to view the hidden parameters of oracle is briefly introduced as follows:

Hidden parameter (hidden parameters), used internally by oracle, starting with'_'.

You can view all hidden parameters in two ways:

1.

SELECT i.ksppinm name

I.ksppdesc description

CV.ksppstvl VALUE

CV.ksppstdf isdefault

DECODE (BITAND (CV.ksppstvf, 7)

one,

'MODIFIED'

four,

'SYSTEM_MOD'

'FALSE') ismodified

DECODE (BITAND (CV.ksppstvf, 2), 2, 'TRUE',' FALSE') isadjusted

FROM sys.x$ksppi i, sys.x$ksppcv CV

WHERE i.inst_id = USERENV ('Instance')

AND CV.inst_id = USERENV ('Instance')

AND i.indx = CV.indx

AND i.ksppinm LIKE'/ _% 'ESCAPE' /'

ORDER BY REPLACE (i.ksppinm,'_','')

two。

SELECT ksppinm, ksppstvl, ksppdesc

FROM x$ksppi x, x$ksppcv y

WHERE x.indx = y.indx

AND TRANSLATE (ksppinm,'_','#') LIKE'#%'

Example: if you want to view the parameter values of _ allow_resetlogs_corruption

SELECT ksppinm, ksppstvl, ksppdesc

FROM x$ksppi x, x$ksppcv y

WHERE x.indx = y.indx

AND ksppinm ='_ allow_resetlogs_corruption'

Thank you for your reading, these are the contents of "viewing and using oracle Hidden parameters". After the study of this article, I believe you have a deeper understanding of the problem of viewing and using oracle hidden parameters, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.