Re: Server name of database host from rman recovery catalog views

Thanks Mladen for your response. You have a valid point there. I have a BI Publisher job on OEM setup to send a daily report of the backup job status to email the report and we do not have standby excepting a very few databases. And even for the databases with standby, the database backup runs from the primary since the database can comfortably accommodate running it. It would be good to have the database server name in the report instead of looking up a spread sheet and was trying to find a way to achieve that.

On Mon, Apr 29, 2019 at 10:07 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> Hi Sundar!
>
> There is a reason for not having "host" column in the catalog views.
> Host is not important when the backup is taken since backups can be
> taken from multiple hosts and restored to multiple hosts. Backup can be
> taken from any of the standby databases. Since you have a catalog, the
> standby backup would be recognized as the primary database backup. Even
> data file path names do not have to be the same. If you have
> standby_file_management set to "AUTO" and if db_file_name_convert
> parameter is set, then the standby database may be creating files in
> different places than the primary. I am a bit confused by your question.
> I was usually using OEM to monitor databases, not RMAN. OEM has the
> whole inventory. Why would you want to have it recorded in the RMAN
> catalog?
>
> Regards
>
> On 4/29/19 12:32 PM, Sundar Mahadevan wrote:
> > 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.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l