OraFAQ Forum: Backup & Recovery » central catalog management with RMAN

Home » RDBMS Server » Backup & Recovery » central catalog management with RMAN

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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!

Report message to a moderator

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 #253402 is a reply to message #253400]

Mon, 23 July 2007 15:14

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?

Report message to a moderator

Re: central catalog management with RMAN [message #253403 is a reply to message #253402]

Mon, 23 July 2007 15:18

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

I'm not sure about Rman Binaries.

Report message to a moderator

Re: central catalog management with RMAN [message #253404 is a reply to message #253403]

Mon, 23 July 2007 15:22

deesto
Messages: 36
Registered: March 2005
Location: NY, USA

Member

OK, thanks DreamzZ

Report message to a moderator

Re: central catalog management with RMAN [message #253423 is a reply to message #253402]

Mon, 23 July 2007 16:45

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".

Report message to a moderator

Re: central catalog management with RMAN [message #253652 is a reply to message #253423]

Tue, 24 July 2007 09:11

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.

Report message to a moderator

Re: central catalog management with RMAN [message #253654 is a reply to message #253652]

Tue, 24 July 2007 09:18

Michel Cadot
Messages: 68651
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

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)

Report message to a moderator

Re: central catalog management with RMAN [message #253669 is a reply to message #253657]

Tue, 24 July 2007 10:16

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.

Report message to a moderator

Re: central catalog management with RMAN [message #253695 is a reply to message #253669]

Tue, 24 July 2007 11:17

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.

Report message to a moderator

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 06:08:49 CDT 2024