Solved

use recovery catalog or not whats the benefit

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

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
[Unsupported] SQL Update in CRM 2011 Database 19 67
How to combine two oracle database together 9 77
Shared Service Environment 2 54
Using a combo box to search a form. 3 36
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…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
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…

752 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