Backup&Recovery
2005-04-13
Oracle10g已经废弃log_archive_start参数
在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>
~
历史上的今天
- 2017-04-13 关于Oracle 12.2 Sharding,你想知道的都在这里
- 2013-04-13 至走在Oracle DBA路上那些具有紧迫感的兄弟们
- 2011-04-13 Oracle公司发布2011年第三季度财报
- 2010-04-13 ACOUG 北京第二次活动接受报名
- 2009-04-13 Oracle10g安装中的NetWork和crt1.o错误
- 2007-04-13 清华大学出版社的系列图书
- 2006-04-13 Eygle.com两周年庆
今天我读ORACLE 10g:high availability with RAC,Flashback & Data guard刚好也看到了,并进行了实际操作,果然如此。
那存放归档日志的目录用那个参数定义?
USE_DB_RECOVERY_FILE_DEST是否为log_archive_dest
缺省的归档使用闪回区.
本站有很多相关内容的
请问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 呢????
开启归档模式之后,就会一直有效,直到你关闭归档模式。
不错,大师的老婆又忘成为另一个高级的DBA。
问题是一旦set log_archive_start=true scope=spfile,之后,每次重新启动oracle都会报ORA-32004: obsolete and/or deprecated parameter(s) specified
怎么样去掉该参数?
可以
create pfile from spfile;
修改参数,再
create spfile from pfile;
SQL>ALTER SYSTEM RESET log_archive_start SCOPE=SPFILE SID='*';
但是alter database archivelog manual;后查看archive log list
自动归档怎么还是Enabled????