OraFAQ Forum: Backup & Recovery » Location of Backup

Home » RDBMS Server » Backup & Recovery » Location of Backup (Oracle 10g R2,Linux AS4)

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

Location of Backup [message #378856]

Fri, 02 January 2009 03:24

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello,

I'd like to know what all the databases are registered in my catalog database.I did see in the view RC_DATABASE of RMAN schema.But I did not find my database in that view.

1) I'd like to know whether there are any other ways to find out whether the backups are happening in the catalog database or in the Target database control file.Is there any other views to find out .

2) And also need to find out what all the databases are registered in the catalog database.

kindly help me out.

Regards,
Raj

Report message to a moderator

Re: Location of Backup [message #378859 is a reply to message #378856]

Fri, 02 January 2009 03:31

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

The RC_DATABASE view will show ALL the registered databases. If it's not there, it is not backed-up with that catalog. So, it should be enough.

Report message to a moderator

Re: Location of Backup [message #378866 is a reply to message #378859]

Fri, 02 January 2009 03:48

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Thanks frank.

But apart from that I want to find out if the backups are happening in catalog database or in the target database controlfile.

Any solution for this.

[Updated on: Fri, 02 January 2009 04:13]

Report message to a moderator

Re: Location of Backup [message #378901 is a reply to message #378866]

Fri, 02 January 2009 06:38

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> But apart from that I want to find out if the backups are happening in catalog database or in the target database controlfile.
Check the scripts that are used to backup.
No specific method exists to check whether backup info is stored in control file or catalog. A catalog is just an extension of control file to store the info.
You can query the views in catalog, still easiest method is to check the scripts.

Report message to a moderator

Re: Location of Backup [message #379190 is a reply to message #378901]

Mon, 05 January 2009 05:30

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Thanks a ton frank and mahesh . The problem is we dont have any contact with the backup team which is Onsite and we are offshore . There lies the problem .

We have seen in the RC_DATABASE view of the recovery catalog , but could'nt find in that our database name . So we were just a little curious to know all the above mentioned .

Anyhow thansks for your time and mail.

Report message to a moderator

Previous Topic:	Will backup of oracle 10g enterprise work in orcale 10g standard
Next Topic:	How to change the path for db_recovery_file_dest?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 08:26:36 CST 2024