Solved

use recovery catalog or not whats the benefit

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

829 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