# Alter database open read only error

**URL:** <https://www.batmunkh.net/t/alter-database-open-read-only-error/1161>\
**Category:** Oracle Database\
**Tags:** data\
**Created:** [September 23, 2019, 10:06pm UTC](https://www.batmunkh.net/t/alter-database-open-read-only-error/1161 "2019-09-23T22:06:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![batchimeg.b](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/b/ee7513/32.png) [@batchimeg.b](https://www.batmunkh.net/u/batchimeg.b)\
**Post date:** [September 23, 2019, 10:06pm UTC](https://www.batmunkh.net/t/alter-database-open-read-only-error/1161/1 "2019-09-23T22:06:43Z")

</div>

![swichover](https://www.batmunkh.net/uploads/default/original/1X/6ae9c9ffd21ef41f001d32320ed4977694c95c97.jpeg)

HI all,  
alter database commit to switchover to physical standby with session shutdown;  
startup nomount;  
alter database mount standby database;  
alter database open read only;  
Хийх үед ийм алдаа гарлаа. Асуудлыг хэрхэн шийдэх вэ?

---

<div class="post-metadata">

**Author:** ![tmdeft](https://www.batmunkh.net/user_avatar/www.batmunkh.net/tmdeft/32/542_2.png) [@tmdeft](https://www.batmunkh.net/u/tmdeft)\
**Post date:** [September 23, 2019, 11:42pm UTC](https://www.batmunkh.net/t/alter-database-open-read-only-error/1161/2 "2019-09-23T23:42:15Z")

</div>

archive log ni gap tai bgad bn, guitsed archive log apply hiigdej duussanii daraa l stand by tal read only boloh bha. Mount mode deerre heseg bailgaad sync hiilgeed gap aa shalgaj bgad gap gui bolchih yum bol read only bolgoj bolon bh

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [October 1, 2019, 5:51pm UTC](https://www.batmunkh.net/t/alter-database-open-read-only-error/1161/3 "2019-10-01T17:51:26Z")

</div>

open бологохын тулд ер нь mount горимоос recovery -г хангалттай хугацаагаар ажиллуулж бажй open төлөвт нээнэ. Мөн дараагийн удаад алдаагаа бичиж байх хэрэгтэй… Өөр төрлийн ч алдаа байж болно шүү дээ. Тиймээс асуулт асуухдаа аль болох дэлгэрэнгүй тодорхой мэдээлэл оруулна уу.