central catalog management with RMAN [message #253400] |
Mon, 23 July 2007 15:03 |
deesto
Messages: 36 Registered: March 2005 Location: NY, USA
|
Member |
|
|
I was asked whether it would be possible to install the "RMAN binaries" on a host (I'm not quite sure what this means, since RMAN was installed with Database 10g), and to install a central catalog as a repository for multiple databases on multiple servers.
Id' greatly appreciate if someone can explain what is meant by the first part ("RMAN binaries"), and give me a pointer to information or examples of the second part.
Thanks!
|
|
|
Re: central catalog management with RMAN [message #253401 is a reply to message #253400] |
Mon, 23 July 2007 15:12 |
DreamzZ
Messages: 1666 Registered: May 2007 Location: Dreamzland
|
Senior Member |
|
|
Recovery catalog is basically a database for recording status of backups of different databases.Recovery catalog is usually recommended to setup on the machine other than Production.
You can register mulitple database with your catalog.
after taking backup of your production databases its also recommened to take backup of recovery catalog database.
[Updated on: Mon, 23 July 2007 15:12] Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: central catalog management with RMAN [message #253657 is a reply to message #253654] |
Tue, 24 July 2007 09:37 |
deesto
Messages: 36 Registered: March 2005 Location: NY, USA
|
Member |
|
|
Thanks. I get the same results.
Interestingly, when I type "rman" the system hangs (Even though the PATH is correct), but when I specify the path and command name it works. I also see another copy of the file:
$ ll product/10.2.0/rdbms/bin/rman*
-rwxr-x--x 1 oracle oinstall 10633936 Jul 3 15:04 product/10.2.0/rdbms/bin/rman
-rwxr-xr-x 1 oracle oinstall 0 Nov 16 2006 product/10.2.0/rdbms/bin/rmanO
Since this version of 10g was upgraded to 10.2.0.3.0, maybe the upgrade process installs a new rman and nullifies the old version (0 bytes, 11/2006)
|
|
|
|
|
Re: central catalog management with RMAN [message #256330 is a reply to message #253695] |
Fri, 03 August 2007 17:17 |
meggens
Messages: 57 Registered: February 2007 Location: Netherlands
|
Member |
|
|
rman is installed in $ORACLE_HOME/bin when installing the database software. The repositorie ORACLE_HOME also contains an rman client. If you want to backup a database use the ORALCE_HOME of the corresponding database.
So on the database server you want to backup do following after creating the catalog: (this is on unix)
1.make sure you are user oracle
2.export ORACLE_HOME=/your_oracle_home
3.export PATH=$ORACLE_HOME/bin:$PATH
4.export ORACLE_SID=the_sid_of_the_database_to_backup
4.rman target / catalog rman_cat_owner/passwd@service_name
|
|
|