启用归档模式

[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 ProductionWith 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 ModeAutomatic archival DisabledArchive destination /backup/archivelogOldest online log sequence 12Current log sequence 14SQL> 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 bytesVariable Size 838864712 bytesDatabase Buffers 469762048 bytesRedo Buffers 8593408 bytesDatabase mounted.SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;

Database log mode Archive ModeAutomatic archival EnabledArchive destination /backup/archivelogOldest online log sequence 12Next log sequence to archive 14Current log sequence 14SQL> exit;