Oracle 设置归档模式-优快云博客

本文链接：https://blog.youkuaiyun.com/cranedingNO1/article/details/84598569

本文详细介绍了如何通过Sqlplus登录数据库并查看归档状态，包括更改数据库日志模式为存档模式的具体步骤，以及如何确认更改成功。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[b]登录Sqlplus，查看数据库归档状态[/b]


SQL> sqlplus /nolog
SQL> conn / as sysdba

[b]查看当前数据库的归档状态[/b]


SQL> archive log list;
Database log mode	       No Archive Mode
Automatic archival	       Disabled
Archive destination	       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     9
Current log sequence	       11

[b]关闭数据库，并以装载方式启动[/b]


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

Total System Global Area 1.3362E+10 bytes
Fixed Size		    2217952 bytes
Variable Size		 6777997344 bytes
Database Buffers	 6576668672 bytes
Redo Buffers		    4960256 bytes
Database mounted.

[b]更改数据库日志模式为存档模式[/b]


SQL> alter database archivelog;

Database altered.

[b]启动数据库，确认日志模式已更改为存档模式[/b]


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     9
Next log sequence to archive   11
Current log sequence	       11