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

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