« 更新了一下留言板程序 | Blog首页 | 对即将上线的Oracle10g ASM生产数据库进行备份恢复测试 »
Oracle10g已经废弃log_archive_start参数
作者：eygle |【转载时请务必以超链接形式标明文章原始出处和作者信息及本声明】链接：http://www.eygle.com/archives/2005/04/oracle10gonieul.html
在Oracle10g中，log_archive_start参数已经被废弃，只要启动数据库的归档模式，Oracle就会启用自动归档，从而避免了10g以前由于用户疏忽所带来的一系列问题。
$ sqlplus "/ as sysdba" SQL*Plus: Release 10.1.0.3.0 - Production on Wed Apr 13 09:53:25 2005 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production With the Partitioning and Data Mining options SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 25 Current log sequence 27 SQL> show parameter log_archive_start NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_start boolean FALSE SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 3204448256 bytes Fixed Size 1304912 bytes Variable Size 651957936 bytes Database Buffers 2550136832 bytes Redo Buffers 1048576 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 25 Next log sequence to archive 27 Current log sequence 27 SQL>
By eygle on 2005-04-13 09:48 | Comments (9) | Posted to Backup&Recovery | Edit |Pageviews:
留言 (9)
今天我读ORACLE 10g：high availability with RAC,Flashback & Data guard刚好也看到了，并进行了实际操作，果然如此。
Posted by: llb711116 at May 4, 2005 4:25 PM
那存放归档日志的目录用那个参数定义？
USE_DB_RECOVERY_FILE_DEST是否为log_archive_dest
Posted by: xuzf at March 14, 2006 12:37 PM
缺省的归档使用闪回区.
本站有很多相关内容的
Posted by: eygle at March 14, 2006 2:15 PM
请问eygle,OS为solaris,DB为10.2g
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 11
Next log sequence to archive 13
Current log sequence 13
是否每次shutdown后archive会自动enable 呢????
Posted by: microx at February 2, 2008 10:46 PM
开启归档模式之后，就会一直有效，直到你关闭归档模式。
Posted by: Julia at February 2, 2008 11:20 PM
不错，大师的老婆又忘成为另一个高级的DBA。
Posted by: bosonmaster at February 3, 2008 11:49 AM
问题是一旦set log_archive_start=true scope=spfile,之后,每次重新启动oracle都会报ORA-32004: obsolete and/or deprecated parameter(s) specified
怎么样去掉该参数?
Posted by: Frank at March 28, 2008 7:02 PM
可以
create pfile from spfile;
修改参数，再
create spfile from pfile;
Posted by: eygle at March 30, 2008 9:21 PM
SQL>ALTER SYSTEM RESET log_archive_start SCOPE=SPFILE SID='*';
Posted by: time at April 17, 2008 3:33 PM
