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

Hi Sundar,
What I did once when I needed to match the backups with the server without adding an additional table was:
 from backup script add a comment with specific tag for each backup  query RMAN catalog RMAN_OUTPUT table to get this info Regards,
Franck

On Mon, Apr 29, 2019 at 7:16 PM Sundar Mahadevan < sundarmahadevan82_at_gmail.com> wrote:

> 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