# Physical standby generated archive log location issue

**URL:** <https://www.batmunkh.net/t/physical-standby-generated-archive-log-location-issue/1051>\
**Category:** Бусад\
**Created:** [February 22, 2019, 10:53am UTC](https://www.batmunkh.net/t/physical-standby-generated-archive-log-location-issue/1051 "2019-02-22T10:53:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lkhavuu](https://www.batmunkh.net/user_avatar/www.batmunkh.net/lkhavuu/32/420_2.png) [@Lkhavuu](https://www.batmunkh.net/u/Lkhavuu)\
**Post date:** [February 22, 2019, 10:53am UTC](https://www.batmunkh.net/t/physical-standby-generated-archive-log-location-issue/1051/1 "2019-02-22T10:53:39Z")

</div>

physical standby тохируулсан юм. Archive log-Ууд нь FRA дотороо задгай үүсээд байх юм. Энэ асуудалгүй юу? Уул нь FRA дотор db name хавтас үүлгээд өөрөө хуулчихдагдаа.  
Дараах тохиргоог хийсэн:  
alter system set log\_archive\_dest\_1=‘LOCATION=F:\FRA valid\_for=(all\_logfiles,all\_roles) db\_unique\_name=cdb’;  
alter system set log\_archive\_dest\_2=‘SERVICE=stdby async valid\_for=(online\_logfile,primary\_role) db\_unique\_name=stdby’;

db\_recovery\_file\_dest=F:\FRA -руу заалттай байгаа

---

<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:** [February 22, 2019, 4:38pm UTC](https://www.batmunkh.net/t/physical-standby-generated-archive-log-location-issue/1051/2 "2019-02-22T16:38:04Z")

</div>

```
show parameter dest_ 

```

энийг харах хэрэгтэй.  
Ер нь бол db\_recovery\_file\_dest=F:\FRA дотор фолдер үүсгэж үүсэх тохиргоотой байгаа харагдаж байгаа боловч log\_archive\_dest\_1 параметр дээр F:\FRA-д хадгалнаа гээд тохируулсан байна. Тиймээс log\_archive\_dest\_1 тохиргоогоо USE\_DB\_RECOVERY\_FILE\_DEST болгож өөрчил.

---

<div class="post-metadata">

**Author:** ![Lkhavuu](https://www.batmunkh.net/user_avatar/www.batmunkh.net/lkhavuu/32/420_2.png) [@Lkhavuu](https://www.batmunkh.net/u/Lkhavuu)\
**Post date:** [February 27, 2019, 2:25am UTC](https://www.batmunkh.net/t/physical-standby-generated-archive-log-location-issue/1051/3 "2019-02-27T02:25:27Z")

</div>

Баярлалаа багш 🙂