在Oracle10g中,log_archive_start参数已经被废弃,只要启动数据库的归档模式,Oracle就会启用自 动归档,从而避免了10g以前由于用户疏忽所带来的一系列问题。
$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 8 21:03:52 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance.
SQL> startup ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1218316 bytes Variable Size 62916852 bytes Database Buffers 100663296 bytes Redo Buffers 2973696 bytes Database mounted. Database opened.
SQL> show parameter log_archive_start NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_start boolean TRUE 经测试就算改成false还是不行。 接下来将log_archive_start参数reset成默认值。
SQL> alter system reset log_archive_start scope=spfile sid='*'; System altered.
SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down.
SQL> startup ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1218316 bytes Variable Size 62916852 bytes Database Buffers 100663296 bytes Redo Buffers 2973696 bytes Database mounted. Database opened.
ok,竟然可以正常打开了。
SQL> show parameter log_archive_start NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_start boolean FALSE
其实这里查询到,默认值也是false,但是为什么设置成false就不行了呢? 据推测,可能就算手动改成false数据库也认为人为动过这个参数吧。
看看都有哪些参数是废弃的: select name,description from v$parameter where isdeprecated='TRUE';
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24496749/viewspace-723264/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24496749/viewspace-723264/