Tag Archives: redo file

隐含参数_DISABLE_LOGGING导致数据库的损坏

Oracle不推荐修改隐含参数,尤其是对于你不了解的隐含参数,修改的后果可能很严重。 比如如果设置了_DISABLE_LOGGING参数为TRUE: _disable_logging = TRUE_disable_logging = true 那么启动数据库后进行任何的操作,在关闭数据库后,就会发现数据库出现了损坏: SQL> ALTER system checkpoint; System altered. SQL> shutdown abort ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 6.2268E+10 bytes Fixed SIZE 2243512 bytes Variable SIZE 4160750664 bytes … Continue reading

Posted in ORACLE | Tagged , , , , , | Leave a comment