archive启用归档模式

SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 26 15:41:16 2014

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, 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 65

Current log sequence 67

SQL> shutdown immediate; --立即关闭数据库

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount; --打开数据到mount状态

ORACLE instance started.

Total System Global Area 613797888 bytes

Fixed Size 2178216 bytes

Variable Size 192938840 bytes

Database Buffers 411041792 bytes

Redo Buffers 7639040 bytes

Database mounted.

SQL> select status from v$instance; --查看数据库打开状态

STATUS

------------

MOUNTED

SQL> alter database archivelog; --启用归档模式

Database altered.

SQL> alter database open; --打开数据库到open状态

Database altered.

SQL> select status from v$instance; -- 查看数据库打开状态

STATUS

------------

OPEN

SQL> archive log list; --查看是否归档

Database log mode Archive Mode --归档模式已启用

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 65

Next log sequence to archive 67

Current log sequence 67

SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29267792/viewspace-1130006/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29267792/viewspace-1130006/