－，查看oracle归档模式SQLgt; conn evan/evan (dba)Connected.SQLgt; archive log listORA-01031: insufficient privilegesS
－，查看oracle归档模式
sql> conn evan/evan (dba)
connected.
sql> archive log list
ora-01031: insufficient privileges
sql> conn / as sysdba --archive log list需要以sysdba执行
connected.
sql> archive log list
database log mode no archive mode
automatic archival disabled
archive destination use_db_recovery_file_dest
oldest online log sequence 2
current log sequence 4
查询v$database
sql> select name,log_mode from v$database;
name log_mode
--------- ------------
oralife noarchivelog
二，修改归档模式
归档日志位置,oracle 10g可以生成多份一样的日志，保存多个位置，，以防不测
sql> alter system set log_archive_dest_1='location=/oracle/10g/oracle/log/archive_log';
system altered.
sql> alter system set log_archive_dest_2='location=/oracle/10g/oracle/log/archive_log2';
system altered.
sql> shutdown immediate
ora-01031: insufficient privileges
sql> conn / as sysdba
connected.
sql> shutdown immediate
database closed.
database dismounted.
oracle instance shut down.
sql> startup mount
oracle instance started.
total system global area 528482304 bytes
fixed size 1220360 bytes
variable size 163578104 bytes
database buffers 356515840 bytes
redo buffers 7168000 bytes
database mounted.
sql> alter database archivelog; －－设置归档模式
database altered.
sql> alter database open;
database altered.
配置归档文件格式(从oracle 10g 开始，必须带有%s,%t,%r)
sql> alter system set log_archive_format="archive_%t_%s_%r.arclog" scope=spfile;
system altered.
sql> shutdown immediate
database closed.
database dismounted.
oracle instance shut down.
sql> startup mount
oracle instance started.
total system global area 528482304 bytes
fixed size 1220360 bytes
variable size 163578104 bytes
database buffers 356515840 bytes
redo buffers 7168000 bytes
database mounted.
sql> archive log list －－查看是否归档
database log mode archive mode
automatic archival enabled －－已开启自动归档
archive destination /oracle/10g/oracle/log/archive_log2
oldest online log sequence 2
next log sequence to archive 4
current log sequence 4
sql> select destination from v$archive_dest; －－查看归档日志位置
destination
--------------------------------------------------------------------------------
/oracle/10g/oracle/log/archive_log
/oracle/10g/oracle/log/archive_log2
10 rows selected.
还可以配置归档进程个数
alter system set log_archive_max_processes=n
