oracle10自动归档模式设定

自动归档模式设置

在Oracle 10g里启动自动归档模式
在Oracle10g中，只要启动数据库的归档模式，Oracle就会启用自动归档，从而避免了10g以前由于用户疏忽所带来的一系列问题。
$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.1.0.3.0 - Production on Wed Apr 13 09:53:25 2005
Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit 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     25
Current log sequence           27
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 3204448256 bytes
Fixed Size                  1304912 bytes
Variable Size             651957936 bytes
Database Buffers         2550136832 bytes
Redo Buffers                1048576 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     25
Next log sequence to archive   27
Current log sequence           27
另外：
Oracle 10g数据库物理空间管理方式与以前Oracle发生了变化，对归档日志所在的Flash_Recovery_Area空间进行了另外限制
Flash_Recovery_Area空间缺省安装时比较小，只有2GB，容易用完

解决过程
　　根据数据库目前可用存储空间情况、FLASH_RECOVERY_AREA空间为2GB的实际情况，把FLASH_RECOVERY_AREA的空间修改为20GB。
SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=20g;
系统已更改。若空间大，可设为50G
否则出现出错提示：
ORA-00257: archiver error. Connect internal only, until freed.

                                         如何更改归档日志存放路径
方法一：直接修改pfile文件来实现
1。SQL>create pfile from spfile；
2。SQL>shutdown;
3。SQL>startup nomount;
4。修改pfile文件：
*.db_recovery_file_dest='/export/home/oracle/flash_recovery_area'
修改成：
*.db_recovery_file_dest='/gxu/flash_recovery_area'
5。SQL>create spfile from pfile；
6。SQL>alter database open;
即可
方法二：用命令来实现
1。SQL>alter system set db_recovery_file_dest='/gxu/flash_recovery_area'；
2。SQL>shutdown immediate;
3。SQL>startup
即可

   注意：如果要在归档模式下改成非归档模式，如下：
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 3204448256 bytes
Fixed Size                  1304912 bytes
Variable Size             651957936 bytes
Database Buffers         2550136832 bytes
Redo Buffers                1048576 bytes
Database mounted.
SQL> alter database noarchivelog;
Database altered.
SQL> alter database open;
Database altered.