Home » RDBMS Server » Backup & Recovery » recovery catalog
recovery catalog [message #241866] Wed, 30 May 2007 14:48 Go to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Is there any way to find the no of databases register with recovery catalog?
Thanks
Re: recovery catalog [message #241867 is a reply to message #241866] Wed, 30 May 2007 14:55 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Select from RC_DATABASE. Something like this should do the job:

SELECT COUNT(DISTINCT dbid) FROM rc_database;
Re: recovery catalog [message #241869 is a reply to message #241867] Wed, 30 May 2007 15:01 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Thanks.
Previous Topic: Complete Recovery through RMAN
Next Topic: faq
Goto Forum:
  


Current Time: Fri Dec 09 09:59:15 CST 2016

Total time taken to generate the page: 0.26009 seconds