Oracle10g废弃log_archive_start参数

王朝oracle·作者佚名  2008-05-19
窄屏简体版  字體: |||超大  

在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

~

-----

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航