1、 确定数据库当前以哪种归档模式运行。
以sys用户登录数据库,通过archive log list命令来确认当前数据库是否采用归档模式。
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 24 14:41:21 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing 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 14
Current log sequence 16
2、 关闭数据库
只有在mount状态,才可以更改ARCHIVELOG 模式,因此先关闭数据库。
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
3、 装载数据库
SQL> startup mount
ORACLE instance started.
Total System Global Area 707244032 bytes
Fixed Size 1338868 bytes
Variable Size 511705612 bytes
Database Buffers 188743680 bytes
Redo Buffers 5455872 bytes
Database mounted.
4、 将数据库更改为使用ARCHIVELOG 模式。
SQL> alter database archivelog;
Database altered.
5、 打开数据库
SQL> alter database open;
Database altered.
6、 验证数据库归档模式修改结果(两种方式均可)
SQL> select name,log_mode from v$database;
NAME LOG_MODE
--------- ------------
ORCL ARCHIVELOG
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 15
Next log sequence to archive 17
Current log sequence 17
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/438414/viewspace-756946/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/438414/viewspace-756946/