标签归档:归档模式

Oracle 12C 变更归档模式

1.shutdown normal或shutdown immediate关闭数据库

SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 5 14:22:50 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> conn /as sysdba;

SQL> shutdown immediate;

Database closed.
Database dismounted.
ORACLE instance shut down.

2.启动Oracle数据库到mount状态

SQL> startup mount;  

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  3712904 bytes
Variable Size             486541432 bytes
Database Buffers         1644167168 bytes
Redo Buffers               13062144 bytes
Database mounted.

3.启用或停止归档模式

如果要启用归档模式,此处使用alter database archivelog 命令。

如果要关闭归档模式,此处使用alter database noarchivelog 命令。

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            /u01/DEV/db/data/archive
Oldest online log sequence     61
Next log sequence to archive   62
Current log sequence           62

以下是官方参考文档(12C一样的操作方式):

Enable/Disable Archive Log Mode In 10g and 11g ( Doc ID 371139.1 )