freedompuge的专栏

记录我的dba生涯

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

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

阅读更多
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/freedompuge/article/details/51555785
个人分类: oracle数据库
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

不良信息举报

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

最多只允许输入30个字

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭