Home » RDBMS Server » Backup & Recovery » rman catalogt: how to register and check registration of a DB? (Oracle 10g 10.2.0.3.0, RHEL 10)
icon9.gif  rman catalogt: how to register and check registration of a DB? [message #407982] Fri, 12 June 2009 12:23 Go to next message
Mast
Messages: 5
Registered: June 2009
Junior Member
Ipm having a problem in a customer with oracle databases and backusp, i'm a total newbie concerning oracle bu since i'm at the site i need to get this solved now, here it goes:

Server1 has the rman catalog instance named "rmanrep"
sysdba user and rmanrep owner is "userA"

server2 has the database to backup called "mountain"
sysdba is "userB"

I want to check and register the "mountain" database with the rman catalog, so doing some reading i got to:

Execute:
ORACLE_SID=mountain; export ORACLE_SID
then
rman target / catalog userA/[password userA]@rmanrep
it connects succesfully showing the DBSID and all,
then i do: list backup of database;

and fails with:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 06/12/2009 13:31:38
RMAN-06428: recovery catalog is not installed


if i try to do a "register database;" i get the same error.

What am i doing wrong?, how do i check if it's registered and how do i register it?(it doesn't help that i'm not too familiar with the oracle terminology hence i posted the names so that you can give me a hand).

thanks in advance

whi
Re: rman catalogt: how to register and check registration of a DB? [message #407984 is a reply to message #407982] Fri, 12 June 2009 12:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>RMAN-06428: recovery catalog is not installed
You have to first create the catalog and then register.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmcatdb.htm#i1006260
Re: rman catalogt: how to register and check registration of a DB? [message #407985 is a reply to message #407982] Fri, 12 June 2009 13:05 Go to previous messageGo to next message
Mast
Messages: 5
Registered: June 2009
Junior Member
Thanks a million Rahesh!

i followed the instructions and first it returned "recovery catalog already exists"(which is ok as it does exist).
so i went and followed to register the database(connected with sqlplus on serverB) and what do you know! it registered!(i could swear i tired to do the exact same thing previously whilst inkering and it failed).
Anyway, now to continue with the main course of action....
Re: rman catalogt: how to register and check registration of a DB? [message #407994 is a reply to message #407985] Fri, 12 June 2009 15:27 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>> followed the instructions and first it returned "recovery catalog already exists"(which is ok as it does exist).


What you tried? Copy & Paste all the details from your SQL Session.

Babu
Re: rman catalogt: how to register and check registration of a DB? [message #408553 is a reply to message #407994] Tue, 16 June 2009 14:25 Go to previous messageGo to next message
Mast
Messages: 5
Registered: June 2009
Junior Member
Babu,
i'm not at the site right now, but according to what i've said in the original post(i think), the recovery catalog was already created and populated, the only thing missing was that the instance i was sitting on wasn't registered in it

what i did was a:
RMAN> REGISTER DATABASE;

and with that the DB registered and everything worked ok
Re: rman catalogt: how to register and check registration of a DB? [message #408625 is a reply to message #408553] Wed, 17 June 2009 01:54 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Thanks for the feedback.
Previous Topic: unable to take backup urgent
Next Topic: Refresh of database
Goto Forum:
  


Current Time: Thu Dec 08 12:36:05 CST 2016

Total time taken to generate the page: 0.09957 seconds