eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 更新了一下留言板程序 | Blog首页 | 对即将上线的Oracle10g ASM生产数据库进行备份恢复测试 »

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文章:
    >> 2013-04-13文章:
    >> 2011-04-13文章:
    >> 2010-04-13文章:
    >> 2009-04-13文章:
    >> 2007-04-13文章:
    >> 2006-04-13文章:
           Eygle.com两周年庆

无觅

By eygle on 2005-04-13 09:48 | Comments (10) | Backup&Recovery | 253 |

10 Comments

今天我读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????


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com