[oracle@localhost oracle]$ sqlplus / as sysdbaSQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 3 17:10:02 2009Copyri

首页 → 数据库技术

背景：

阅读新闻

更改Oracle数据库到归档模式

[日期：2009-12-14]

来源：Oracle社区

作者：Oracle编辑

[字体：]

[Oracle@localhost oracle]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 3 17:10:02 2009

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select log_mode from v$database;

LOG_MODE

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

NOARCHIVELOG

SQL> alter database archivelog on;

alter database archivelog on

*

ERROR at line 1:

ORA-00933: SQL command not properly ended

SQL> alter database archivelog;

alter database archivelog

*

ERROR at line 1:

ORA-01126: database must be mounted in this instance and not open in any

instance

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 389189632 bytes

Fixed Size 1300128 bytes

Variable Size 276826464 bytes

Database Buffers 104857600 bytes

Redo Buffers 6205440 bytes

Database mounted.

SQL> alter database archivelog on;

alter database archivelog on

*

ERROR at line 1:

ORA-00933: SQL command not properly ended

SQL> alter database archivelog;

Database altered.

SQL> select log_mode from v$database;

LOG_MODE

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

ARCHIVELOG

SQL> alter database open;

Database altered.

SQL>

0

RHEL5上安装Oracle10g Release 2 (Oracle 11gR1基本相同)

Ubuntu MySQL的root用户权限被删除解决思路

相关资讯

oracle

图片资讯

本文评论

查看全部评论 (1)

评论声明

第 1 楼

最新资讯

本周热门

Linux公社简介 - 广告服务 - 网站地图 - 帮助信息 - 联系我们

本站(LinuxIDC)所刊载文章不代表同意其说法或描述，仅为提供更多信息，，也不构成任何建议。

Copyright © 2006-2014　Linux公社　All rights reserved 浙ICP备06018118号

本文原创发布php中文网，转载请注明出处，感谢您的尊重！