启用归档模式
[root@oadb /]# su - oracle
[oracle@oadb ~]$ sqlplus sys / 密码 as sysdba;
SQL*Plus: Release 11.2.0.4.0 Production on Sat Apr 1 09:30:16 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
- Connected to:
- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- SQL> alter system set log_archive_dest_1='LOCATION=/backup/archivelog optional';
System altered.
- SQL> archive log list;
- Database log mode No Archive Mode
- Automatic archival Disabled
- Archive destination /backup/archivelog
- Oldest online log sequence 12
- Current log sequence 14
- SQL> shutdown immediate;
- Database closed.
- Database dismounted.
- ORACLE instance shut down.
- SQL> startup mount;
- ORACLE instance started.
- Total System Global Area 1319473152 bytes
- Fixed Size 2252984 bytes
- Variable Size 838864712 bytes
- Database Buffers 469762048 bytes
- Redo Buffers 8593408 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 /backup/archivelog
- Oldest online log sequence 12
- Next log sequence to archive 14
- Current log sequence 14
- SQL> exit;
来源: http://www.bubuko.com/infodetail-2922967.html