Raccheck Dataguard and RPM errors
Hi gurus, i've run the raccheck utility to aidut a customer enviroment with one rac as primary site and a single instance lace on dataguard site, but the report say me that the sta ndbyr edolog was not present on primary site, btu is not true , following the query;
select group#,sum(bytes/1024/1024)"Size in MB" from v$log group by group#;
GROUP# Size in MB
---------- ----------
1 50
22 50
25 50
30 50
34 50
28 50
29 50
2 50
21 50
26 50
31 50
4 50
24 50
32 50
23 50
35 50
37 50
33 50
3 50
27 50
36 50
select group#,sum(bytes/1024/1024)"Size in MB" from v$standby_log group by group#;
GROUP# Size in MB
---------- ----------
6 50
11 50
20 50
5 50
8 50
17 50
7 50
18 50
9 50
10 50
12 50
15 50
16 50
19 50
Which is the exact query dne by rac check ? I find the following one and the output is:
select group#,sum(bytes/1024/1024)"Size in MB" from v$log group by group#;
GROUP# Size in MB
---------- ----------
1 50
22 50
25 50
30 50
34 50
28 50
29 50
2 50
21 50
26 50
31 50
4 50
24 50
32 50
23 50
35 50
37 50
33 50
3 50
27 50
36 50
select group#,sum(bytes/1024/1024)"Size in MB" from v$standby_log group by group#;
GROUP# Size in MB
---------- ----------
6 50
11 50
20 50
5 50
8 50
17 50
7 50
18 50
9 50
10 50
12 50
15 50
16 50
19 50
Which is the exact query dne by rac check ? I find the following one and the output is:
0