Не синхронизируется Standby / Oracle

ReSQL.ru

Мобильная версия Контакт Правила FAQ Помощь

Гость

Войти | Регистрация | Профиль | Очистить

Новые сообщения | Избранное

Форумы | Пользователи | Статистика | Мод. лог | Поиск

Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр

Форумы / Oracle [игнор отключен] [закрыт для гостей] / Не синхронизируется Standby

7 сообщений из 7, страница 1 из 1

Не синхронизируется Standby

#40030730

Frequency

Участник

Сообщения: 325

Рейтинг: 0 / 0

Primary

Код: plsql

1.
2.
3.
4.
5.

SQL> select max(sequence#) from v$log_history;

MAX(SEQUENCE#)
--------------
            73

Код: plsql

1.
2.
3.
4.
5.

SQL> SELECT DATABASE_ROLE FROM V$DATABASE;

DATABASE_ROLE
----------------
PRIMARY

Standby

Код: plsql

1.
2.
3.
4.
5.

SQL> select max(sequence#) from v$log_history;

MAX(SEQUENCE#)
--------------
            67

Код: plsql

1.
2.
3.
4.
5.

SQL> SELECT DATABASE_ROLE FROM V$DATABASE;

DATABASE_ROLE
----------------
PHYSICAL STANDBY

Код: plsql

1.
2.
3.
4.
5.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY DISCONNECT FROM SESSION USING CURRENT LOGFILE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY DISCONNECT FROM SESSION USING CURRENT LOGFILE
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active

После перезагрузки STANDBY , sequence - сы не синхронизируются.

Помогите чайнику, что не так как восстановить синхронизацию?

Буду благодарен.

...

Рейтинг:

0 / 0

24.12.2020, 10:29

| Ответить | Цитировать | Написать

Не синхронизируется Standby

#40030766

Vadim Lejnin

Участник

Сообщения: 7 675

Рейтинг: 0 / 0

Для начала:

Код: plsql

1.
2.
3.
4.
5.
6.
7.
8.
9.

$ oerr ora 01153
01153, 00000, "an incompatible media recovery is active"
// *Cause: Attempted to start an incompatible media recovery or open resetlogs
//         during media recovery or RMAN backup . Media recovery sessions
//         are incompatible if they attempt to recover the same data file.
//         Incomplete media recovery or open resetlogs is incompatible with
//         any media recovery. Backup or restore by RMAN is incompatible
//         with open resetlogs
// *Action: Complete or cancel the other media recovery session or RMAN backup

Для продолжения:

Из анекдотаНу рассказывай, как обгонял, как подрезал...

Телепатов нету, поэтому:
0) По какой документации настраивал
1) хвосты примерно по 1000 строк alert.log со standby и primary
2) куски alert.log со стартом экземпляра

...

Рейтинг:

0 / 0

24.12.2020, 12:36

| Ответить | Цитировать | Написать

Не синхронизируется Standby

#40030838

Frequency

Участник

Сообщения: 325

Рейтинг: 0 / 0

Vadim Lejnin

Для начала:

Код: plsql

1.
2.
3.
4.
5.
6.
7.
8.
9.

$ oerr ora 01153
01153, 00000, "an incompatible media recovery is active"
// *Cause: Attempted to start an incompatible media recovery or open resetlogs
//         during media recovery or RMAN backup . Media recovery sessions
//         are incompatible if they attempt to recover the same data file.
//         Incomplete media recovery or open resetlogs is incompatible with
//         any media recovery. Backup or restore by RMAN is incompatible
//         with open resetlogs
// *Action: Complete or cancel the other media recovery session or RMAN backup

Для продолжения:

Из анекдотаНу рассказывай, как обгонял, как подрезал...

Телепатов нету, поэтому:
0) По какой документации настраивал
1) хвосты примерно по 1000 строк alert.log со standby и primary
2) куски alert.log со стартом экземпляра

1). Восстанавливал по данной документации - https://dbasoumya.blogspot.com/2015/01/how-to-sync-standy-database-which-is.html

2).

Код: plsql

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.

<msg time='2020-12-24T06:34:01.564-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8571'>
 <txt>Thread 2 advanced to log sequence 96 (LGWR switch)
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.564-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8571'>
 <txt>  Current log# 4 seq# 96 mem# 0: +DATA/TESTDB/ONLINELOG/group_4.267.1056946161
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.564-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8571'>
 <txt>  Current log# 4 seq# 96 mem# 1: +FRA/TESTDB/ONLINELOG/group_4.260.1056946175
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.942-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>WARNING: Archived log +FRA/TESTDB/ARCHIVELOG/2020_12_01/thread_2_seq_31.325.1057975979
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.942-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>needed by Streams capture process is being deleted from the
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.942-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>recovery area because its control file tracking record is being
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.942-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>reused. If you need to process these logs again, restore them from a
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.942-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>backup to a destination other than the recovery area using the
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.942-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>following RMAN commands:
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.942-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>   RUN{
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.942-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>      # &lt;directory/ASM diskgroup&gt; is a location other than the
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.942-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>      # recovery area
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.942-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>      SET ARCHIVELOG DESTINATION TO &apos;&lt;directory/ASM diskgroup&gt;&apos;;
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.942-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>      RESTORE ARCHIVELOG ...;
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.942-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>   }
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.949-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>Deleted Oracle managed file +FRA/TESTDB/ARCHIVELOG/2020_12_01/thread_2_seq_31.325.1057975979
 </txt>
</msg>
<msg time='2020-12-24T06:34:01.950-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8860'>
 <txt>ARC1 (PID:8860): Archived Log entry 169 added for T-2.S-95 ID 0xa94b4e31 LAD:1
 </txt>
</msg>
<msg time='2020-12-24T06:34:07.059-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8571'>
 <txt>Thread 2 cannot allocate new log, sequence 97
 </txt>
</msg>
<msg time='2020-12-24T06:34:07.059-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8571'>
 <txt>Checkpoint not complete
 </txt>
</msg>
<msg time='2020-12-24T06:34:07.059-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8571'>
 <txt>  Current log# 4 seq# 96 mem# 0: +DATA/TESTDB/ONLINELOG/group_4.267.1056946161
 </txt>
</msg>
<msg time='2020-12-24T06:34:07.059-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8571'>
 <txt>  Current log# 4 seq# 96 mem# 1: +FRA/TESTDB/ONLINELOG/group_4.260.1056946175
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.309-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8571'>
 <txt>Thread 2 advanced to log sequence 97 (LGWR switch)
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.309-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8571'>
 <txt>  Current log# 3 seq# 97 mem# 0: +DATA/TESTDB/ONLINELOG/group_3.266.1056946123
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.309-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8571'>
 <txt>  Current log# 3 seq# 97 mem# 1: +FRA/TESTDB/ONLINELOG/group_3.259.1056946137
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.698-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>WARNING: Archived log +FRA/TESTDB/ARCHIVELOG/2020_12_01/thread_1_seq_31.261.1057999877
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.698-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>needed by Streams capture process is being deleted from the
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.698-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>recovery area because its control file tracking record is being
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.698-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>reused. If you need to process these logs again, restore them from a
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.698-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>backup to a destination other than the recovery area using the
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.698-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>following RMAN commands:
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.699-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>   RUN{
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.699-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>      # &lt;directory/ASM diskgroup&gt; is a location other than the
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.699-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>      # recovery area
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.699-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>      SET ARCHIVELOG DESTINATION TO &apos;&lt;directory/ASM diskgroup&gt;&apos;;
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.699-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>      RESTORE ARCHIVELOG ...;
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.699-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>   }
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.706-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>Deleted Oracle managed file +FRA/TESTDB/ARCHIVELOG/2020_12_01/thread_1_seq_31.261.1057999877
 </txt>
</msg>
<msg time='2020-12-24T06:34:09.707-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='node2.localdomain'
 host_addr='192.168.100.61' pid='8865'>
 <txt>ARC2 (PID:8865): Archived Log entry 170 added for T-2.S-96 ID 0xa94b4e31 LAD:1
 </txt>
</msg>

standby

Код: plsql

 </txt>
</msg>
<msg time='2020-12-24T06:41:12.057-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00313: open failed for members of log group 12 of thread 0
ORA-00312: online log 12 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_12.329.1059835525&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_12.329.1059835525
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_12.329.1059835525&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:12.130-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00313: open failed for members of log group 12 of thread 0
ORA-00312: online log 12 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_12.329.1059835525&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_12.329.1059835525
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_12.329.1059835525&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:12.527-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00312: online log 13 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_13.330.1059835529&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_13.330.1059835529
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_13.330.1059835529&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:12.605-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00313: open failed for members of log group 13 of thread 0
ORA-00312: online log 13 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_13.330.1059835529&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_13.330.1059835529
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_13.330.1059835529&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:12.681-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00313: open failed for members of log group 13 of thread 0
ORA-00312: online log 13 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_13.330.1059835529&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_13.330.1059835529
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_13.330.1059835529&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:12.804-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00312: online log 14 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_14.331.1059835537&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_14.331.1059835537
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_14.331.1059835537&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:12.880-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00313: open failed for members of log group 14 of thread 0
ORA-00312: online log 14 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_14.331.1059835537&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_14.331.1059835537
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_14.331.1059835537&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:12.954-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00313: open failed for members of log group 14 of thread 0
ORA-00312: online log 14 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_14.331.1059835537&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_14.331.1059835537
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_14.331.1059835537&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:13.092-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00312: online log 15 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_15.332.1059835541&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_15.332.1059835541
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_15.332.1059835541&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:13.167-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00313: open failed for members of log group 15 of thread 0
ORA-00312: online log 15 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_15.332.1059835541&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_15.332.1059835541
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_15.332.1059835541&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:13.243-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00313: open failed for members of log group 15 of thread 0
ORA-00312: online log 15 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_15.332.1059835541&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_15.332.1059835541
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_15.332.1059835541&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:13.298-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='sqlplus@stand.localdomain (TNS V1-V3)' pid='27756'>
 <txt>replication_dependency_tracking turned off (no async multimaster replication found)
 </txt>
</msg>
<msg time='2020-12-24T06:41:13.426-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00312: online log 16 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_16.333.1059835545&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_16.333.1059835545
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_16.333.1059835545&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:13.510-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00313: open failed for members of log group 16 of thread 0
ORA-00312: online log 16 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_16.333.1059835545&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_16.333.1059835545
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_16.333.1059835545&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:13.580-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27764'>
 <txt>Errors in file /home/u01/app/oracle/diag/rdbms/testdb/stand/trace/stand_mz00_27764.trc:
ORA-00313: open failed for members of log group 16 of thread 0
ORA-00312: online log 16 thread 0: &apos;+FRA/TESTDB/ONLINELOG/group_16.333.1059835545&apos;
ORA-17503: ksfdopn:2 Failed to open file +FRA/TESTDB/ONLINELOG/group_16.333.1059835545
ORA-15012: ASM file &apos;+FRA/TESTDB/ONLINELOG/group_16.333.1059835545&apos; does not exist
 </txt>
</msg>
<msg time='2020-12-24T06:41:18.282-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' pid='27703'>
 <txt>Unable to obtain current patch information as the database or pluggable database was opened for read-only access.
 </txt>
</msg>
<msg time='2020-12-24T06:41:18.282-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' pid='27703'>
 <txt>===========================================================
 </txt>
</msg>
<msg time='2020-12-24T06:41:18.282-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' pid='27703'>
 <txt>Dumping current patch information
 </txt>
</msg>
<msg time='2020-12-24T06:41:18.282-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' pid='27703'>
 <txt>===========================================================
 </txt>
</msg>
<msg time='2020-12-24T06:41:18.282-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' pid='27703'>
 <txt>Unable to obtain current patch information due to error: 16000
 </txt>
</msg>
<msg time='2020-12-24T06:41:18.282-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' pid='27703'>
 <txt>===========================================================
 </txt>
</msg>
<msg time='2020-12-24T06:41:22.175-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27726'>
 <txt>db_recovery_file_dest_size of 8016 MB is 10.03% used. This is a
 </txt>
</msg>
<msg time='2020-12-24T06:41:22.175-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27726'>
 <txt>user-specified limit on the amount of space that will be used by this
 </txt>
</msg>
<msg time='2020-12-24T06:41:22.175-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27726'>
 <txt>database for recovery-related files, and does not reflect the amount of
 </txt>
</msg>
<msg time='2020-12-24T06:41:22.175-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='MMON_SLAVE' pid='27726'>
 <txt>space available in the underlying filesystem or ASM diskgroup.
 </txt>
</msg>
<msg time='2020-12-24T06:41:24.659-05:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='stand.localdomain'
 host_addr='192.168.100.41' module='sqlplus@stand.localdomain (TNS V1-V3)' pid='27756'>
 <txt>Physical standby database opened for read only access.
 </txt>
</msg>
<msg time='2020-12-24T06:41:24.761-05:00' org_id='oracle' comp_id='rdbms'
 msg_id='opiexe:3870:2802784106' type='NOTIFICATION' group='admin_ddl'
 level='16' host_id='stand.localdomain' host_addr='192.168.100.41'
 module='sqlplus@stand.localdomain (TNS V1-V3)' pid='27756'>
 <txt>Completed: ALTER DATABASE OPEN
 </txt>
</msg>

Код: plsql

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.

RMAN> catalog start with  '/tmp/backups';

using target database control file instead of recovery catalog
searching for all files that match the pattern /tmp/backups

List of Files Unknown to the Database
=====================================
File Name: /tmp/backups/ForStandby_2gvirvbu_1_1
File Name: /tmp/backups/ForStandby_2hvirvdl_1_1

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /tmp/backups/ForStandby_2gvirvbu_1_1
File Name: /tmp/backups/ForStandby_2hvirvdl_1_1

RMAN> RECOVER DATABASE NOREDO;

Starting recover at 24-DEC-2020 06:35:25
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=32 device type=DISK

Finished recover at 24-DEC-2020 06:35:26

RMAN> restore database;

...

Рейтинг:

0 / 0

24.12.2020, 14:45

| Ответить | Цитировать | Написать

Не синхронизируется Standby

#40030856

PuM256

Гость

Frequency

Код: plsql

1.
2.
3.
4.
5.
6.
7.
8.
9.

RMAN> RECOVER DATABASE NOREDO;

Starting recover at 24-DEC-2020 06:35:25
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=32 device type=DISK

Finished recover at 24-DEC-2020 06:35:26

RMAN> restore database;

Эмммм...

...

Рейтинг:

0 / 0

24.12.2020, 15:19

| Ответить | Цитировать | Написать

Не синхронизируется Standby

#40030875

Frequency

Участник

Сообщения: 325

Рейтинг: 0 / 0

PuM256

Frequency

Код: plsql

1.
2.
3.
4.
5.
6.
7.
8.
9.

RMAN> RECOVER DATABASE NOREDO;

Starting recover at 24-DEC-2020 06:35:25
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=32 device type=DISK

Finished recover at 24-DEC-2020 06:35:26

RMAN> restore database;

Эмммм...

Подскажите пжт, или скинте док. для синхронизации ? Буду благодарен спс

...

Рейтинг:

0 / 0

24.12.2020, 15:33

| Ответить | Цитировать | Написать

Не синхронизируется Standby

#40030967

Vadim Lejnin

Участник

Сообщения: 7 675

Рейтинг: 0 / 0

Frequency,

начинай сначала...

restore - восстановление файлов базы из backup
recover - накат изменение на восстановленную базу

И да, чем не нравится родная документация, там все раз,два, три

alert.log лучше использовать не xml а обычный

Код: plsql

<DIAG_HOME>/rdbms/<dbname>/<db_unique_name>/trace/alert$ORACLE_SID.ora

...

Рейтинг:

0 / 0

24.12.2020, 20:04

| Ответить | Цитировать | Написать

Не синхронизируется Standby

#40030979

Frequency

Участник

Сообщения: 325

Рейтинг: 0 / 0

Vadim Lejnin

Код: plsql

<DIAG_HOME>/rdbms/<dbname>/<db_unique_name>/trace/alert$ORACLE_SID.ora

Ок попробую , спасибо

...

Рейтинг:

0 / 0

24.12.2020, 20:54

| Ответить | Цитировать | Написать

7 сообщений из 7, страница 1 из 1

Форумы / Oracle [игнор отключен] [закрыт для гостей] / Не синхронизируется Standby

Цитировать

Написать

Автор*:

Ввести пароль для входа

Тема*:

Сообщение

Данное сообщение тематическое

Сообщение содержит картинки или видео 18+

Автор:

ВНИМАНИЕ! На данном подфоруме действуют строгие правила. Удостоверьтесь, что ваше сообщение соответствует им!

Форум или тема закрыты для гостей. Необходима авторизация!

Загрузить последнюю сохраненную версию

Вложение:

Вставить как галерею

Максимальный размер вложений: 4,0 МБ, аудио/видео: 8,0 МБ. Картинки большего размера ужимаются, если возможно.

Введите код, изображенный на картинке. Если код нечитаемый, кликните картинку, чтобы загрузить другой вариант.

Отправляя сообщение, я выражаю свое согласие с правилами форума и принимаю пользовательское соглашение.

Читали тему (0):

Читали форум (0):

Пользователи онлайн (0):

start [/forum/topic.php?fid=52&fpage=28&tid=1880562]:	0ms
get settings:	10ms
get forum list:	11ms
check forum access:	3ms
check topic access:	3ms
track hit:	42ms
get topic data:	10ms
get forum data:	2ms
get page messages:	48ms
get tp. blocked users:	2ms
others:	274ms

total:	405ms