ORACLE归档模式切换

在数据库安装时可以选择归档模式，也可以在数据库安装完成后切换成归档模式。模式的切换只能在mount状态下执行，如果在open状态下执行，则会报如下的错误：

SQL> alter database noarchivelog;

alter database noarchivelog

*

ERROR at line 1:

ORA-01126: database must be mounted in this instance and not open in any

instance

如果在nomount状态下执行，则会报如下错误：

SQL> alter database noarchivelog;

alter database noarchivelog

*

ERROR at line 1:

ORA-01507: database not mounted

归档切换到非归档

在数据库mount阶段执行alter database noarchivelog;

SQL> archive log list;

Database log mode       Archive Mode#原先为归档模式

Automatic archival       Enabled

Archive destination       USE_DB_RECOVERY_FILE_DEST #归档文件存放的位置

Oldest online log sequence     129

Next log sequence to archive   131

Current log sequence       131

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area  776646656 bytes

Fixed Size    2217384 bytes

Variable Size  482347608 bytes

Database Buffers  289406976 bytes

Redo Buffers    2674688 bytes

Database mounted.

SQL> alter database noarchivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;

Database log mode       No Archive Mode

Automatic archival       Disabled

Archive destination       USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     129

Current log sequence       131

非归档切换到归档

1、继续面的例子，当前数据库处于非归档模式，如果直接修改成归档模式，那么归档日志存放的位置为DB_RECOVERY_FILE_DEST。

SQL> show parameter db_recovery

NAME     TYPE VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest     string /u01/app/oracle/flash_recovery_area

db_recovery_file_dest_size     big integer 3882M

闪回恢复区只有3882M的空间，如果不满足需要，可以修改归档的位置。

SQL> alter system set log_archive_dest_1="location=/u01/app/oracle/archive";

2、关闭数据库，然后启动到mount状态

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database archivelog;

SQL> alter database open;

SQL> archive log list;

Database log mode       Archive Mode

Automatic archival       Enabled

Archive destination       /u01/app/oracle/archive

Oldest online log sequence     129

Next log sequence to archive   131

Current log sequence       131

本文出自 “三国冷笑话” 博客，请务必保留此出处http://myhwj.blog.51cto.com/9763975/1887026

ORACLE归档模式切换

原文：http://myhwj.blog.51cto.com/9763975/1887026