Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

use recovery catalog or not whats the benefit

Posted on 2007-11-29
4
Medium Priority
?
700 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 2000 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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
In this article, we’ll look at how to deploy ProxySQL.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

722 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