Home » RDBMS Server » Backup & Recovery » Location of Backup (Oracle 10g R2,Linux AS4)
Location of Backup [message #378856] Fri, 02 January 2009 03:24 Go to next message
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
Re: Location of Backup [message #378859 is a reply to message #378856] Fri, 02 January 2009 03:31 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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.
Re: Location of Backup [message #378866 is a reply to message #378859] Fri, 02 January 2009 03:48 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Location of Backup [message #379190 is a reply to message #378901] Mon, 05 January 2009 05:30 Go to previous message
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.
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:
  


Current Time: Fri Dec 09 09:58:19 CST 2016

Total time taken to generate the page: 0.17424 seconds