OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » recovery catalog

Wed, 30 May 2007 14:48

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

Wed, 30 May 2007 14:55

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Select from RC_DATABASE. Something like this should do the job:

SELECT COUNT(DISTINCT dbid) FROM rc_database;

Wed, 30 May 2007 15:01

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Thanks.

Previous Topic:	Complete Recovery through RMAN
Next Topic:	faq

Goto Forum:

]

Current Time: Sat Nov 23 01:08:12 CST 2024