OraFAQ Forum: Backup & Recovery » How to check all the successful full backup in RMAN

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to check all the successful full backup in RMAN [message #388318]

Tue, 24 February 2009 04:21

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.

Report message to a moderator

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

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcviews014.htm#RCMRF1670

Report message to a moderator

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

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.

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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?

Report message to a moderator

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

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.

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Previous Topic:	RMAN backup in tape and disk
Next Topic:	Full export, smaller import file sizes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 07:50:38 CST 2024