非归档模式切换到归档模式

手动更改归档模式一般大多在需要做热备之前所做的前提动作，其实很简单，就像是我们要开车之前要先发动车，使发动机处于运转状态一样（举例不太恰当^_^）。

由非归档改到归档包含以下几步：

1.准备及检视动作：

conn / as sysdba(登录数据库)

select status from v$instance;(若处于open状态，继续下一步)

archive log list(查看归档情况)

df -k(查看空间使用状况，并确定和准备好归档路径，最好是测算一下归档日志大小，并根据归档备份后删除的备份周期来确定所需空间大小，若归档目录被撑满，会导致db hung起来。)

2.修改动作：三参数一启动

修改三参数为制定值或格式：log_archive_dest_1、log_archive_start、log_archive_format。

mount状态下手动启动一下归档模式：alter database archivelog;

以上即可。

附：实例
[root@db ~]# su - oracle
[oracle@db ~]$ df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/cciss/c0d0p2 20635732 1145600 18441892 6% /
/dev/cciss/c0d0p1 1027768 17692 957868 2% /boot1
none 2074640 0 2074640 0% /dev/shm
/dev/cciss/c0d0p12 5036284 43432 4737020 1% /home
/dev/cciss/c0d0p8 20635700 6238676 13348788 32% /opt
/dev/cciss/c0d0p3 7787744 2761264 4630880 38% /oraarch
/dev/cciss/c0d0p5 30233896 77888 28620196 1% /oradata
/dev/cciss/c0d0p11 10317828 55912 9737800 1% /tmp
/dev/cciss/c0d0p6 10317828 3376660 6417052 35% /u01
/dev/cciss/c0d0p10 20635700 6134072 13453392 32% /usr
/dev/cciss/c0d0p9 10317828 222748 9570964 3% /var
[oracle@db ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jul 13 14:35:40 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

SQL> archive log list
ORA-01034: ORACLE not available
SQL> startup
ORACLE instance started.

Total System Global Area 1477515824 bytes
Fixed Size 453168 bytes
Variable Size 637534208 bytes
Database Buffers 838860800 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/oracle/dbs/arch
Oldest online log sequence 3
Current log sequence 5
SQL> alter system set log_archive_dest_1="location=/oraarch" scope=spfile;

System altered.

SQL> alter system set log_archive_start=true scope = spfile;

System altered.

SQL> alter system set log_archive_format='hfpec10_%S_%T.arch' 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 1477515824 bytes
Fixed Size 453168 bytes
Variable Size 637534208 bytes
Database Buffers 838860800 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Disabled
Archive destination /oraarch
Oldest online log sequence 3
Next log sequence to archive 5
Current log sequence 5

SQL> alter database open;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1477515824 bytes
Fixed Size 453168 bytes
Variable Size 637534208 bytes
Database Buffers 838860800 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oraarch
Oldest online log sequence 5
Next log sequence to archive 7
Current log sequence 7
SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30383/viewspace-927869/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30383/viewspace-927869/