Home » RDBMS Server » Backup & Recovery » central catalog management with RMAN
icon5.gif  central catalog management with RMAN [message #253400] Mon, 23 July 2007 15:03 Go to next message
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 Go to previous messageGo to next message
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 #253402 is a reply to message #253400] Mon, 23 July 2007 15:14 Go to previous messageGo to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
Thanks.

So, are recovery catalogs usually referred to as "RMAN binaries"? Or is that something else altogether?
Re: central catalog management with RMAN [message #253403 is a reply to message #253402] Mon, 23 July 2007 15:18 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I'm not sure about Rman Binaries.
Re: central catalog management with RMAN [message #253404 is a reply to message #253403] Mon, 23 July 2007 15:22 Go to previous messageGo to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
OK, thanks DreamzZ
Re: central catalog management with RMAN [message #253423 is a reply to message #253402] Mon, 23 July 2007 16:45 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The "RMAN binaries" are installed with the Oracle software. You can have the "RMAN binaries" without a RMAN catalog, but you can NOT have an RMAN catalog without the "RMAN binaries".
Re: central catalog management with RMAN [message #253652 is a reply to message #253423] Tue, 24 July 2007 09:11 Go to previous messageGo to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
So "RMAN binaries" refer to the rman command itself? Or is there something else?

I ask because Oracle Database 10g is already installed on this host, which implies that rman too is installed there.
Re: central catalog management with RMAN [message #253654 is a reply to message #253652] Tue, 24 July 2007 09:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.
Just type "rman":
C:\>rman

Recovery Manager: Release 10.2.0.3.0 - Production on Mar. Juil. 24 16:17:45 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> quit


Recovery Manager complete.

Assuming you correctly configured your environment.

Regards
Michel
Re: central catalog management with RMAN [message #253657 is a reply to message #253654] Tue, 24 July 2007 09:37 Go to previous messageGo to next message
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 #253669 is a reply to message #253657] Tue, 24 July 2007 10:16 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
My guess is you are on Linux and Linux has an RMAN command of it's own. You want to be sure you specify the Oracle's RMAN command.
Re: central catalog management with RMAN [message #253695 is a reply to message #253669] Tue, 24 July 2007 11:17 Go to previous messageGo to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
ebrian wrote on Tue, 24 July 2007 11:16
My guess is you are on Linux and Linux has an RMAN command of it's own. You want to be sure you specify the Oracle's RMAN command.

That's accurate. Thanks.
Re: central catalog management with RMAN [message #256330 is a reply to message #253695] Fri, 03 August 2007 17:17 Go to previous message
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

Previous Topic: SYS.DBMS_BACKUP_RESTORE in TARGET database is not current
Next Topic: How Can Configue RMAN To Auto delete unnesessary ARCHIVELOG
Goto Forum:
  


Current Time: Fri Dec 02 20:20:50 CST 2016

Total time taken to generate the page: 0.17859 seconds