Server name of database host from rman recovery catalog views
From: Sundar Mahadevan <sundarmahadevan82_at_gmail.com>
Date: Mon, 29 Apr 2019 09:32:09 -0700
Message-ID: <CADmQEr7o64sSfQQrs-e6xdwiZZkuy=8NdJdEDdVX3Fk9gFFAZw_at_mail.gmail.com>
Hi All,
Greetings of the day. In the report i generate once a day, I have info like database name, start and end time of backup and the status along with backup type. However, none of the rc views have server name column where these databases are hosted. Can i maintain a separate table outside of catalog schema with dbid and server name and join it to my query? Any license constraints? Any other way to achieve this? Thanks for your assistance and have a great day.
Date: Mon, 29 Apr 2019 09:32:09 -0700
Message-ID: <CADmQEr7o64sSfQQrs-e6xdwiZZkuy=8NdJdEDdVX3Fk9gFFAZw_at_mail.gmail.com>
Hi All,
Greetings of the day. In the report i generate once a day, I have info like database name, start and end time of backup and the status along with backup type. However, none of the rc views have server name column where these databases are hosted. Can i maintain a separate table outside of catalog schema with dbid and server name and join it to my query? Any license constraints? Any other way to achieve this? Thanks for your assistance and have a great day.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 29 2019 - 18:32:09 CEST