ORA-16003: standby database is restricted to read-only access

原创 2016年06月01日 14:36:20

dg失败导致,从库一直只能read only开启。

解决办法:

SQL> shutdown immediate
ORA-01109: database not open




Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.


Total System Global Area 1068937216 bytes
Fixed Size                  2235208 bytes
Variable Size             893387960 bytes
Database Buffers          167772160 bytes
Redo Buffers                5541888 bytes
SQL> alter database mount standby database;


Database altered.


SQL> alter database activate standby database;


Database altered.


SQL> shutdown immediate;
ORA-01109: database not open




Database dismounted.
ORACLE instance shut down.
SQL> startup open;
ORACLE instance started.


Total System Global Area 1068937216 bytes
Fixed Size                  2235208 bytes
Variable Size             893387960 bytes
Database Buffers          167772160 bytes
Redo Buffers                5541888 bytes
Database mounted.
Database opened.
SQL> select open_mode from v4database;
select open_mode from v4database
                      *
ERROR at line 1:
ORA-00942: table or view does not exist




SQL> select open_mode from v$database;


OPEN_MODE
--------------------
READ WRITE

版权声明:本文为博主原创文章,未经博主允许不得转载。

相关文章推荐

Oracle Physical Standby

我们公司的Oracle DB从7345到9205都有,在很早以前,我就把它的standby给搞定了,不过用的是自己写的代码。Standby架构弄好以后,主要是用它恢复正式库,每个月都用这个standb...
  • compard
  • compard
  • 2007年12月18日 16:50
  • 3859

How to grant access to SQL logins on a standby database when the guest user is disabled in SQL Serve

Steps to reproduce the behavior In the following example, Pubs is the database, server1 is the se...
  • pbsh
  • pbsh
  • 2012年01月29日 11:45
  • 327

Unable to connect to read only database, Getting error ORA-00604 ORA-16000 (Doc ID 461653.1)

Applies to: Oracle Server - Enterprise Edition - Version 9.2.0.1 to 10.2.0.1 [Release 9.2 to 10.2]...

ORA-39181:Only Partial Table Data Exported Due To Fine Grain Access Control [ID 422480.1]

修改时间 15-MAR-2011     类型 PROBLEM     状态 PUBLISHED   In this Document   Symptoms   Changes ...

java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed

jodd.db.DbQueryBase.executeUpdate(DbQueryBase.java:677) jodd.db.DbQueryBase.executeUpdate(DbQuer...

使用flashback database 特性将dataguard 的standby 库激活为read write的实现方法

可以利用10g的flashback特性来实现激活为standby库为read write状态,standby库处于read write状态时可以在standby库上进行一些不能在主库上进行的测试工...
  • xyz846
  • xyz846
  • 2012年04月10日 22:08
  • 581

Operation category READ is not supported in state standby解决

hdfs写的那台机器是待机状态的,所以不支持,要在active 机器中写才行./hdfs haadmin -transitionToActive --forcemanual nn1再次访问就变一act...

HBase Operation category READ is not supported in state standby

2016-12-29 14:48:44,188 INFO  [master:master:60000] http.HttpServer: Jetty bound to port 60010 2016-...

andrroid couldn't open database for writing(will try read-only)

 andrroid couldn't open database for writing(will try read-only) androi
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:ORA-16003: standby database is restricted to read-only access
举报原因:
原因补充:

(最多只允许输入30个字)