Oracle 设置归档与非归档模式

－，查看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