oracle只读模式

来源：动视网责编：小采时间：2020-11-09 07:17:28

oracle只读模式

oracle只读模式:在只读模式下，数据文件及联机日志文件都禁止写操作。不过允许执行数据库恢复及其他不会产生回滚的操作。数据库关闭的情况下[oracle@prod1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 22 1

推荐度：

点击下载本文 文档为doc格式

导读oracle只读模式:在只读模式下，数据文件及联机日志文件都禁止写操作。不过允许执行数据库恢复及其他不会产生回滚的操作。数据库关闭的情况下[oracle@prod1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 22 1

在只读模式下，数据文件及联机日志文件都禁止写操作。不过允许执行数据库恢复及其他不会产生回滚的操作。

数据库关闭的情况下

[oracle@prod1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 22 19:07:12 2015

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

Connected to an idle instance.

idle> startup open read only;
ORACLE instance started.

Total System Global Area 1383808 bytes
Fixed Size 1340104 bytes
Variable Size 658509112 bytes
Database Buffers 2292416 bytes
Redo Buffers 5042176 bytes
Database mounted.
Database opened.


idle> select open_mode from v$database;OPEN_MODE
--------------------READ ONLY

mount状态下

idle> alter database open read only;

Database altered.

重新恢复到读写状态

idle> shutdown immediate;
Database closed.Database dismounted.ORACLE instance shut down.idle> startup mount;
ORACLE instance started.Total System Global Area 1383808 bytesFixed Size 1340104 bytesVariable Size 658509112 bytesDatabase Buffers 2292416 bytesRedo Buffers 5042176 bytesDatabase mounted.idle> alter database open read write;

Database altered.

在只读模式下，数据文件及联机日志文件都禁止写操作。不过允许执行数据库恢复及其他不会产生回滚的操作。

数据库关闭的情况下

[oracle@prod1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 22 19:07:12 2015

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

Connected to an idle instance.

idle> startup open read only;
ORACLE instance started.

Total System Global Area 1383808 bytes
Fixed Size 1340104 bytes
Variable Size 658509112 bytes
Database Buffers 2292416 bytes
Redo Buffers 5042176 bytes
Database mounted.
Database opened.


idle> select open_mode from v$database;OPEN_MODE
--------------------READ ONLY

mount状态下

idle> alter database open read only;

Database altered.

重新恢复到读写状态

idle> shutdown immediate;
Database closed.Database dismounted.ORACLE instance shut down.idle> startup mount;
ORACLE instance started.Total System Global Area 1383808 bytesFixed Size 1340104 bytesVariable Size 658509112 bytesDatabase Buffers 2292416 bytesRedo Buffers 5042176 bytesDatabase mounted.idle> alter database open read write;

Database altered.

oracle只读模式

推荐度：

点击下载本文 文档为doc格式

标签：模式只读模式数据库

热门焦点

oracle只读模式

oracle只读模式

oracle只读模式

最新推荐

猜你喜欢

热门推荐