Solved

use recovery catalog or not whats the benefit

Posted on 2007-11-29
4
681 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
  • 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

685 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