ITPub博客

首页 > 数据库 > Oracle > archive启用归档模式

archive启用归档模式

原创 Oracle 作者:ocpDBAboy 时间:2014-03-26 15:54:11 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: session
请登录后发表评论 登录
全部评论
积极,热爱生活!

注册时间:2014-01-15

  • 博文量
    28
  • 访问量
    101130