Home » RDBMS Server » Enterprise Manager » view all / last restores
view all / last restores [message #674388] Thu, 24 January 2019 06:11 Go to next message
berko
Messages: 2
Registered: January 2019
Junior Member
Hey all,

Would appreciate your help with the following question -
is there a way to query all / last rman restore from the Oracle Cloud Control (OEM) repository views?

Tnx!
Re: view all / last restores [message #674389 is a reply to message #674388] Thu, 24 January 2019 07:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

>is there a way to query all / last rman restore from the Oracle Cloud Control (OEM) repository views?
please clarify what results you desire.
Re: view all / last restores [message #674689 is a reply to message #674389] Sun, 10 February 2019 09:42 Go to previous messageGo to next message
berko
Messages: 2
Registered: January 2019
Junior Member
Hello BlackSwan and all,

I'm looking for a way to obtain the following information (by example):

HOST_NAME DB_NAME LAST_RESTORE RESTORED_ON_HOST RESTORE_STATUS
hrsrv hrdb 02-10-2019 14:00:30 hrtest SUCCESS

Ideally by querying Oracle Cloud Control 12c repository views. Even getting some of the info would help.

Appreciate your help and insights.
Re: view all / last restores [message #674691 is a reply to message #674689] Sun, 10 February 2019 12:41 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Obviously you didn't read the links BlackSwan provided.

Previous Topic: please help me about listener service in oracle
Next Topic: OEM Notifications only
Goto Forum:
  


Current Time: Thu Mar 28 06:33:38 CDT 2024