数据库

位置:IT落伍者 >> 数据库 >> 浏览文章

Oracle10g废弃log


发布日期:2018年04月04日
 
Oracle10g废弃log

在Oracleg中log_archive_start参数已经被废弃只要启动数据库的归档模式Oracle就会启用自动归档从而避免了g以前由于用户疏忽所带来的一系列问题

$ sqlplus / as sysdba

SQL*Plus: Release Production on Wed Apr ::

Copyright (c) OracleAll rights reserved

Connected to:

Oracle Database g Enterprise Edition Release bit Production

With the Partitioning and Data Mining options

SQL> archive log list;

Database log modeNo Archive Mode

Automatic archival Disabled

Archive destinationUSE_DB_RECOVERY_FILE_DEST

Oldest online log sequence

Current log sequence

SQL> show parameter log_archive_start

NAME TYPEVALUE

log_archive_startboolean FALSE

SQL> shutdown immediate;

Database closed

Database dismounted

ORACLE instance shut down

SQL> startup mount;

ORACLE instance started

Total System Global Area bytes

Fixed Size bytes

Variable Size bytes

Database Buffers bytes

Redo Buffers bytes

Database mounted

SQL> alter database archivelog;

Database altered

SQL> alter database open;

Database altered

SQL> archive log list;

Database log modeArchive Mode

Automatic archival Enabled

Archive destinationUSE_DB_RECOVERY_FILE_DEST

Oldest online log sequence

Next log sequence to archive

Current log sequence

SQL>

~

上一篇:ORACLE SQL性能优化系列 (十三)

下一篇:被关在SQL外面破解SA的密码的方法具体的解答