Home » RDBMS Server » Backup & Recovery » How to check all the successful full backup in RMAN (Oracle 10.2.0.3.0, AIX 5.2.0.0)
How to check all the successful full backup in RMAN [message #388318] Tue, 24 February 2009 04:21 Go to next message
saurabhshukla
Messages: 6
Registered: February 2009
Location: Gurgaon
Junior Member
Hi,
I have RMAN database having catalog and close to 50 databases are registered with it. I would like to know for how many databases full RMAN successful backup happened (using RC_ view in RMAN scehma in RMAN database)?
Please shed some light on this.
Re: How to check all the successful full backup in RMAN [message #388328 is a reply to message #388318] Tue, 24 February 2009 06:16 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcviews014.htm#RCMRF1670
Re: How to check all the successful full backup in RMAN [message #388410 is a reply to message #388328] Tue, 24 February 2009 10:45 Go to previous messageGo to next message
saurabhshukla
Messages: 6
Registered: February 2009
Location: Gurgaon
Junior Member
Hi,
I want to see all the databases registered with RMAN catalog (using rc_database view) plus the status of the full backup, would need to join with some other view.
From RMAN prompt I will be able to get to know the information of a single database at a perticular time.
Please suggest.
Re: How to check all the successful full backup in RMAN [message #388418 is a reply to message #388410] Tue, 24 February 2009 11:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Have you registered all 50 targets in the same catalog?
Or
each target will have its own catalog/schema within the rman catalog database?
Re: How to check all the successful full backup in RMAN [message #388419 is a reply to message #388418] Tue, 24 February 2009 11:41 Go to previous messageGo to next message
saurabhshukla
Messages: 6
Registered: February 2009
Location: Gurgaon
Junior Member
Yes all 50 databases are registered with one RMAN catalog which is a different database located at different box.
Re: How to check all the successful full backup in RMAN [message #388423 is a reply to message #388419] Tue, 24 February 2009 12:18 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcviews045.htm


Look into input_type and status.
Use start_time,end_time,db_name to filter the data you want.
You get most of it here.
Else join the required views.
Previous Topic: RMAN backup in tape and disk
Next Topic: Full export, smaller import file sizes
Goto Forum:
  


Current Time: Thu Dec 08 08:19:09 CST 2016

Total time taken to generate the page: 0.09606 seconds