use recovery catalog or not whats the benefit
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
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
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Angellll
Thanks for your comments no one else has contributed so I will close
Thank you for your time
Darren
Thanks for your comments no one else has contributed so I will close
Thank you for your time
Darren
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.