My Oracle Support Banner

Zdlra Monitoring 을 위한 Sql 수행중 Group 절포함시 결과가 다름 (Doc ID 2561633.1)

Last updated on JULY 03, 2019

Applies to:

Zero Data Loss Recovery Appliance Software - Version 12.1.1.1.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1.1.8 version, Reporting Views

zdlra monitoring 을 위한 sql 수행중 group 절포함시 결과가 다름.

zdlra 의 오브젝트중에서 ra_database 의 table 과 ra_disk_restore_range 의 table 을 group by후 join 할경우 ra_database 의 column 값이 다르게나옴

SQL1)
select rd.DB_KEY, rd.MINIMUM_RECOVERY_NEEDED, rdrr.LAST_UPDATED from rasys.ra_database rd, (select DB_KEY, max(LAST_UPDATED) as "LAST_UPDATED" from rasys.ra_disk_restore_range group by DB_KEY) rdrr where rd.db_key=rdrr.db_key order by 1;
SQL2)
select rd.DB_KEY, rd.MINIMUM_RECOVERY_NEEDED, rdrr.LAST_UPDATED from rasys.ra_database rd, (select DB_KEY, LAST_UPDATED from rasys.ra_disk_restore_range ) rdrr where rd.db_key=rdrr.db_key order by 1;


SQL1) result
  DB_KEY MINIMUM_RECOVERY_NEEDED LAST_UPDA
---------- --------------------------------------------------------------------------- ---------
  11621 +003867187 03:00:07.000000000 23-MAY-19

SQL2) result
  DB_KEY MINIMUM_RECOVERY_NEEDED LAST_UPDA
---------- --------------------------------------------------------------------------- ---------
  11621 +000000000 04:01:12.000000000 23-MAY-19




MINIMUM_RECOVERY_NEEDED 컬럼의 값이 다르게 나오는데 원인분석 

EXPECTED BEHAVIOR
-----------------------
.

STEPS
-----------------------
.

BUSINESS IMPACT
-----------------------
.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.