Solved

use recovery catalog or not whats the benefit

Posted on 2007-11-29
4
694 Views
Last Modified: 2013-12-19
Guys

I am trying to create recovery options to my company we use oracle 9I r2 and at present use a 3rd party backup facility which I have no faith in. I want to use RMAN but I have a few questions referring to it

Recovery catalog yes /no what is the benefit of this.
if recovery catalog does this need to be on a different server say A Disater recovery (DR) server.
if so how would you recover with this if you have nothing else but this would I need additional files
backing up archive logs does it delete the logs afterwards or is this a os procedure.

Just a few questions but this will help me decide (I Think) what do do next

Darren
0
Comment
Question by:DarrenJackson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20380389
>a 3rd party backup facility which I have no faith in.
why? did you fail to perform any recovery with it? did you try?

>Recovery catalog yes /no what is the benefit of this.
the recovery catalog will it make much easier to perform restores, especially on another server, or on a completely rebuild server, for your backups.

>if recovery catalog does this need to be on a different server say A Disater recovery (DR) server.
required: technically, it is not. however, it is highly recommended.
imagine you have the recovery catalog on the same server... server goes down (say HD failure)...
* you cannot restore anywhere else, because your catalog is down too
* before you could restore anything, you have to restore your catalog db first...

also, dedicated database for the catalog database(s) is fine, it can be used for multiple oracle databases as recovery catalog.

note: the recovery catalog is nothing else than the catalog of what/when/where has been backed up. for restore, you will also need the backup pieces themselves, obvsiouly.


0
 

Author Comment

by:DarrenJackson
ID: 20380501
Yes we tried and found that to restore the database it would need to overwrite the live if we wanted to test this.
So the process involved backing up the live then restoring the backup and it does work but when I say it fails it is because the backup procedure often fails. from time to time.

Okay I understand the reasons behind the need to use an different server.

You say the catalog is nothing else than a catalog

So the procedure would be is use rman to backup the live database to location of the catalog or somewhere else other than the same location as the live.

Would you have the archive logs also being copied to the same server or does rman store this info in the database so the need to have physical archive logs files is it required.


0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 20380518
>Would you have the archive logs also being copied to the same server
yes

>or does rman store this info in the database
if you use RMAN for the full backup, you could/should do so for the archive logs also...

>so the need to have physical archive logs files is it required.
you need the physical log files. now, rman, if you backed up the archive log files with rman, will be able to restore the required archive log files in case they are not present in the location they are being looked for...
0
 

Author Comment

by:DarrenJackson
ID: 20443013
Angellll

Thanks for your comments no one else has contributed so I will close

Thank you for your time

Darren
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question