在Oracle
g中
只要启动数据库的归档模式
Oracle就会启用自动归档
从而避免了
g以前由于用户疏忽所带来的一系列问题
$ sqlplus / as sysdba
SQL*Plus: Release Production on Wed Apr ::
Copyright (c) Oracle All 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 mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence
Current log sequence
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 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 mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence
Next log sequence to archive
Current log sequence
SQL>
